Copy Pandas Dataframe To Clipboard

The aim of this playbook🏁 is to copy pandas dataframe to clipboard quickly. I import a csv first, select columns that I need and copy quickly to clipboard → and paste into a Zendesk ticket.

1. steps/notes

• Install pyperclip · PyPI
• Run

import pandas as pd
import pyperclip as clip
pd.set_option('display.max_rows', None)             
df = pd.read_csv(".\\foo.csv", usecols=[0,3,4,5])    
clip.copy(df.to_string())

• Paste into ZD ticket
• Done

2. sources

• How to Export Pandas DataFrame to CSV — by Barney H. — Towards Data Science