例外処理がうまくいかない

Question

実現したいこと

openposeのjsonファイルをCSVファイルに変換したいです。

下記の写真のような空のjsonファイルを無視してCSVファイルに変換する方法を教えて頂きたいです。
例外処理をしない状態だと下記のエラーがでます。
下記のコードのように例外処理をtryで行いたかったのですが、時間がかかる＆実行できない状態です。

発生している問題・エラーメッセージ

---------------------------------------------------------------------------
IndexError                                Traceback (most recent call last)
~\AppData\Local\Temp/ipykernel_28972/3865491861.py in <module>
     40 
     41 if __name__ == '__main__':
---> 42     main()

~\AppData\Local\Temp/ipykernel_28972/3865491861.py in main()
     37         writer.writerow(["Nose", "Neck", "RShoulder", "RElbow", "RWrist", "LShoulder", "LElbow", "LWrist", "MidHip", "RHip", \
     38             "RKnee", "RAnkle", "LHip", "LKnee", "LAnkle", "REye", "LEye", "REar", "LEar", "LBigToe", "LSmallToe", "LHeel", "RBigToe", "RSmallToe", "RHeel"])
---> 39     getSpecificData(filelist)
     40 
     41 if __name__ == '__main__':

~\AppData\Local\Temp/ipykernel_28972/3865491861.py in getSpecificData(filelist)
     13         with open(filelist[i]) as f:
     14             data = json.load(f)
---> 15             data = np.array(data['people'][0]['pose_keypoints_2d']).reshape(-1,3)
     16         df = pd.DataFrame(data, columns=['X','Y','P'], index=["Nose", "Neck", "RShoulder", "RElbow", "RWrist", "LShoulder", "LElbow", "LWrist", "MidHip", "RHip", \
     17             "RKnee", "RAnkle", "LHip", "LKnee", "LAnkle", "REye", "LEye", "REar", "LEar", "LBigToe", "LSmallToe", "LHeel", "RBigToe", "RSmallToe", "RHeel"])

IndexError: list index out of range

該当のソースコード

import json
import pandas as pd
import numpy as np
import glob
import csv

def getFileName(path):
    filelist = glob.glob(path+ "/*.json")
    return filelist

def getSpecificData(filelist):
    for i in range(len(filelist)):
        while True:
            try:

                with open(filelist[i]) as f:
                    data = json.load(f)
                    data = np.array(data['people'][0]['pose_keypoints_2d']).reshape(-1,3)
                df = pd.DataFrame(data, columns=['X','Y','P'], index=["Nose", "Neck", "RShoulder", "RElbow", "RWrist", "LShoulder", "LElbow", "LWrist", "MidHip", "RHip", \
                    "RKnee", "RAnkle", "LHip", "LKnee", "LAnkle", "REye", "LEye", "REar", "LEar", "LBigToe", "LSmallToe", "LHeel", "RBigToe", "RSmallToe", "RHeel"])

                # 自分の必要なデータを取り出す
                writeCSV([float(df.at["Nose", "X"]),float(df.at["Nose", "Y"]),float(df.at["Neck", "X"]),float(df.at["Neck", "Y"]),float(df.at["RShoulder", "X"]),float(df.at["RShoulder", "Y"]),float(df.at["RElbow", "X"]),float(df.at["RElbow", "Y"]), float(df.at["RWrist", "X"]), float(df.at["RWrist", "Y"]) ,float(df.at["LShoulder", "X"]),float(df.at["LShoulder", "Y"]),float(df.at["LElbow", "X"]) \
                    , float(df.at["LElbow", "Y"]), float(df.at["LWrist", "X"]), float(df.at["LWrist", "Y"]), float(df.at["MidHip", "X"]), float(df.at["MidHip", "Y"]), float(df.at["LWrist", "X"]), float(df.at["LWrist", "Y"]), float(df.at["RHip", "X"]), float(df.at["RHip", "Y"]), float(df.at["RKnee", "X"]), float(df.at["RKnee", "Y"]), float(df.at["RAnkle", "X"]), float(df.at["RAnkle", "Y"]), float(df.at["LHip", "X"]), float(df.at["LHip", "Y"])\
                    , float(df.at["LKnee", "X"]), float(df.at["LKnee", "Y"]), float(df.at["LAnkle", "X"]), float(df.at["LAnkle", "Y"]), float(df.at["REye", "X"]), float(df.at["REye", "Y"]), float(df.at["LEye", "X"]), float(df.at["LEye", "Y"]), float(df.at["REar", "X"]), float(df.at["REar", "Y"]), float(df.at["LEar", "X"]), float(df.at["LEar", "Y"]), float(df.at["LBigToe", "X"]), float(df.at["LBigToe", "Y"])\
                    , float(df.at["LSmallToe", "X"]), float(df.at["LSmallToe", "Y"]), float(df.at["LHeel", "X"]), float(df.at["LHeel", "Y"]), float(df.at["RBigToe", "X"]), float(df.at["RBigToe", "Y"]), float(df.at["RSmallToe", "X"]), float(df.at["RSmallToe", "Y"]), float(df.at["RHeel", "X"]), float(df.at["RHeel", "Y"])])
            
            except IndexError:
                pass


def writeCSV(data):
    with open('openposetameshi.csv', 'a') as f: #変更
        writer = csv.writer(f, lineterminator='\n') 
        writer.writerow(data)

def main():
    filelist = getFileName(input("JSONのディレクトリのパスを入力:　"))
    with open('openposetameshi.csv', 'w') as f: #変更
        writer = csv.writer(f, lineterminator='\n') 
        # 自分の必要なデータの列の名前を用意。上のデータと同じだけの列数を揃える。
        writer.writerow(["Nose", "Neck", "RShoulder", "RElbow", "RWrist", "LShoulder", "LElbow", "LWrist", "MidHip", "RHip", \
            "RKnee", "RAnkle", "LHip", "LKnee", "LAnkle", "REye", "LEye", "REar", "LEar", "LBigToe", "LSmallToe", "LHeel", "RBigToe", "RSmallToe", "RHeel"])
    getSpecificData(filelist)

if __name__ == '__main__':
    main()

試したこと

ここに問題に対して試したことを記載してください。

補足情報（FW/ツールのバージョンなど）

通常のjsonファイル

空のjsonファイル

Answer 1

そもそもですが、jsonデータが正常か？をチェックして、その結果で処理を分けたほうがよいです。

for i in ～:
    with open(filelist[i]) as f:
        data = json.load(f)

    if 'people' in data and len(data['people']) > 0: # たとえば
        # 正常処理
    else:
        # 異常
        print('error')