Re-write a json file to add missing data values with Pandas

Question

I am trying to re-write a json file to add missing data values. but i cant seem to get the code to re-write the data on the json file. Here is the code to fill in missing data:

import pandas as pd
import json 



data_df = pd.read_json("Data_test.json")

#replacing empty strings with nan
df2 = data_df.mask(data_df == "")

#filling the nan with data from above. 
df2["Food_cat"].fillna(method="ffill", inplace=True,)

"Data_test.json" is the file with the list of dictionary and I am trying to either edit this json file or create a new one with the filled in data that was missing.

I have tried using

with open('complete_data', 'w') as f:
    json.dump(df2, f) 

but it does not seem to work. is there a way to edit the current data or create a new json file with the completed data?

this is the original data, I would like to keep this format.

Answer 1

Try to do this

import pandas as pd
import json 



data_df = pd.read_json("Data_test.json")

#replacing empty strings with nan
df2 = data_df.mask(data_df == "")

#filling the nan with data from above. 
df2["Food_cat"].fillna(method="ffill", inplace=True,)

df2.to_json('path_of_file.json')

Tell me if it works.