Menu Close

How to create Pandas DataFrame from a string with Python?

Sometimes, we want to create Pandas DataFrame from a string with Python.

In this article, we’ll look at how to create Pandas DataFrame from a string with Python.

How to create Pandas DataFrame from a string with Python?

To create Pandas DataFrame from a string with Python, we can use the StringIO module.

For instance, we write:

from io import StringIO
import pandas as pd

TESTDATA = StringIO("""col1;col2;col3
    1;4.4;99
    2;4.5;200
    3;4.7;65
    4;3.2;140
    """)

df = pd.read_csv(TESTDATA, sep=";")
print(df)

We have the TESTDATA string with some CSV test data.

Then we call read_csv with TESTDATA to read the string into a DataFrame.

We set the sep parameter to set the separator used by the CSV string so the data will parse correctly.

Therefore, df is:

   col1  col2  col3
0     1   4.4    99
1     2   4.5   200
2     3   4.7    65
3     4   3.2   140

Conclusion

To create Pandas DataFrame from a string with Python, we can use the StringIO module.

Posted in Python, Python Answers