Support Questions
Find answers, ask questions, and share your expertise

read csv key value pairs file and create dataframe with key to multiple collumn in pyspark

read csv key value pairs file and create dataframe with key to multiple collumn in pyspark

New Contributor

itemid,content
235594,"{ ""itemid"" : ""235594"", ""imsid"" : ""4"", ""GTIN"" : ""00604183111203"", ""GLN"" : ""0067277000010"", ""extendedDescriptionEnglish"" : ""FRO 6/16oz MED JALAPNO SLSA"", ""shortDescriptionEnglish"" : ""FRO 6/16oz MED JALAPNO SLSA"", ""productNameEnglish"" : ""FRONTERA BRAND"", ""productNameFrench"" : ""FRONTERA BRAND"", ""sccMarked"" : ""N"", ""serialNumberLocationCode"" : [ ], ""totalUnits"" : ""1"", ""length"" : ""7.62"", ""lengthUOM"" : ""CM"", ""width"" : ""7.62"", ""widthUOM"" : ""CM"", ""height"" : ""13.335"", ""heightUOM"" : ""CM"", ""grossWeight"" : ""745.252"", ""grossWeightUOM"" : ""G"", ""netWeight"" : ""453.592"", ""netWeightUOM"" : ""G"", ""packagingFormQual"" : ""PO"", ""packagingMaterialQual"" : ""POL"", ""size"" : ""16"", ""sizeUOM"" : ""OZ"", ""functionalNameEnglish"" : ""FRONTERA"", ""functionalNameFrench"" : ""FRONTERA"", ""gpcClassificationCode"" : ""10000057"", ""baseUnitIndicator"" : ""Y"", ""isTradeItemAConsumerUnit"" : ""Y"", ""dispatchUnitIndicator"" : ""N"", ""invoiceUnitIndicator"" : ""Y"", ""orderingUnitIndicator"" : ""Y"", ""variableWeightTradeItem"" : ""N"", ""packagingMarkedReturnable"" : ""N"", ""tradeItemDescriptionEnglish"" : ""FRONTERA BRAND"", ""tradeItemDescriptionFrench"" : ""FRONTERA BRAND"", ""netContent"" : ""16"", ""netContentUOM"" : ""OZ"", ""allergenClaimFreeFrom"" : [ ], ""productProcessingProvince"" : [ ], ""productPackagingProvince"" : [ ], ""productLine"" : ""52469"", ""eccnetClassCode"" : ""000149"", ""alternativeGtin"" : [ ], ""channelOfDistributionGrocery"" : ""Y"", ""productType"" : ""EA"", ""gstAndHst"" : ""N"", ""shortDescriptionFrench"" : ""FRO 6/16oz SALSA JALAPENO"", ""extendedDescriptionFrench"" : ""FRO 6/16oz SALSA JALAPENO"", ""brand"" : ""FRONTERA BRAND"", ""brandFrench"" : ""FRONTERA BRAND"", ""allergenCrustaceanTypeGroup"" : [ ], ""allergenFishTypeGroup"" : [ ], ""allergenShellfishTypeGroup"" : [ ], ""apparelSizeGroup"" : [ ], ""batteryGroup"" : [ ], ""certificationGroup"" : [ ], ""digitalAssetFoodservice"" : [ ], ""digitalAssetPlanogram"" : [ ], ""drugAndHealthProductGroup"" : [ ], ""footwearSizeGroup"" : [ ], ""importClassificationGroup"" : [ ], ""ingredientGroup"" : [ ], ""mineralClaimGroup"" : [ ], ""nextLowerLevels"" : [ ], ""nutrientClaimGroup"" : [ ], ""shortMarketingMessageGroup"" : [ ], ""stewardshipGroup"" : [ ], ""vitaminClaimGroup"" : [ ] }"