读取excel数据:dataframe = pd.read_excel('C:\Users\dell\Desktop\zs\code_jinjiu\分析.xlsx',sheet_name='新数据')
读取txt文件为dataframe:all1 = pd.read_csv(r"C:\Users\dell\Desktop\zs\sample.txt",sep=',',encoding='utf-8')
读取csv文件:all1 = pd.read_csv(r"C:\Users\dell\Desktop\zs\sample.csv",header=0)#或index = None