python-pandasHow to save dataframe to XML file
import pandas as pd
df = pd.DataFrame({
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Price': [204, 304, 404, 405, 305]
})
df.to_xml('/path/to/file.xml');ctrl + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
to_xmlsaves dataframe to XML file | /path/to/file.xmlpath to write file to |
Usage example
cat /path/to/file.xmloutput
<?xml version='1.0' encoding='utf-8'?>
<data>
<row>
<index>0</index>
<Phone>ip5</Phone>
<Price>204</Price>
</row>
<row>
<index>1</index>
<Phone>ip6</Phone>
<Price>304</Price>
</row>
<row>
<index>2</index>
<Phone>ip8</Phone>
<Price>404</Price>
</row>
<row>
<index>3</index>
<Phone>sms</Phone>
<Price>405</Price>
</row>
<row>
<index>4</index>
<Phone>xi</Phone>
<Price>305</Price>
</row>
</data>More of Python Pandas
- How to convert column object values to String
- How to use melt() with dataframe - example
- How to inner join dataframes
- How to set data frame index
- How to floor values in dataframe
- How to replace values in dataframe
- How to convert column values to Int
- How to use multiple conditions in mask()
- How to select not null values from dataframe
- How to select null values from dataframe
See more codes...