모두야

python xlsx to csv 본문

study/Python_study

python xlsx to csv

미미밍2 2021. 8. 3. 00:11
반응형
pip install xlrd
pip install openpyxl
pip install pandas
# xlsx to csv

import pandas as pd
xlsx = pd.read_excel("이름.xlsx")
xlsx.to_csv("이름.csv")​
# csv to xlsx

import pandas as pd
xlsx = pd.read_csv("경로.csv")
xlsx.to_xlsx("경로.xlsx")
반응형