/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

1 vote169 views1 answer
How to capture a single photo with webcam opencv
Python
2 votes170 views2 answers
Convert generator to list python
Python
0 vote183 views1 answer
The function to be built, amino_acids, must return a list of a tuple and an integer when given a string of mRNA code.
Python
0 vote212 views1 answer
First and last upper
Python
0 vote175 views1 answer
Python how to locate and fill a specific column null values
Python
5 votes174 views2 answers
Finding the format of an image in cv2
Python
30 votes163 views3 answers
How to iterate through files in a folder python
Python
22 votes172 views5 answers
How to check if a word is a palindrome in python
Python
2 votes170 views2 answers
Python find second occurrence in string
Python
4 votes177 views2 answers
Split filename and extension python
Python