所以我有超過 100 萬條記錄的 csv 文件：（https://i.imgur.com/rhIhy5u.png）我需要以不同的方式排列數(shù)據(jù)，使重復(fù)的“參數(shù)”成為列/行本身，例如 category1、category2、category3 （有20多個類別，沒有重復(fù)）但所有數(shù)據(jù)都保持它們的關(guān)系。我嘗試在 python 中使用“pandas”和“csv”，但我對它完全陌生，我從來沒有與這樣的數(shù)據(jù)有任何關(guān)系。import csvwith open('./data.csv', 'r') as _filehandler: csv_file_reader = csv.reader(_filehandler) param = []; csv_file_reader = csv.DictReader(_filehandler) for row in csv_file_reader: if not row['Param'] in param: param.append(row['Param']); col = ""; for p in param: col += str(p) + '; '; print(col); import numpy as np np.savetxt('./SortedWexdord.csv', (parameters), delimiter=';', fmt='%s')我想過，但數(shù)據(jù)不是我的強項，有什么想法嗎？
1 回答
慕斯709654
TA貢獻1840條經(jīng)驗 獲得超5個贊
這是應(yīng)該起作用的東西。如果您需要像這樣標準化的每行多個值，您可以編輯第 9 行（開始category）以獲取值列表，而不僅僅是row[1].
import csv
data = {}
with open('data.csv', 'r') as file:
reader = csv.reader(file)
next(reader) # Skip header row
for row in reader:
category, value = row[0], row[1] # Assumes category is in column 0 and target value is in column 1
if category in data:
data[category].append(value)
else:
data[category] = [value] # New entry only for each unique category
with open('output.csv', 'wb') as file: # wb is write and binary, avoids double newlines on windows
writer = csv.writer(file)
writer.writerow(['Category', 'Value'])
for category in data:
print([category] + data[category])
writer.writerow([category] + data[category]) # Make a list starting with category and then listing each value
添加回答
舉報
0/150
提交
取消