Pandas read csv dtype list

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

# Or, if you are sure the format is the 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

Source: stackoverflow.com

Similar codes

39 votes99 views6 answers
Remove all whitespace from string python
Python
0 vote126 views2 answers
Avoid bad request django
Python Django
2 votes127 views1 answer
Get n random numbers from x to y python
Python
2 votes145 views2 answers
Get files from s3 bucket python
Python
0 vote97 views1 answer
Compress excel file in python
Python
0 vote91 views1 answer
Mathtext to regular python
Python
0 vote109 views1 answer
Python Split list into chunks using List Comprehension
Python
0 vote103 views1 answer
Multipart/form data multipart encoder python
Python
0 vote105 views1 answer
Pandas create average per group
Python
2 votes100 views1 answer
Get dataframe column into a list
Python