Python

ยท[Language]/Python
๋‚ด๊ฐ€ ๊ฐ€์ง„ data์˜ datetime column์€ ๋‚ ์งœ์™€ ์‹œ๊ฐ„์ด ๊ฐ™์ด ๋“ค์–ด๊ฐ€์žˆ๋‹ค. ์•„์ง์€ day & time์„ ํ•œ๋ฒˆ์— ์ธ์‹ํ•˜๊ณ  ์ •๋ ฌํ•ด์ฃผ๋Š” ๊ธฐ๋Šฅ์„ ์ฐพ์ง€ ๋ชปํ–ˆ๊ธฐ ๋•Œ๋ฌธ์— (์—†์„ ํ™•๋ฅ ์ด ๋” ํผ ใ… ใ…‹ใ…‹) ๋‚ ์งœ ๋”ฐ๋กœ, ์‹œ๊ฐ„ ๋”ฐ๋กœ col์„ ๋ถ„๋ฆฌํ•ด์ค„ ๊ฒƒ์ด๋‹ค. ์ผ๋‹จ csv ํŒŒ์ผ์„ ๋ถˆ๋Ÿฌ์˜ฌ ๋•Œ parse_dates๋ฅผ ์ด์šฉํ•ด์„œ datetime์„ ๋‚ ์งœ๋กœ ๋ถˆ๋Ÿฌ์˜จ๋‹ค. bike_data_2011_2012["date"] = [d.date() for d in bike_data_2011_2012['datetime']] bike_data_2011_2012["time"] = [d.time() for d in bike_data_2011_2012['datetime']] ์œ„ ์ฝ”๋“œ๋ฅผ ์ž…๋ ฅํ•œ ํ›„, head()๋กœ ๋ณด๋ฉด ์ง  ! ๋งจ ์šฐ์ธก date, ti..
ยท[Language]/Python
์ด data๋“ค์„ ์•„๋ž˜์ฒ˜๋Ÿผ ์ €์žฅํ•˜๊ณ  ์‹ถ์—ˆ์œผ๋‚˜ ์ด์ƒํ•œ Unnamed column์ด ์•ž์— ์ถ”๊ฐ€๋˜์–ด ์ €์žฅ๋˜์—ˆ๋‹ค. ๋•๋ถ„์— row data๋“ค์ด 17,379๊ฐœ ์žˆ๋‹ค๋Š” ๊ฒƒ์„ ์•Œ๊ฒŒ ๋˜์—ˆ์œผ๋‚˜ Unnamed col์„ ์—†์• ๋ฒ„๋ฆฌ๊ณ  ์‹ถ์—ˆ๋‹ค. dataframe_name.to_csv("filename.csv", index=None) index = None ์„ ์šฐ์ธก์— ์ ์–ด์ฃผ๋‹ˆ๊นŒ Unnamed๊ฐ€ ์‚ฌ๋ผ์กŒ๋‹ค
soheepark
'Python' ํƒœ๊ทธ์˜ ๊ธ€ ๋ชฉ๋ก