英文:
How to set a font and size to save information in pandas?
问题
需要将提取的数据以相同的格式保存，字体使用Arial，字号为12。
目前代码的字体和字号没有遵循统一的模式。
我尝试使用utf-8命令，但没有成功。
df_conversas = pd.DataFrame({'Nomes': nomes_conversas})
df_conversas.to_excel('conversas.xlsx', encoding='utf-8', index=False)
英文:
I need to save the extracted data in the same format, Arial font size 12.
Currently the code does not follow a pattern of font and size.
I tried using the utf-8 command and it didn't work.
df_conversas = pd.DataFrame({'Nomes': nomes_conversas})
df_conversas.to_excel('conversas.xlsx', encoding='utf-8', index=False)
答案1
得分: 1
你可以使用ExcelWriter与[tag:xlsxwriter] engine：
df_conversas = pd.DataFrame({"Nomes": ["foo", "bar", "baz", "qux"]})
with pd.ExcelWriter("conversas.xlsx", engine="xlsxwriter") as writer:
df_conversas.to_excel(writer, sheet_name="Sheet1", index=False)
workbook = writer.book
workbook.formats[0].set_font_name("Arial")
workbook.formats[0].set_font_size(12)
header_format = workbook.add_format(
{"font_name": "Arial", "font_size": 12, "bold": True}
)
writer.sheets["Sheet1"].write(0, 0, "Nomes", header_format)
# 如果你有多列，可以使用以下代码：
# for idx, col in enumerate(df_conversas.columns):
# writer.sheets["Sheet1"].write(0, idx, col, header_format)
输出：
英文:
You can use ExcelWriter with an [tag:xlsxwriter] engine :
df_conversas = pd.DataFrame({"Nomes": ["foo", "bar", "baz", "qux"]})
with pd.ExcelWriter("conversas.xlsx", engine="xlsxwriter") as writer:
df_conversas.to_excel(writer, sheet_name="Sheet1", index=False)
workbook = writer.book
workbook.formats[0].set_font_name("Arial")
workbook.formats[0].set_font_size(12)
header_format = workbook.add_format(
{"font_name": "Arial", "font_size": 12, "bold": True}
)
writer.sheets["Sheet1"].write(0, 0, "Nomes", header_format)
#if you have more than a column, use this :
#for idx, col in enumerate(df_conversas.columns):
# writer.sheets["Sheet1"].write(0, idx, col, header_format)
Output :
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论