페르소나

Intro - Editor : sublime text3 - python 3.9.1 - pandas 1.2.1 - xlrd 2.0.1 - openpyxl 3.0.5 pandas, xlrd, openpyxl version 확인방법 참고 : (macOS)[python] Pandas Excel 다루기 - 1 : excel 읽기, 저장, df 분석 # -*- coding: utf-8 -*- import os import pandas as pd #### dir base fpath_base = './data' #### file_name, sheet_name fnames = ('A_file.csv') #### file_dir_base fpath_bases = [os.path.join(fpath_base,fname) f..

Intro - Editor : sublime text3 - python 3.8.1 - pandas 1.0.1 - xlrd 1.2.0 : excel read - openpyxl 3.0.3 : excel save pandas에서 excel을 다루기 위해서 xlrd,openpyxl module이 필요하다. import pandas as pd df = pd.read_excel('fname',sheet_name='sheet_name') ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd. ## python3 & modules(pandas, xlrd,..