我正在努力将逗号分隔的列表转换为多列(7)数据帧。
print (type(mylist))
<type 'list'>
Print(mylist)
['AN,2__AAS000,26,20150826113000,-283.000,20150826120000,-283.000', 'AN,2__AE000,26,20150826113000,0.000,20150826120000,0.000',.........下面创建了一个单列的框架:
df = pd.DataFrame(mylist)我已经检查了Pandas内置的csv功能,但是我的csv数据保存在一个列表中。如何才能简单地将列表转换为7列数据框。
提前谢谢。
发布于 2015-08-26 19:01:38
您需要拆分列表中的每个字符串:
import pandas as pd
df = pd.DataFrame([sub.split(",") for sub in l])
print(df)输出:
0 1 2 3 4 5 6
0 AN 2__AS000 26 20150826113000 -283.000 20150826120000 -283.000
1 AN 2__A000 26 20150826113000 0.000 20150826120000 0.000
2 AN 2__AE000 26 20150826113000 -269.000 20150826120000 -269.000
3 AN 2__AE000 26 20150826113000 -255.000 20150826120000 -255.000
4 AN 2__AE00 26 20150826113000 -254.000 20150826120000 -254.000如果您知道在csv中要跳过多少行,那么可以使用read_csv和skiprows=lines_of_metadata完成所有操作。
import pandas as pd
df = pd.read_csv("in.csv",skiprows=3,header=None)
print(df)或者,如果元数据的每一行都以某个字符开头,则可以使用注释:
df = pd.read_csv("in.csv",header=None,comment="#") 如果需要指定多个字符,可以组合使用itertools.takewhile,这将删除以xxx开头的行
import pandas as pd
from itertools import dropwhile
import csv
with open("in.csv") as f:
f = dropwhile(lambda x: x.startswith("#!!"), f)
r = csv.reader(f)
df = pd.DataFrame().from_records(r)使用您的输入数据添加一些以#!!开头的行:
#!! various
#!! metadata
#!! lines
AN,2__AS000,26,20150826113000,-283.000,20150826120000,-283.000
AN,2__A000,26,20150826113000,0.000,20150826120000,0.000
AN,2__AE000,26,20150826113000,-269.000,20150826120000,-269.000
AN,2__AE000,26,20150826113000,-255.000,20150826120000,-255.000
AN,2__AE00,26,20150826113000,-254.000,20150826120000,-254.000输出:
0 1 2 3 4 5 6
0 AN 2__AS000 26 20150826113000 -283.000 20150826120000 -283.000
1 AN 2__A000 26 20150826113000 0.000 20150826120000 0.000
2 AN 2__AE000 26 20150826113000 -269.000 20150826120000 -269.000
3 AN 2__AE000 26 20150826113000 -255.000 20150826120000 -255.000
4 AN 2__AE00 26 20150826113000 -254.000 20150826120000 -254.000发布于 2019-03-16 16:23:35
您可以通过以下方式将列表转换为7列数据框:
import pandas as pd
df = pd.read_csv(filename, sep=',')发布于 2018-08-08 13:29:33
我遇到了类似的问题。我是用这种方法解决的。
def lrsplit(line):
left, *_ , right = line.split('-')
mid = '-'.join(_)
return left, mid, right.strip()
example = pd.DataFrame(lrsplit(line) for line in open("example.csv"))
example.columns = ['location', 'position', 'company']结果:
location position company
0 india manager intel
1 india sales-manager amazon
2 banglore ccm- head - county jp morganhttps://stackoverflow.com/questions/32224363
复制相似问题