Generating Readme Tables From Pandas
I commonly have a need to paste the first few lines of a dataset into a markdown file. I use two handy packages to do this,
pyperclip. Lets say I have a Pandas DataFrame in memory as
df already. All I would need to do to convert the first 5 rows to markdown and copy it to the clipboard is the following.
from tabulate import tabulate import pyperclip md = tabulate.tabulate(df.head(), df.columns, tablefmt='pipe') pyperclip.copy(md)
This is a super handy snippet that I use a lot. Folks really appreciate it when they can see a sample of the data without opening the entire file.