skip to Main Content

Extract key, value pair from nested json file

I am trying to extract the name, longitude and latitude from a json file and convert it into a new .csv file with the columns cityname | longitude | latitude from this json: https://www.submarinecablemap.com/api/v3/landing-point/landing-point-geo.json def cables(): # print(page.text) # print(page2.text)…

VIEW QUESTION

Need help converting dataframe to json format

I have a table which has some sample data as provided below import pandas as pd data = { "mode": ["single_table_list", "single_table_list", "single_table_list", "relational_table_list", "relational_table_list"], "type": ["type_a", "type_b", "type_c", "parent_table", "child_table"], "file_name": ["file_a", "file_b", "file_c", "file_d", "file_e"], "file_path": ["path_a", "path_b",…

VIEW QUESTION
Back To Top
Search