How to import a .csv from your clipboard with Python pandas

Your colleague sends you a .csv file in slack and wants you to do some quick transformations on it.

Good news! You don't have to save these .csv files to your machine, get the file path, and load it into a pandas dataframe.

There's an easier way!

It's called pandas.read_clipboard()

How to use pandas read_clipboard()

For this example, your colleague sends you this .csv in slack with housing data. He'd like it sorted from largest to small by bedrooms.

homes_sorted.csv

Here is what the original .csv file looks like

Import data using read_clipboard()

Copy .csv to clipboard here: homes_sorted.csv

Copy
import pandas as pd
# read_clipboard attempts to read whatever is in your
# clipboard in as a .csv file. It uses read_csv() under
# the hood.
df = pd.read_clipboard(delimiter=',')
# sort data by bedrooms
sorted_df = df.sort_values(by=["bedrooms"])
# export dataframe as .csv file
sorted_df.to_csv('homes_sorted_by_bedroom.csv', index=False)

homes_sorted_by_bedroom.csv