我正在编写一个脚本,它将一堆txt文件读入pandas进行数据处理。文本文件的示例如下:
0000000000000e+000,0.05844309,0.05078511
5000000000000e-001,0.05802771,0.01336614
0000000000000e-001,0.1123048,0.008524402
5000000000000e-001,0.1359783,0.005294179
0000000000000e+000,0.1028109,0.004224583
2500000000000e+000,0.1182408,0.005825941
(不包括行中的间隙)
我的密码是:
os.chdir(ProcessedDataPath) #Path to the overall folder
PandasFilePath = 'Run_Data00001.txt' #this being the data file I'm reading
Data_RAW = pd.read_csv(PandasFilePath, header = None)
Data_RAW = Data_RAW.astype(float)
Data_Frame = pd.DataFrame(Data_RAW,columns=["Hz", "N", "m/s2"])
它没有抛出任何错误,列名是正确的,但是,尽管所有读入Data_Raw的值都是正确的,但“Data_Frame”中的所有值都是NaN。
我已经尝试删除NaN值或更改数据类型,但似乎没有任何东西可以正确读取Data_Frame。
1条答案
按热度按时间nwo49xxi1#
尝试创建传递numpy数组而不是dataframe到
pd.DataFrame
构造器:这将打印:
我建议只设置
Data_RAW
的.column
属性: