Python Forum
convert huge xml to csv using python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
convert huge xml to csv using python
#1
Hi,

I have huge XML file of size 500mb which I want to convert to CSV using Python.i tried lot and not able to get proper output . Can some one help me with this?

Sample input xml
-------
<?xml version="1.0" encoding="UTF-8"?>
<Feed xmlns="http://www.bazaarvoice.com/xs/PRR/ProductFeed/5.6" name="ikeaglobal" incremental="false" extractDate="2020-01-21T10:34:20.041000">
<Categories>
<Category>
<ExternalId>10364</ExternalId>
<Name>Storage furniture</Name>
<Names>
<Name locale="sk_SK">Úložné systémy </Name>
<Name locale="hu_HU">Tárolás </Name>
<Name locale="eu_ES">Biltegiratze-altzariak </Name>
<Name locale="cs_CZ">Úložné systémy </Name>
<Name locale="pt_PT">Móveis de arrumação </Name>
<Name locale="en_AU">Storage furniture </Name>
<Name locale="nl_BE">Opbergmeubels </Name>
<Name locale="fr_BE">Rangements bureau et salon </Name>
<Name locale="de_AT">Aufbewahrungsmöbel </Name>
<Name locale="nl_NL">Opbergmeubels </Name>
<Name locale="en_PT">Storage furniture </Name>
<Name locale="it_CH">Mobili </Name>
<Name locale="en_GB">Storage furniture </Name>
<Name locale="en_CH">Storage furniture </Name>
<Name locale="de_CH">Aufbewahrungsmöbel </Name>
<Name locale="fr_CH">Rangements bureau et salon </Name>
<Name locale="fr_CA">Meubles de rangement </Name>
<Name locale="en_CA">Storage furniture </Name>
<Name locale="hr_HR">Namještaj za odlaganje </Name>
<Name locale="ja_JP">収納家具 </Name>
<Name locale="en_KR">Storage furniture </Name>
<Name locale="ko_KR">수납가구 </Name>
<Name locale="ca_ES">Mobles d'emmagatzematge </Name>
<Name locale="es_ES">Mobiliario de almacenaje </Name>
<Name locale="it_IT">Mobili </Name>
<Name locale="de_DE">Aufbewahrungsmöbel </Name>
<Name locale="fr_FR">Rangements bureau et salon </Name>
<Name locale="en_NL">Storage furniture </Name>
<Name locale="en_US">Storage furniture </Name>
<Name locale="ro_RO">Mobilier pentru depozitare </Name>
<Name locale="en_ES">Storage furniture </Name>
<Name locale="en_JP">Storage furniture </Name>
</Names>
<CategoryPageUrl>https://www.ikea.com/se/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrls>
<CategoryPageUrl locale="sk_SK">https://www.ikea.com/sk/sk/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="hu_HU">https://www.ikea.com/hu/hu/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="eu_ES">https://www.ikea.com/es/eu/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="cs_CZ">https://www.ikea.com/cz/cs/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="pt_PT">https://www.ikea.com/pt/pt/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_AU">https://www.ikea.com/au/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="nl_BE">https://www.ikea.com/be/nl/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_BE">https://www.ikea.com/be/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="de_AT">https://www.ikea.com/at/de/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="nl_NL">https://www.ikea.com/nl/nl/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_PT">https://www.ikea.com/pt/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="it_CH">https://www.ikea.com/ch/it/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_GB">https://www.ikea.com/gb/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_CH">https://www.ikea.com/ch/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="de_CH">https://www.ikea.com/ch/de/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_CH">https://www.ikea.com/ch/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_CA">https://www.ikea.com/ca/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_CA">https://www.ikea.com/ca/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="hr_HR">https://www.ikea.com/hr/hr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ja_JP">https://www.ikea.com/jp/ja/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_KR">https://www.ikea.com/kr/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ko_KR">https://www.ikea.com/kr/ko/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ca_ES">https://www.ikea.com/es/ca/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="es_ES">https://www.ikea.com/es/es/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="it_IT">https://www.ikea.com/it/it/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="de_DE">https://www.ikea.com/de/de/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_FR">https://www.ikea.com/fr/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_NL">https://www.ikea.com/nl/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ro_RO">https://www.ikea.com/ro/ro/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_ES">https://www.ikea.com/es/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_JP">https://www.ikea.com/jp/en/catalog/categories/range/10364/</CategoryPageUrl>
</CategoryPageUrls>
</Category>
</Categories>
<Products>
<Product>
<ExternalId>ART-00015134</ExternalId>
<Name>SVALKA White wine glass</Name>
<Names>
<Name locale="en_US">SVALKA White wine glass</Name>
<Name locale="sk_SK">SVALKA Pohár na biele víno</Name>
<Name locale="hu_HU">SVALKA Fehérboros pohár</Name>
<Name locale="en_US">SVALKA White wine glass</Name>
<Name locale="cs_CZ">SVALKA Sklenka na bílé víno</Name>
<Name locale="pt_PT">SVALKA Copo de vinho branco</Name>
<Name locale="nl_BE">SVALKA Wittewijnglas</Name>
<Name locale="fr_BE">SVALKA Verre à vin blanc</Name>
<Name locale="de_AT">SVALKA Weißweinglas</Name>
<Name locale="nl_NL">SVALKA Wittewijnglas</Name>
<Name locale="it_CH">SVALKA Bicchiere da vino bianco</Name>
<Name locale="en_PT">SVALKA White wine glass</Name>
<Name locale="en_GB">SVALKA White wine glass</Name>
<Name locale="en_CH">SVALKA White wine glass</Name>
<Name locale="de_CH">SVALKA Weißweinglas</Name>
<Name locale="fr_CH">SVALKA Verre à vin blanc</Name>
<Name locale="fr_CA">SVALKA Verre à vin blanc</Name>
<Name locale="en_CA">SVALKA White wine glass</Name>
<Name locale="hr_HR">SVALKA Čaša za bijelo vino</Name>
<Name locale="ca_ES">SVALKA Copa de vi blanc</Name>
<Name locale="es_ES">SVALKA Copa de vino blanco</Name>
<Name locale="it_IT">SVALKA Bicchiere da vino bianco</Name>
<Name locale="de_DE">SVALKA Weißweinglas</Name>
<Name locale="fr_FR">SVALKA Verre à vin blanc</Name>
<Name locale="en_NL">SVALKA White wine glass</Name>
<Name locale="en_US">SVALKA White wine glass</Name>
<Name locale="ro_RO">SVALKA Pahar vin alb</Name>
<Name locale="en_ES">SVALKA White wine glass</Name>
</Names>
<Description>White wine glass</Description>
<Descriptions>
<Description locale="en_US">White wine glass</Description>
<Description locale="sk_SK">Pohár na biele víno</Description>
<Description locale="hu_HU">Fehérboros pohár</Description>
<Description locale="en_US">White wine glass</Description>
<Description locale="cs_CZ">Sklenka na bílé víno</Description>
<Description locale="pt_PT">Copo de vinho branco</Description>
<Description locale="nl_BE">Wittewijnglas</Description>
<Description locale="fr_BE">Verre à vin blanc</Description>
<Description locale="de_AT">Weißweinglas</Description>
<Description locale="nl_NL">Wittewijnglas</Description>
<Description locale="it_CH">Bicchiere da vino bianco</Description>
<Description locale="en_PT">White wine glass</Description>
<Description locale="en_GB">White wine glass</Description>
<Description locale="en_CH">White wine glass</Description>
<Description locale="de_CH">Weißweinglas</Description>
<Description locale="fr_CH">Verre à vin blanc</Description>
<Description locale="fr_CA">Verre à vin blanc</Description>
<Description locale="en_CA">White wine glass</Description>
<Description locale="hr_HR">Čaša za bijelo vino</Description>
<Description locale="ca_ES">Copa de vi blanc</Description>
<Description locale="es_ES">Copa de vino blanco</Description>
<Description locale="it_IT">Bicchiere da vino bianco</Description>
<Description locale="de_DE">Weißweinglas</Description>
<Description locale="fr_FR">Verre à vin blanc</Description>
<Description locale="en_NL">White wine glass</Description>
<Description locale="en_US">White wine glass</Description>
<Description locale="ro_RO">Pahar vin alb</Description>
<Description locale="en_ES">White wine glass</Description>
</Descriptions>
<CategoryExternalId>18870</CategoryExternalId>
<ProductPageUrl>https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrls>
<ProductPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="sk_SK">https://www.ikea.com/sk/sk/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="hu_HU">https://www.ikea.com/hu/hu/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="cs_CZ">https://www.ikea.com/cz/cs/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="pt_PT">https://www.ikea.com/pt/pt/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="nl_BE">https://www.ikea.com/be/nl/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_BE">https://www.ikea.com/be/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="de_AT">https://www.ikea.com/at/de/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="nl_NL">https://www.ikea.com/nl/nl/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="it_CH">https://www.ikea.com/ch/it/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_PT">https://www.ikea.com/pt/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_GB">https://www.ikea.com/gb/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_CH">https://www.ikea.com/ch/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="de_CH">https://www.ikea.com/ch/de/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_CH">https://www.ikea.com/ch/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_CA">https://www.ikea.com/ca/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_CA">https://www.ikea.com/ca/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="hr_HR">https://www.ikea.com/hr/hr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="ca_ES">https://www.ikea.com/es/ca/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="es_ES">https://www.ikea.com/es/es/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="it_IT">https://www.ikea.com/it/it/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="de_DE">https://www.ikea.com/de/de/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_FR">https://www.ikea.com/fr/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_NL">https://www.ikea.com/nl/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="ro_RO">https://www.ikea.com/ro/ro/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_ES">https://www.ikea.com/es/en/catalog/products/00015134/</ProductPageUrl>
</ProductPageUrls>
<ImageUrl>https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrls>
<ImageUrl locale="en_US">https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="sk_SK">https://www.ikea.com/sk/sk/images/products/svalka-pohar-na-biele-vino__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="hu_HU">https://www.ikea.com/hu/hu/images/products/svalka-feherboros-pohar__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_US">https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="cs_CZ">https://www.ikea.com/cz/cs/images/products/svalka-sklenka-na-bile-vino__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="pt_PT">https://www.ikea.com/pt/pt/images/products/svalka-copo-de-vinho-branco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="nl_BE">https://www.ikea.com/be/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_BE">https://www.ikea.com/be/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="de_AT">https://www.ikea.com/at/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="nl_NL">https://www.ikea.com/nl/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="it_CH">https://www.ikea.com/ch/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_PT">https://www.ikea.com/pt/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_GB">https://www.ikea.com/gb/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_CH">https://www.ikea.com/ch/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="de_CH">https://www.ikea.com/ch/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_CH">https://www.ikea.com/ch/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_CA">https://www.ikea.com/ca/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_CA">https://www.ikea.com/ca/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="hr_HR">https://www.ikea.com/hr/hr/images/products/svalka-casa-za-bijelo-vino__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="ca_ES">https://www.ikea.com/es/ca/images/products/svalka-copa-de-vi-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="es_ES">https://www.ikea.com/es/es/images/products/svalka-copa-de-vino-blanco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="it_IT">https://www.ikea.com/it/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="de_DE">https://www.ikea.com/de/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_FR">https://www.ikea.com/fr/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_NL">https://www.ikea.com/nl/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_US">https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="ro_RO">https://www.ikea.com/ro/ro/images/products/svalka-pahar-vin-alb__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_ES">https://www.ikea.com/es/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
</ImageUrls>
<Attributes>
<Attribute id="BV_FE_FAMILY">
<Value>P00015134</Value>
</Attribute>
<Attribute id="BV_FE_EXPAND">
<Value>BV_FE_FAMILY:P00015134</Value>
</Attribute>
</Attributes>
</Product>
</Products>
</Feed>

Desired CSV output sample
-----
extractDate,Categories__Category__ExternalId,Categories__Category__Name,Categories__Category__Names__Name__locale,Categories__Category__Names__Name__#Text,Categories__Category__CategoryPageUrl,Categories__Category__CategoryPageUrls__CategoryPageUrl__locale,Categories__Category__CategoryPageUrls__CategoryPageUrl__#Text,Products__Product__ExternalId,Products__Product__Name,Products__Product__Names__Name__locale,Products__Product__Names__Name__#Text,Products__Product__Description,Products__Product__Descriptions__Description__locale,Products__Product__Descriptions__Description__#Text,Products__Product__CategoryExternalId,Products__Product__ProductPageUrl,Products__Product__ProductPageUrls__ProductPageUrl__locale,Products__Product__ProductPageUrls__ProductPageUrl__#Text,Products__Product__ImageUrl,Products__Product__ImageUrls__ImageUrl__locale,Products__Product__ImageUrls__ImageUrl__#Text
2020-01-21T10:34:20.041000,10364,Storage furniture,sk_SK,Úložné systémy ,https://www.ikea.com/se/en/catalog/categories/range/10364/,sk_SK,https://www.ikea.com/sk/sk/catalog/categories/range/10364/,ART-00015134,SVALKA White wine glass,en_US,SVALKA White wine glass,White wine glass,en_US,White wine glass,18870,https://www.ikea.com/us/en/catalog/products/00015134/,en_US,https://www.ikea.com/us/en/catalog/products/00015134/,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg,en_US,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,hu_HU,Tárolás ,,hu_HU,https://www.ikea.com/hu/hu/catalog/categories/range/10364/,,,sk_SK,SVALKA Pohár na biele víno,,sk_SK,Pohár na biele víno,,,sk_SK,https://www.ikea.com/sk/sk/catalog/products/00015134/,,sk_SK,https://www.ikea.com/sk/sk/images/products/svalka-pohar-na-biele-vino__27885_PE097378_S4.jpg
,,,eu_ES,Biltegiratze-altzariak ,,eu_ES,https://www.ikea.com/es/eu/catalog/categories/range/10364/,,,hu_HU,SVALKA Fehérboros pohár,,hu_HU,Fehérboros pohár,,,hu_HU,https://www.ikea.com/hu/hu/catalog/products/00015134/,,hu_HU,https://www.ikea.com/hu/hu/images/products/svalka-feherboros-pohar__27885_PE097378_S4.jpg
,,,cs_CZ,Úložné systémy ,,cs_CZ,https://www.ikea.com/cz/cs/catalog/categories/range/10364/,,,en_US,SVALKA White wine glass,,en_US,White wine glass,,,en_US,https://www.ikea.com/us/en/catalog/products/00015134/,,en_US,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,pt_PT,Móveis de arrumação ,,pt_PT,https://www.ikea.com/pt/pt/catalog/categories/range/10364/,,,cs_CZ,SVALKA Sklenka na bílé víno,,cs_CZ,Sklenka na bílé víno,,,cs_CZ,https://www.ikea.com/cz/cs/catalog/products/00015134/,,cs_CZ,https://www.ikea.com/cz/cs/images/products/svalka-sklenka-na-bile-vino__27885_PE097378_S4.jpg
,,,en_AU,Storage furniture ,,en_AU,https://www.ikea.com/au/en/catalog/categories/range/10364/,,,pt_PT,SVALKA Copo de vinho branco,,pt_PT,Copo de vinho branco,,,pt_PT,https://www.ikea.com/pt/pt/catalog/products/00015134/,,pt_PT,https://www.ikea.com/pt/pt/images/products/svalka-copo-de-vinho-branco__27885_PE097378_S4.jpg
,,,nl_BE,Opbergmeubels ,,nl_BE,https://www.ikea.com/be/nl/catalog/categories/range/10364/,,,nl_BE,SVALKA Wittewijnglas,,nl_BE,Wittewijnglas,,,nl_BE,https://www.ikea.com/be/nl/catalog/products/00015134/,,nl_BE,https://www.ikea.com/be/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg
,,,fr_BE,Rangements bureau et salon ,,fr_BE,https://www.ikea.com/be/fr/catalog/categories/range/10364/,,,fr_BE,SVALKA Verre à vin blanc,,fr_BE,Verre à vin blanc,,,fr_BE,https://www.ikea.com/be/fr/catalog/products/00015134/,,fr_BE,https://www.ikea.com/be/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,de_AT,Aufbewahrungsmöbel ,,de_AT,https://www.ikea.com/at/de/catalog/categories/range/10364/,,,de_AT,SVALKA Weißweinglas,,de_AT,Weißweinglas,,,de_AT,https://www.ikea.com/at/de/catalog/products/00015134/,,de_AT,https://www.ikea.com/at/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg
,,,nl_NL,Opbergmeubels ,,nl_NL,https://www.ikea.com/nl/nl/catalog/categories/range/10364/,,,nl_NL,SVALKA Wittewijnglas,,nl_NL,Wittewijnglas,,,nl_NL,https://www.ikea.com/nl/nl/catalog/products/00015134/,,nl_NL,https://www.ikea.com/nl/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg
,,,en_PT,Storage furniture ,,en_PT,https://www.ikea.com/pt/en/catalog/categories/range/10364/,,,it_CH,SVALKA Bicchiere da vino bianco,,it_CH,Bicchiere da vino bianco,,,it_CH,https://www.ikea.com/ch/it/catalog/products/00015134/,,it_CH,https://www.ikea.com/ch/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg
,,,it_CH,Mobili ,,it_CH,https://www.ikea.com/ch/it/catalog/categories/range/10364/,,,en_PT,SVALKA White wine glass,,en_PT,White wine glass,,,en_PT,https://www.ikea.com/pt/en/catalog/products/00015134/,,en_PT,https://www.ikea.com/pt/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,en_GB,Storage furniture ,,en_GB,https://www.ikea.com/gb/en/catalog/categories/range/10364/,,,en_GB,SVALKA White wine glass,,en_GB,White wine glass,,,en_GB,https://www.ikea.com/gb/en/catalog/products/00015134/,,en_GB,https://www.ikea.com/gb/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,en_CH,Storage furniture ,,en_CH,https://www.ikea.com/ch/en/catalog/categories/range/10364/,,,en_CH,SVALKA White wine glass,,en_CH,White wine glass,,,en_CH,https://www.ikea.com/ch/en/catalog/products/00015134/,,en_CH,https://www.ikea.com/ch/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,de_CH,Aufbewahrungsmöbel ,,de_CH,https://www.ikea.com/ch/de/catalog/categories/range/10364/,,,de_CH,SVALKA Weißweinglas,,de_CH,Weißweinglas,,,de_CH,https://www.ikea.com/ch/de/catalog/products/00015134/,,de_CH,https://www.ikea.com/ch/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg
,,,fr_CH,Rangements bureau et salon ,,fr_CH,https://www.ikea.com/ch/fr/catalog/categories/range/10364/,,,fr_CH,SVALKA Verre à vin blanc,,fr_CH,Verre à vin blanc,,,fr_CH,https://www.ikea.com/ch/fr/catalog/products/00015134/,,fr_CH,https://www.ikea.com/ch/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,fr_CA,Meubles de rangement ,,fr_CA,https://www.ikea.com/ca/fr/catalog/categories/range/10364/,,,fr_CA,SVALKA Verre à vin blanc,,fr_CA,Verre à vin blanc,,,fr_CA,https://www.ikea.com/ca/fr/catalog/products/00015134/,,fr_CA,https://www.ikea.com/ca/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,en_CA,Storage furniture ,,en_CA,https://www.ikea.com/ca/en/catalog/categories/range/10364/,,,en_CA,SVALKA White wine glass,,en_CA,White wine glass,,,en_CA,https://www.ikea.com/ca/en/catalog/products/00015134/,,en_CA,https://www.ikea.com/ca/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,hr_HR,Namještaj za odlaganje ,,hr_HR,https://www.ikea.com/hr/hr/catalog/categories/range/10364/,,,hr_HR,SVALKA Čaša za bijelo vino,,hr_HR,Čaša za bijelo vino,,,hr_HR,https://www.ikea.com/hr/hr/catalog/products/00015134/,,hr_HR,https://www.ikea.com/hr/hr/images/products/svalka-casa-za-bijelo-vino__27885_PE097378_S4.jpg
,,,ja_JP,収納家具 ,,ja_JP,https://www.ikea.com/jp/ja/catalog/categories/range/10364/,,,ca_ES,SVALKA Copa de vi blanc,,ca_ES,Copa de vi blanc,,,ca_ES,https://www.ikea.com/es/ca/catalog/products/00015134/,,ca_ES,https://www.ikea.com/es/ca/images/products/svalka-copa-de-vi-blanc__27885_PE097378_S4.jpg
,,,en_KR,Storage furniture ,,en_KR,https://www.ikea.com/kr/en/catalog/categories/range/10364/,,,es_ES,SVALKA Copa de vino blanco,,es_ES,Copa de vino blanco,,,es_ES,https://www.ikea.com/es/es/catalog/products/00015134/,,es_ES,https://www.ikea.com/es/es/images/products/svalka-copa-de-vino-blanco__27885_PE097378_S4.jpg
,,,ko_KR,수납가구 ,,ko_KR,https://www.ikea.com/kr/ko/catalog/categories/range/10364/,,,it_IT,SVALKA Bicchiere da vino bianco,,it_IT,Bicchiere da vino bianco,,,it_IT,https://www.ikea.com/it/it/catalog/products/00015134/,,it_IT,https://www.ikea.com/it/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg
,,,ca_ES,Mobles d'emmagatzematge ,,ca_ES,https://www.ikea.com/es/ca/catalog/categories/range/10364/,,,de_DE,SVALKA Weißweinglas,,de_DE,Weißweinglas,,,de_DE,https://www.ikea.com/de/de/catalog/products/00015134/,,de_DE,https://www.ikea.com/de/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg
,,,es_ES,Mobiliario de almacenaje ,,es_ES,https://www.ikea.com/es/es/catalog/categories/range/10364/,,,fr_FR,SVALKA Verre à vin blanc,,fr_FR,Verre à vin blanc,,,fr_FR,https://www.ikea.com/fr/fr/catalog/products/00015134/,,fr_FR,https://www.ikea.com/fr/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,it_IT,Mobili ,,it_IT,https://www.ikea.com/it/it/catalog/categories/range/10364/,,,en_NL,SVALKA White wine glass,,en_NL,White wine glass,,,en_NL,https://www.ikea.com/nl/en/catalog/products/00015134/,,en_NL,https://www.ikea.com/nl/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,de_DE,Aufbewahrungsmöbel ,,de_DE,https://www.ikea.com/de/de/catalog/categories/range/10364/,,,en_US,SVALKA White wine glass,,en_US,White wine glass,,,en_US,https://www.ikea.com/us/en/catalog/products/00015134/,,en_US,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,fr_FR,Rangements bureau et salon ,,fr_FR,https://www.ikea.com/fr/fr/catalog/categories/range/10364/,,,ro_RO,SVALKA Pahar vin alb,,ro_RO,Pahar vin alb,,,ro_RO,https://www.ikea.com/ro/ro/catalog/products/00015134/,,ro_RO,https://www.ikea.com/ro/ro/images/products/svalka-pahar-vin-alb__27885_PE097378_S4.jpg
,,,en_NL,Storage furniture ,,en_NL,https://www.ikea.com/nl/en/catalog/categories/range/10364/,,,en_ES,SVALKA White wine glass,,en_ES,White wine glass,,,en_ES,https://www.ikea.com/es/en/catalog/products/00015134/,,en_ES,https://www.ikea.com/es/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,en_US,Storage furniture ,,en_US,https://www.ikea.com/us/en/catalog/categories/range/10364/,,,,,,,,,,,,,,
,,,ro_RO,Mobilier pentru depozitare ,,ro_RO,https://www.ikea.com/ro/ro/catalog/categories/range/10364/,,,,,,,,,,,,,,
,,,en_ES,Storage furniture ,,en_ES,https://www.ikea.com/es/en/catalog/categories/range/10364/,,,,,,,,,,,,,,
,,,en_JP,Storage furniture ,,en_JP,https://www.ikea.com/jp/en/catalog/categories/range/10364/,,,,,,,,,,,,,,
Reply
#2
Xml describes a treelike structure while Csv describes tabular data. There is no default way to transform the one into the other. I'm afraid there are missing constraints in your specifications. Also where is the python code that you tried unsuccessfully?
Reply
#3
Hi ,

i have tried with different code to fetch all the value of attribute from XML But no luck .. i failed ..

however , if i am putting that sample xml in "https://json-csv.com/xml" coverter , the csv output is coming properly , you can check the same with that link ..

i want same using python script ..so need support on this ..
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Exporting a huge dataFrame stylingpat 5 15,264 Mar-23-2021, 12:13 AM
Last Post: stylingpat
  Pip prints huge error when installing p5 hayden2s 1 2,217 Aug-08-2020, 02:30 PM
Last Post: snippsat
  Huge CSV Reading and Sorting for comparison akshaynimkar 3 2,427 Aug-04-2020, 11:20 AM
Last Post: Larz60+
  How to scan huge files and make it in chunks ampai 2 2,542 May-28-2020, 08:20 PM
Last Post: micseydel
  huge list of whole numbers Skaperen 3 2,737 Jun-02-2019, 10:11 PM
Last Post: Skaperen

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020