How to read a column of csv as dtype list using pandas?

by

You could use the ast lib:

from ast import literal_eval


df.Col3 = df.Col3.apply(literal_eval)
print(df.Col3[0][0])
Proj1

You can also do it when you create the dataframe from the csv, using converters:

df = pd.read_csv("in.csv",converters={"Col3": literal_eval})

If you are sure the format is he same for all strings, stripping and splitting will be a lot faster:

 df = pd.read_csv("in.csv",converters={"Col3": lambda x: x.strip("[]").split(", ")})

But you will end up with the strings wrapped in quotes

More Related Contents:

  1. Import multiple csv files into pandas and concatenate into one DataFrame
  2. Writing a pandas DataFrame to CSV file
  3. Pandas read_csv from url
  4. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  5. Python Pandas Error tokenizing data
  6. How to read a file with a semi colon separator in pandas
  7. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  8. pandas read_csv and filter columns with usecols
  9. selecting across multiple columns with python pandas?
  10. import text to pandas with multiple delimiters
  11. Pandas: ValueError: cannot convert float NaN to integer
  12. Using numpy.genfromtxt to read a csv file with strings containing commas
  13. How to keep leading zeros in a column when reading CSV with Pandas?
  14. Use Multiple Character Delimiter in Python Pandas read_csv
  15. Get pandas.read_csv to read empty values as empty string instead of nan
  16. Panda’s Write CSV – Append vs. Write
  17. Loading multiple csv files of a folder into one dataframe
  18. python pandas read_csv delimiter in column data
  19. Read csv from Google Cloud storage to pandas dataframe
  20. Pandas dataframe read_csv on bad data
  21. pandas.read_csv from string or package data
  22. Pandas groupby to to_csv
  23. Conditional row read of csv in pandas
  24. Load CSV to Pandas MultiIndex DataFrame
  25. Pandas to_csv call is prepending a comma
  26. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  27. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  28. start index at 1 for Pandas DataFrame
  29. pandas – convert string into list of strings [duplicate]
  30. Bin values based on ranges with pandas [duplicate]

Leave a Comment