chars = list(range(0,10))
numbers_list = list(range(0,25))
for comb in itertools.combinations_with_replacement(chars, 5):
for A in numbers_list:
pure = str(A) ':' str(comb)
B = pure.replace(")", "").replace("(", "").replace("'", "").replace(",", "").replace(" ", "")
C = hashlib.sha256(B.encode('utf-8')).hexdigest()
rows = [A , str(B), str(C)]
print(rows)
header = ['A', 'B', 'C']
with open('data.csv', 'w', encoding='UTF8', newline='') as f:
writer = csv.writer(f)
writer.writerow(header)
writer.writerow(rows)
print('end')
大家下午好，我遇到了未創建 csv 檔案的問題。這些行在 IDE 中列印出來，但是當腳本在幾個小時后運行完所有組合行時，它不會創建包含這些行的 CSV 檔案。我對python編程有點陌生。我將非常感謝您的幫助！謝謝！
uj5u.com熱心網友回復：
John Gordon是正確的，您需要將每一行保留在一個串列中，然后在將每一行寫入 csv 檔案時遍歷該串列
這個腳本對我有用
import itertools, hashlib, csv
data = []
chars = list(range(0,10))
numbers_list = list(range(0,25))
for comb in itertools.combinations_with_replacement(chars, 5):
for A in numbers_list:
pure = str(A) ':' str(comb)
B = pure.replace(")", "").replace("(", "").replace("'", "").replace(",", "").replace(" ", "")
C = hashlib.sha256(B.encode('utf-8')).hexdigest()
rows = [A , str(B), str(C)]
data.append(rows)
header = ['A', 'B', 'C']
with open('data.csv', 'w', encoding='UTF8', newline='') as f:
writer = csv.writer(f)
writer.writerow(header)
for row in data:
writer.writerow(row)
print('end')
uj5u.com熱心網友回復：
我會建議一個更簡單的方法。你有沒有考慮過使用 pandas 模塊來完成這種作業？Pandas 模塊將讓您更輕松地保存到 csv、xls... 嘗試一下。
import itertools
import hashlib
import pandas as pd
chars = list(range(0,10))
numbers_list = list(range(0,25))
rows = []
for combination in itertools.combinations_with_replacement(chars, 5):
for number in numbers_list:
pure_number_a = str(number) ':' str(combination)
pure_number_b = pure_number_a.replace(")", "").replace("(", "").replace("'", "").replace(",", "").replace(" ", "")
pure_number_c = hashlib.sha256(pure_number_b.encode('utf-8')).hexdigest()
rows.append([pure_number_a , pure_number_b, pure_number_c])
df = pd.DataFrame(data=rows, columns=['A', 'B', 'C'])
df.to_csv('data.csv', index=False)
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/529509.html
標籤：PythonCSV
上一篇：如何將我的一個長列名分成列