Coverting string to dataframe python [duplicate]

Question

I have a data like the below. How can I convert this string data to pandas dataframe?

data='"customer_id"|"first_name"|"city_name"\r\n123456"|"ABC"|"ARGENTINA"\r\n"2000142707"|"efgh"|"LOMELLO"\r\n

user17242583 · Accepted Answer · 2022-03-16 16:36:04Z

5

Just use pd.read_csv, and specify sep="|"

from io import StringIO
df = pd.read_csv(StringIO(data), sep='|')

Of course, if you have the data in a file instead of a string, you can just read the file directly:

df = pd.read_csv("path/to/file", sep='|')

Output:

>>> df
  customer_id first_name  city_name
0      123456        ABC  ARGENTINA
1  2000142707       efgh    LOMELLO

answered Mar 16, 2022 at 16:36

user17242583

Sign up to request clarification or add additional context in comments.

Comments

LCMa · Accepted Answer · 2022-03-16 16:37:15Z

1

You can do this:

import pandas as pd
pd.DataFrame([i.split('|') for i in text.replace('"','').split('\r\n')])

You should do some modifications after to have the columns names and delete the last empty row.

answered Mar 16, 2022 at 16:37

LCMa

4556 silver badges18 bronze badges