我有一長串 DMS 值，如下所示。
lst = ['9', '22', '26.9868', 'N',
'118', '23', '48.876', 'E',
'9', '22', '18.6132', 'N',
'118', '23', '5.2188', 'E',
'9', '19', '41.4804', 'N',
'118', '19', '23.1852', 'E']
我想將此資料寫入以下格式的 csv 檔案：
uj5u.com熱心網友回復：
您可以使用numpy和pandas：
lst = ['9', '22', '26.9868', 'N',
'118', '23', '48.876', 'E',
'9', '22', '18.6132', 'N',
'118', '23', '5.2188', 'E',
'9', '19', '41.4804', 'N',
'118', '19', '23.1852', 'E']
import numpy as np
import pandas as pd
(pd.DataFrame(np.array(lst).reshape(-1,4),
columns=['deg', 'min', 'sec', 'direction'])
.to_csv('filename.csv', index=False)
)
輸出檔案（作為文本）：
deg,min,sec,direction
9,22,26.9868,N
118,23,48.876,E
9,22,18.6132,N
118,23,5.2188,E
9,19,41.4804,N
118,19,23.1852,E
uj5u.com熱心網友回復：
如果lst是您問題中的串列，您可以執行以下操作：
import csv
with open("data.csv", "w") as f_out:
csv_writer = csv.writer(f_out)
i = iter(lst)
csv_writer.writerow(["deg", "min", "sec", "direction"])
for t in zip(*[i] * 4):
csv_writer.writerow(t)
這寫道data.csv：
deg,min,sec,direction
9,22,26.9868,N
118,23,48.876,E
9,22,18.6132,N
118,23,5.2188,E
9,19,41.4804,N
118,19,23.1852,E
來自 LibreOffice 的螢屏截圖：
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/461474.html
上一篇：為整個表撰寫查詢