/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 votes235 views1 answer
Nlargest
Python
0 vote245 views1 answer
Python get desktop environment
Python
2 votes250 views2 answers
Python trim leading whitespace
Python
7 votes287 views2 answers
No module named 'PyQt5.QtWebEngineWidgets'
Python
4 votes248 views2 answers
Python dump object print
Python
0 vote253 views1 answer
Not en python
Python
3 votes253 views2 answers
COLLECTIONS.DEFAULTDICT(set)
Python
0 vote254 views1 answer
Create nested dictionary with user input in python
Python
0 vote244 views4 answers
Ip address regex
Python
0 vote230 views1 answer
Bytestring python
Python