a,b,d,f,e,2014-09-16T01:57:48.295Z,2017-07-13T02:01:03.059Z
s,d,fe,r,t,2014-09-17T01:57:48.295Z,2017-07-23T02:01:03.059Z
wa,db,td,yf,de,2013-09-26T01:57:48.295Z,2017-07-13T02:01:03.059Z
aws,dedr,tgyfe,juir,ttt,2018-09-17T01:57:48.295Z,2017-07-23T02:01:03.059Z

# load json in panda dataframe
# parses through the json (normalize)
# filter required columns and write into .csv file
# remove the index field (first column)


def conversion():
    data_set = pd.read_json("/a/b/c.json")
    normalized_data = json_normalize(data_set['data'])
    new_data=pd.DataFrame(normalized_data['data'].values.tolist())
    filtered_data = new_data[["f1","f2","f3","f4","f5","date1","date2"]]
    filtered_data.to_csv("/a/b/c/file1.csv",index=False)

conversion()

a,b,d,f,e,2014-09-16 01:57:48,2017-07-13 02:01:03
s,d,fe,r,t,2014-09-17 01:57:48,2017-07-23 02:01:03
wa,db,td,yf,de,2013-09-26 01:57:48,2017-07-13 02:01:03
aws,dedr,tgyfe,juir,ttt,2018-09-17 01:57:48,2017-07-23 02:01:03