/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 vote143 views1 answer
Add values to pandas plot
Python
0 vote150 views1 answer
Qfiledialog python save
Python
0 vote159 views1 answer
Calculer un temps en python
Python
0 vote191 views2 answers
Print specific key in dictionary python
Python
5 votes182 views1 answer
Resize imshow opencv python
Python
1 vote150 views1 answer
Plot normal distribution python
Python
-1 vote154 views1 answer
How do you split a list into evenly sized chunks?
Python
8 votes155 views2 answers
How to add 2 integers in python
Python
0 vote151 views1 answer
Drop row pandas column value not a number
Python
0 vote156 views1 answer
Let's consider an infinite sequence of digits constructed of ascending powers of 10 written one after another python solution
Python