ÆÇ´Ù½º¸¦ ÀÌ¿ëÇÏ¸é ¿¢¼¿ , CSV, Json ÆÄÀÏÀ» Àбâ, ÀúÀåÀ» ½±°Ô ÇÒ¼ö ÀÖ´Ù. ¿¹Á¦¸¦ ÅëÇØ ¾Ë¾Æº¸ÀÚ. ¿¢¼¿ ÆÄÀÏÇϳªÀÇ ½ÃÆ®·Î ÀúÀåimport pandas as pd
data1 = [[10, 15, 100, 1], [100, 80, 10, 2], [80, 90, 95, 1], [50, 70, 88, 2]] df = pd.DataFrame(data1, index=['ö¼ö', '¿µÈñ', '±æµ¿', '¼øÈñ'], columns=['±¹¾î', '¿µ¾î', '¼öÇÐ', '¹Ý']) df.to_excel('d:/del/sample.xlsx') °á°ú) ¿©·¯°³ÀÇ ½ÃÆ®·Î ÀúÀåimport pandas as pd
data1 = [[10, 15, 100], [100, 80, 10], [80, 90, 95]] df = pd.DataFrame(data1, index=['ö¼ö', '¿µÈñ', '±æµ¿'], columns=['±¹¾î', '¿µ¾î', '¼öÇÐ']) data2 = [[0, 0, 100], [90, 70, 10], [80, 90, 95]] df1 = pd.DataFrame(data2, index=['¿µ¼ö', '°¡Èñ', 'ÇÏ´Ã'], columns=['±¹¾î', '¿µ¾î', '¼öÇÐ']) writer = pd.ExcelWriter('d:/del/sample2.xlsx') df.to_excel(writer, sheet_name='1¹Ý') df1.to_excel(writer, sheet_name='2¹Ý') writer.save() ÆÄÀÏ Àбâ import pandas as pd
df = pd.read_excel('d:/del/sample.xlsx') print(df) CSV ÆÄÀÏÇѱÛÀÌ ±úÁöÁö ¾Êµµ·Ï ÀúÀåimport pandas as pd
data1 = [[10, 15, 100, 1], [100, 80, 10, 2], [80, 90, 95, 1], [50, 70, 88, 2]] df = pd.DataFrame(data1, index=['ö¼ö', '¿µÈñ', '±æµ¿', '¼øÈñ'], columns=['±¹¾î', '¿µ¾î', '¼öÇÐ', '¹Ý']) df.to_csv('d:/del/sample.csv', encoding='euc-kr') encoding ¿É¼ÇÀ» ÁÖÁö ¾Ê°Å³ª utf·Î ÀúÀåÇϸé ÇѱÛÀÌ ±úÁø´Ù. 'euc-kr'À̳ª 'cp949'·Î ÀúÀåÇØ¾ß ÇѱÛÀÌ ±úÁöÁö ¾Ê´Â´Ù. df.to_csv('d:/del/sample.csv', encoding='euc-kr') df.to_csv('d:/del/sample_cp.csv', encoding='cp949') csv ÆÄÀÏ ·Îµùimport pandas as pd
df = pd.read_csv('d:/del/sample.csv', encoding= 'euc-kr') print(df) encoding= 'euc-kr' ¿É¼ÇÀ¸·Î ÀúÀåÇÑ°Ç ·Îµù ÇÒ¶§µµ encoding= 'euc-kr' ¿É¼ÇÀ» Áà¾ß Á¦´ë·Î ·ÎµùÀÌ µÈ´Ù. encoding= 'euc-kr' ¿É¼ÇÀ» ³ÖÁö ¾ÊÀ¸¸é ÄÚµå ¿¡·¯¸¦ ¹ß»ý ÇÏ¸é¼ ½ÇÇà µÇÁö ¾Ê´Â´Ù. ÁöÁ¤µÈ À妽º¿Í Ä®·³¾øÀÌ ÀúÀåimport pandas as pd
data1 = [[10, 15, 100, 1], [100, 80, 10, 2], [80, 90, 95, 1], [50, 70, 88, 2]] df = pd.DataFrame(data1) df.to_csv('d:/del/sample.csv') °á°ú) À妽º¸¦ Á¦°Å ÇÏ°í ÀúÀå ÇÒ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇÑ´Ù. import pandas as pd
data1 = [[10, 15, 100, 1], [100, 80, 10, 2], [80, 90, 95, 1], [50, 70, 88, 2]] df = pd.DataFrame(data1) df.to_csv('d:/del/sample.csv', index=False) index=False ¿É¼ÇÀ» Áà¾ß ÇÑ´Ù. ·Îµù½Ã À妽º¿Í Ä®·³ ÁöÁ¤Çϱâimport pandas as pd
df = pd.read_csv('d:/del/sample.csv') df.index = ['ö¼ö', '¿µÈñ', '¼øÈñ', 'Áö¼º'] df.columns = ['±¹¾î', '¿µ¾î', '¼öÇÐ', '¹Ý'] print(df) °á°ú) ±¹¾î ¿µ¾î ¼öÇÐ ¹Ý ö¼ö 10 15 100 1 ¿µÈñ 100 80 10 2 ¼øÈñ 80 90 95 1 Áö¼º 50 70 88 2 Json ÆÄÀÏÆÄÀÏ ÀúÀåimport pandas as pd
data1 = [[10, 15, 100, 1], [100, 80, 10, 2], [80, 90, 95, 1], [50, 70, 88, 2]] df = pd.DataFrame(data1, index=['ö¼ö', '¿µÈñ', '±æµ¿', '¼øÈñ'], columns=['±¹¾î', '¿µ¾î', '¼öÇÐ', '¹Ý']) df.to_json('d:/del/sample.json') ÆÄÀÏ ÀúÀåÀº ÀÌ·¸°Ô µÈ´Ù.... ÇѱÛÀÌ ÀÌ·¸°Ô µÇ¹ö¸®°í json ÆÄÀÏ ÀúÀå Çü½ÄÀÌ ÀÌ»ÚÁö ¾Ê´Ù. {"\uad6d\uc5b4":{"\ucca0\uc218":10,"\uc601\ud76c":100,"\uae38\ub3d9":80,"\uc21c\ud76c":50}, "\uc601\uc5b4":{"\ucca0\uc218":15,"\uc601\ud76c":80,"\uae38\ub3d9":90,"\uc21c\ud76c":70}, "\uc218\ud559":{"\ucca0\uc218":100,"\uc601\ud76c":10,"\uae38\ub3d9":95,"\uc21c\ud76c":88},"\ubc18": {"\ucca0\uc218":1,"\uc601\ud76c":2,"\uae38\ub3d9":1,"\uc21c\ud76c":2}} µé¿©¾²±â´Â 4Ä, ÇѱÛÀ» ¾Æ½ºÅ°·Î ¹Ù²Ù´Â°ÍÀ» ¸·±â À§ÇØ force_ascii´Â False·Î ¼³Á¤import pandas as pd
data1 = [[10, 15, 100, 1], [100, 80, 10, 2], [80, 90, 95, 1], [50, 70, 88, 2]] df = pd.DataFrame(data1, index=['ö¼ö', '¿µÈñ', '±æµ¿', '¼øÈñ'], columns=['±¹¾î', '¿µ¾î', '¼öÇÐ', '¹Ý']) df.to_json('d:/del/sample.json', indent=4, force_ascii=False) °á°ú) ÇѱÛÀÌ ±úÁ®¼ ³ª¿Â´Ù. µé¿©¾²±â, Çѱ۵µ Àß ³ª¿Èimport pandas as pd
data1 = [[10, 15, 100, 1], [100, 80, 10, 2], [80, 90, 95, 1], [50, 70, 88, 2]] df = pd.DataFrame(data1, index=['ö¼ö', '¿µÈñ', '±æµ¿', '¼øÈñ'], columns=['±¹¾î', '¿µ¾î', '¼öÇÐ', '¹Ý']) with open('d:/del/sample.json', 'w', encoding='utf-8') as file: df.to_json(file, indent=4, force_ascii=False) ´ÙÀ½Ã³·³ ÇÏ¸é µÈ´Ù. with open('d:/del/sample.json', 'w', encoding='utf-8') as file: df.to_json(file, indent=4, force_ascii=False) °á°ú) ÆÄÀÏ ·Îµù import pandas as pd
df = pd.read_json('d:/del/sample.json') print(df) °á°ú) ±¹¾î ¿µ¾î ¼öÇÐ ¹Ý ö¼ö 10 15 100 1 ¿µÈñ 100 80 10 2 ±æµ¿ 80 90 95 1 ¼øÈñ 50 70 88 2 Âü°í) json ÆÄÀÏ Àбâ, ÀúÀå https://devpouch.tistory.com/33 |