如何使用python将.csv文件转换为.md

Question

输入csv文件内容：

Loop Count,1000,,,,,
Data1,Artefact,,,,,
,TWHashTable,,,,,
, ,Insert,TBB:892,TW:6242,,
, ,Find,TBB:203,TW:721,,
, ,DeleteAll,TBB:33,TW:1372369,,
Data2,Artefact,,,,,
,TWUtils,,,,
, ,Insert,TBB:892,TW:6242,,
, ,Find,TBB:203,TW:721,,
, ,DeleteAll,TBB:33,TW:1372369,,

预期输出：

>FIEDD5插入查找插入查找

循环计数	1000	FIELD3	FIELD
数据1		艺术
	TWHashTable
			TBB:892	TW:6242
			TBB:203	TW:721
	全部删除		TBB:33		TW:1372369
数据2
	TWUtils
			TBB:892	TW:6242
			TBB:203	TW:721
	全部删除		TBB:33		TW:1372369

import pandas as pd
df = pd.read_csv("your_csv_file.csv")
with open("my_markdown.md", 'w') as md:
df.to_markdown(buf=md, tablefmt="grid")

点击此处查看更多

Answer 1

解决方案：

df = pd.read_csv(csvFile, engine='python')
with open("my_markdown.md", 'w') as md:
df.fillna('', inplace=True)
df.to_markdown(buf=md, index=False)