pandas读取excel文件

import pandas as pd

xls_file = pd.ExcelFile("examples/ex1.xlsx")
table = xls_file.parse("Sheet1")
print(table)
'''
   Unnamed: 0  a   b   c   d message
0           0  1   2   3   4   hello
1           1  5   6   7   8   world
2           2  9  10  11  12     foo
'''

 

posted @ 2021-02-20 17:07  OTAKU_nicole  阅读(259)  评论(0编辑  收藏  举报