1. pandas报错
ValueError: Value must be either numerical or a string containing a wildcard
2. openpyxl报错
ValueError: Unable to read workbook: could not read worksheets from C:\Users\杨\Desktop\lobbyMap1.xlsx. This is most probably because the workbook source files contain some invalid XML.
这两种报错都是因为excel文件开了筛选,关闭筛选再运行程序就行了