๐ ๊ณต๋ถํ๋ ์ง์ง์ํ์นด๋ ์ฒ์์ด์ง?
ํ์ด์ฌ pandas ์ฌ๋ฌ ํด๋ ๋ด csv ๋ถ๋ฌ์ค๊ธฐ ๋ณธ๋ฌธ
๐ฉ๐ป ์ปดํจํฐ ๊ตฌ์กฐ/etc
ํ์ด์ฌ pandas ์ฌ๋ฌ ํด๋ ๋ด csv ๋ถ๋ฌ์ค๊ธฐ
์ง์ง์ํ์นด 2022. 12. 5. 16:43728x90
๋ฐ์ํ
์ฌ๋ฌ ํด๋ ์์ csv ๋ถ๋ฌ์ค๊ธฐ
์ฝ๊ฐ ๋ ธ๊ฐ๋ค... ใ
ํด๋๋ง๋ค ๋ ์ง๋ณ๋ก ๋ค๋ฅธ csv ํ์ผ์ด ์๊ธฐ ๋๋ฌธ์
๊ฐ์ ํ์ผ๋ช ์ ๊ฐ์ง csv ํ์ผ๋ผ๋ฆฌ concat ํ ์์ ~~~~
๐ธ ํด๋ load
# Load the data
forder_list = os.listdir("./DATA")
forder_list
๐ธ csv ๊ฒฝ๋ก ๋ฆฌ์คํธ ์์ฑ
csv1 = []
csv2 = []
csv3 = []
csv4 = []
csv5 = []
csv6 = []
for forder in forder_list :
paths = "./DATA/" + forder + "/"
# print(paths)
file_path = sorted(os.listdir(paths))
# print(file_path)
csv1.append(paths + file_path[0])
csv2.append(paths + file_path[1])
csv3.append(paths + file_path[2])
csv4.append(paths + file_path[3])
csv5.append(paths + file_path[4])
csv6.append(paths + file_path[5])
๐ธ ๊ฐ์ csv ๋ผ๋ฆฌ ํ๋์ dataframe์ผ๋ก concat ํ๊ธฐ (axis = 0)
allData = [] # ์ฝ์ด ๋ค์ธ csvํ์ผ ๋ด์ฉ์ ์ ์ฅํ ๋น ๋ฆฌ์คํธ๋ฅผ ํ๋ ๋ง๋ ๋ค
for file in csv1:
df = pd.read_csv(file) # for๊ตฌ๋ฌธ์ผ๋ก csvํ์ผ๋ค์ ์ฝ์ด ๋ค์ธ๋ค
allData.append(df) # ๋น ๋ฆฌ์คํธ์ ์ฝ์ด ๋ค์ธ ๋ด์ฉ์ ์ถ๊ฐํ๋ค
์ด์ฐจํผ ๊ฐ์ ์์ฑ์ ๊ฐ์ง csv ํ์ผ์ด๋ผ axis = 0 ์ผ๋ก concat
dataCombine = pd.concat(allData, axis=0, ignore_index=True)
์์ฑ~
728x90
๋ฐ์ํ
'๐ฉโ๐ป ์ปดํจํฐ ๊ตฌ์กฐ > etc' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
ํ์ด์ฌ pandas ์ฌ๋ฌ plot ๋ถ๋ฌ์ค๊ธฐ (0) | 2022.12.07 |
---|---|
์๋ฐ์คํฌ๋ฆฝํธ slice๋ก ๋ฐฐ์ด 10์นธ์ฉ ์ฎ๊ธฐ๊ธฐ with ์ค์ผ์ค๋ง (0) | 2022.11.18 |
๋ชจ๋ธ ๋งค๊ฐ๋ณ์ ์ต์ ํ [์ตํฐ๋ง์ด์ , ์์คํจ์, ํ์ดํผํ๋ผ๋ฏธํฐ] (0) | 2022.09.22 |
"Ctrl + Shift + R " & "Ctrl + F5" & "F5" ์ฐจ์ด์ (0) | 2022.09.15 |
๋์ค์ ์ฐธ๊ณ ํ ์ฝ๋ ์์ค (0) | 2022.09.14 |
Comments