Ask Your Question

How can I convert data separated by pipes into a dataframe using pandas?

asked 2022-03-08 11:00:00 +0000

scrum gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2022-04-03 01:00:00 +0000

woof gravatar image

You can use the read_csv() function from pandas to convert data separated by pipes into a dataframe. Simply specify the sep parameter as '|'. Here's an example:

import pandas as pd

# sample data separated by pipes
data = 'Name|Age|Gender\nJohn|25|M\nMary|30|F\nBob|20|M'

# convert data to dataframe
df = pd.read_csv(pd.compat.StringIO(data), sep='|')



   Name  Age Gender
0  John   25      M
1  Mary   30      F
2   Bob   20      M
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools


Asked: 2022-03-08 11:00:00 +0000

Seen: 9 times

Last updated: Apr 03 '22