pandas_snippets

sample.py

def testAnswer_to_df(json_str):
    row = []
    for i in range(len(data)):    
        member_id = data[i]['memberid']
        if 'listen_score' in data[i]:
            score_ary  = data[i]['listen_score']['score_ary']  if 'score_ary' in data[i]['listen_score'] else np.nan
            avg        = data[i]['listen_score']['average'] if 'average' in data[i]['listen_score'] else np.nan
            answer_ary = data[i]['listen_score']['answer_ary'] if 'answer_ary' in data[i]['listen_score'] else np.nan
        else:
            score_ary  = np.nan
            avg        = np.nan 
            answer_ary = np.nan
        row.append([member_id, score_ary, avg, answer_ary])
    df = pd.DataFrame(row, columns=['memberid', 'score_ary', 'average', 'answer_ary'])
    df = df.set_index('memberid')
    return df