Kuldip Joshi
Reputation: 47
How to convert csv to complex json
How to do this stuff in python pandas? I am trying to make put request to some API and not sure how to generate request body since I have the csv file only . Request body asks for fixed set of schema
Upvotes: 0
Views: 37
Answers (1)
Robert Axe
Reputation: 414
Dataframe has a function to_dict.
documents = df.to_dict(orient='records')
result = {'items': documents}
Upvotes: 1
Related Questions
- Convert JSON to CSV Nested JSON with Python Pandas
- python I got a complex multiple nested JSON file, how to convert to csv file
- Using Pandas to convert csv to Json
- CSV to json convert
- Converting csv to json file format . not sure how to achieve the expected output in json using pandas or python
- Convert CSV Data to Nested JSON in Python
- Convert JSON to CSV with complex arrays in Python
- converting JSON to CSV file
- Python - JSON convertion with Pandas to CSV
- CSV to nested JSON using Python/pandas