Read xml column inside csv file with Python

Hi,
I am very new in Python and need to read an xml column inside a csv file with Python.
I can see some code on google on how to read that csv file but I don’t know how to read the xml column inside the csv file. Can someone help? any idea would be appreciated.

Thank you!

You can use Pandas

https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html

import pandas as pd
df = pd.read_csv(‘data.csv’)
df1 = df[[‘xml_column’]]

I’d make it a function and return df1.

OP:      I am very new in Python

REPLY:  You can use Pandas

These two statements might be unworkably incompatible,.
(Although the suggested code also might be paste-and-go.)

@estertabita, can you post enough of your XML file to show the data you need to read?

Paste the data between backticks like this:

```python
<paste XML data here>
```

I linked the project site. Which holds documentation.

Here it is again if it was missed;

1 Like