如何使 CSV 文件中的所有鏈接都指向超鏈接？- 只需將 HTML 標簽添加到所有帶有鏈接的字段我認為可以通過 PythonCSV 字符串看起來像"Name","CompanyName","Value1","Value2","Value3","Value4","Value5","Value6","Value7","Url","Value8 ""Value8.1""""Name","Company1","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","https://company1.com","Some"Value8 ""Value8.1""""Name","Company2","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","https://company2.com","Some"Value8 ""Value8.1"""應該看起來像："Name","CompanyName","Value1","Value2","Value3","Value4","Value5","Value6", "Value7","Url","Value8""Name","Company1","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","<a href="https://company1.com">https://company1.com</a>","Some"Value8 ""Value8.1""""Name","Company2","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","<a href="https://company2.com">https://company2.com</a>","Some"Value8 ""Value8.1""""Name","Company3","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","<a href="https://company3.com">https://company3.com</a>","Some"Value8 ""Value8.1"""我嘗試了 awk 和 sed，但是當我在文件中指定一列時會出錯。我覺得腳本應該找到所有鏈接并將其插入 HTML 標簽。但我還不明白它是如何工作的
1 回答
不負相思意
TA貢獻1777條經驗 獲得超10個贊
這是一個快速而骯臟的例子，說明如何做到這一點。您可以在此處查看 csv 模塊的示例
您的示例數據有一些額外的空格 - 如果您的真實數據是這樣的，您可以使用該strip()方法刪除空格。
如果您的 URL 在同一列中不一致，那么這將不起作用，您將需要使用 regex 或 urllib 來識別它們。
import csv
count = 0
with open('test.csv', 'r') as f:
csv_reader = csv.reader(f)
with open('outfile.csv', 'w') as outfile:
for row in csv_reader:
row[0] = f'"{row[0]}'
if count < 1:
outfile.write('","'.join(row) + '"\n')
count += 1
else:
row[-2] = f'<a href="{row[-2]}">{row[-2]}</a>'
outfile.write('","'.join(row) + '"\n')
添加回答
舉報
0/150
提交
取消