我有个这样的Excel,第一行是列名,之后的行是数据。
如果想要按照列名访问每个单元格的数据怎么办?
import pandas as pd
if __name__=="__main__":
d = pd.read_excel(path, sheet_name=None)
for index, row in d['Sheet1'].iterrows():
print(row['data'])
这样打印出来的就是sql语句 INSER ... ....
Excel里为空的项读出来却是NAN,如果将其替换为“”?
df= d['Sheet1'].replace(np.nan,'', regex=True)
pip install -r requirements.txt -i https://pypi.douban.com/simple
写Excel指定sheet名:
import pandas as pd
writer = pd.ExcelWriter(r'C:\Users\venkagop\Subbu\mytest.xls')
df.to_excel(writer, sheet_name='MySheetName', index=False)
writer.save()