/Python/Pandas read_csv multiple separator

Pandas read_csv multiple separator

my_cols = [str(i) for i in range(45)] # create some col names
df_user_key_word_org = pd.read_csv(filepath+"user_key_word.txt",
                                   sep="\s+|;|:",
                                   names=my_cols, 
                                   header=None, 
                                   engine="python")
# I tested with s = StringIO(text_from_OP) on my computer

Source: stackoverflow.com

Similar codes

3 votes183 views1 answer
How to add text in python turtle
Python
0 vote210 views1 answer
2 functions at a time py
Python
0 vote156 views1 answer
Python win32api setcursorpos
Python
1 vote147 views1 answer
32 bit binary in python
Python
0 vote245 views1 answer
Parquet pyspark
Python
0 vote197 views1 answer
How to store a int value in django sessions
Python
17 votes185 views4 answers
Pip install python 3
Python
0 vote195 views1 answer
List comprehensions with dates
Python
5 votes164 views1 answer
Instead, it is recommended that you transition to using 'python3' from within Terminal.
Python
0 vote186 views3 answers
Saving 3D plots on python as png
Python