/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

0 vote123 views3 answers
Pandas assign multiple columns at once
Python
16 votes129 views6 answers
Python turtle setup
Python
5 votes116 views2 answers
Pygame flip image
Python
1 vote114 views1 answer
Height width image opencv
Python
0 vote116 views1 answer
Pandas df.index.values
Python
0 vote99 views1 answer
How to create frequency table in python
Python
4 votes123 views1 answer
Django include
Python
0 vote108 views1 answer
Access to specific column array numpy
Python
7 votes108 views2 answers
How to get something from a certian possition in a list python
Python
1 vote114 views1 answer
Convert dtype of column cudf
Python