파이썬 dataframe 생성, 추가, 수정

*dataframe 생성

 

cols = ['이름', '나이', '성별']
df = pd.DataFrame(columns=cols)

 

 

*dataframe 인덱스로 조회, 수정

 

df.loc[index, '나이'] = 13

 

 

*dataframe 이어 붙이기

 

df = pd.concat([df1, df2])

 

*dataframe 열 추가 (컬럼, column)

 

df.loc[:, '주소'] = pd.Series([""] * len(df), index=df.index)
df['주소'] = pd.Series([""] * len(df), index=df.index)

 

*dataframe 행 추가 (로우, row)

 

df = df.append(df.loc[index], ignore_index=True)

 

*엑셀 읽어오기 -> dataframe

df1 = pd.read_excel("test.xlsx", sheet_name="첫번째시트", header=2, usecols='B:F')

 

* datafram -> 엑셀 내보내기

 

 

import xlsxwriter

 

writer = pd.ExcelWriter("result.xlsx", engine="xlsxwriter")
emp1.to_excel(writer, sheet_name='첫번째 시트')
emp2.to_excel(writer, sheet_name='두번째 시트')

data_column = 15
worksheet = writer.sheets['첫번째 시트']
worksheet.set_column('B:F', 10)
worksheet.set_column('G:J', data_column)
worksheet2 = writer.sheets['두번째 시트']
worksheet2.set_column('B:F', 10)
worksheet2.set_column('G:J', data_column)
writer.save()

 

 

* 참고

www.delftstack.com/ko/howto/python-pandas/how-to-add-one-row-to-pandas-dataframe/

hogni.tistory.com/7

shydev.tistory.com/29

wikidocs.net/14305

www.delftstack.com/ko/howto/python/how-to-convert-string-to-datetime/

ponyozzang.tistory.com/619

korbillgates.tistory.com/148

yganalyst.github.io/data_handling/Pd_12/