Python Forum

Hi,
I have this file below, the format looks like it's JSON but I'm not sure, I want to convert it to csv.

I have also attached the file for clear readability.

Quote:(UserResponse){
UserData =
(UserData){
Entry[] =
(UserData){
Active = True
CreatedTime = 2014-07-05 18:38:59.062000+02:00
FirstName = "System"
Lastname = "Account (AddressBook)"
Locked = False
RoleNames =
(RoleNames){
Entry[] =
"Integration admin"
}
UserName = "User1"
UserOrganisation = "Default Organization"
}
(UserData){
Active = True
CreatedTime = 2014-07-05 18:38:59.062000+02:00
FirstName = "System"
LastLoginExt = 2019-04-13 20:04:03+02:00
Lastname = "Account (ChickenFeet)"
Locked = False
RoleNames =
(RoleNames){
Entry[] =
"Integration admin"
}
UserName = "User5"
UserOrganisation = "Default Organization"
}


}
}

please help, how do I convert this file to csv

rough pseudo code (2 methods):

• you need two imports, json and csv
  
• First method
  • load data with json.loads
    
  • convert to csv
    
• Second method
  • use pandas pandas.read_json: https://pandas.pydata.org/pandas-docs/st..._json.html
    
  • and pandas DataFrame.to_csv: https://pandas.pydata.org/pandas-docs/st...o_csv.html
    

FWIW, the data you've shown isn't JSON. I don't know what format it is, but perhaps there's a library that parses it. Where did you get it?

This is not JSON

json file usually has suffix .json, not .txt
and must be valid json code which your file is not.