/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

28 votes162 views3 answers
Round down a number python
Python
13 votes155 views2 answers
How to copy one dictionary to another in python
Python
0 vote169 views1 answer
Python tkinter get image size
Python
0 vote134 views1 answer
Get more than one decimal in python
Python
222 votes460 views6 answers
Python random numbers
Python
0 vote146 views1 answer
Sqlalchemy datetime default now create table
Python
7 votes154 views5 answers
Python datetime with timezone
Python
0 vote152 views1 answer
Count a newline in string python
Python
0 vote152 views1 answer
Loading in pyqt5
Python
3 votes104 views1 answer
Python question mark operator
Python