/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

2 votes170 views1 answer
Fill zero behind number python
Python
4 votes166 views1 answer
Python gt index in for cycle
Python
3 votes158 views1 answer
Multiply column of dataframe by number
Python
2 votes173 views1 answer
Kivy changing screen in python
Python
0 vote199 views1 answer
Whitelist the ip address django
Python Django
0 vote184 views1 answer
The webpage at http://127.0.0.1:8000/ might be temporarily down or it may have moved permanently to a new web address. django
Python Django
1 vote162 views2 answers
Pandas docs
Python
0 vote160 views1 answer
How to write flow of execution in python
Python
18 votes164 views2 answers
Get ascii value of char python online
Python
0 vote158 views1 answer
How to add some thing in python list
Python