Create Pandas DataFrame from a string

by

A simple way to do this is to use StringIO.StringIO (python2) or io.StringIO (python3) and pass that to the pandas.read_csv function. E.g:

import sys
if sys.version_info[0] < 3: 
    from StringIO import StringIO
else:
    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=";")

More Related Contents:

  1. pandas read_csv and filter columns with usecols
  2. Filter string data based on its string length
  3. Pandas read_csv dtype leading zeros
  4. pandas – convert string into list of strings [duplicate]
  5. Import multiple csv files into pandas and concatenate into one DataFrame
  6. Writing a pandas DataFrame to CSV file
  7. Pandas read_csv from url
  8. Python Pandas Error tokenizing data
  9. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  10. pandas dataframe str.contains() AND operation
  11. Pandas Extract Number from String
  12. Add Leading Zeros to Strings in Pandas Dataframe
  13. Pandas column access w/column names containing spaces
  14. selecting across multiple columns with python pandas?
  15. import text to pandas with multiple delimiters
  16. Converting a column within pandas dataframe from int to string
  17. How to read a column of csv as dtype list using pandas?
  18. Print very long string completely in pandas dataframe
  19. Panda’s Write CSV – Append vs. Write
  20. python pandas read_csv delimiter in column data
  21. Read csv from Google Cloud storage to pandas dataframe
  22. Pandas dataframe read_csv on bad data
  23. Conditional row read of csv in pandas
  24. Calculate summary statistics of columns in dataframe
  25. How to use str.contains() with multiple expressions in pandas dataframes
  26. double quoted elements in csv cant read with pandas
  27. how to specify the datetime format in read_csv
  28. UnicodeDecodeError when reading CSV file in Pandas
  29. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  30. Pandas df.to_csv(“file.csv” encode=”utf-8″) still gives trash characters for minus sign

Leave a Comment