1. panda.read_excel() 碰到 excel文件不可读的错误:
xlrd.biffh.XLRDError: Excel xlsx file; not supported
这种情况需要卸载重装xlrd库:
pip uninstall xlrd
pip install xlrd==1.2.0
2. pandas read .txt files as df that with '\t' or anything else as sep:
df = pd.read_csv('*.txt',sep='\t',header=None)