Script to update a subscriptions csv with a new feature

update_subscription_feature_csv.py

import pandas as pd
import json
  
# reading the csv file
df = pd.read_csv("c.csv")
df.fillna('{}', inplace=True)

for i, r in df.iterrows():
    json_object = json.loads(str(r['meta_data']))
    feature = 'new_feature_to_add'
    if "features" in json_object:
        json_object['features'] += [feature]
    else:
        json_object['features'] = [feature]

    df.at[i,'meta_data'] = json.dumps(json_object)

df.columns = ['subscription[id]', 'subscription[meta_data]']
  
# writing into the file
df.to_csv("update-0802.csv", index=False)