Is there a way to read a cell as a file in a Jupyter Notebook?

General
1

I want to embed all content within a single ipynb file. Is there a way to include a csv file as a cell and read from that?

2

You can build your CSV content into a cell. You need to bookend the content of the CSV so that it can be used as Python code. I like to use a doc string for that.

In code below the first cell is between the comments, with your CSV content put there, and then in another cell you can read it in using StringIO. StringIO allows a string object to be handled by methods that take a file. Below is based on the example in official Pandas documentation.

# FIRST CELL
a_string ='''
A,   B,    C
a1,  b1,  c1
a2,  b2,  c2
a3,  b3,  c3
'''
#------------

# IN ANOTHER CELL
import io
import pandas as pd
df = pd.read_csv(io.StringIO(a_string))
3

Thanks, this approach seems very reasonable.

1 Like