I want to create a list using query

Viewed 17

I want to use query to generate a list for normal and abnormal heart sounds. T tried this:

training_a = pd.read_csv('.../training-a/REFERENCE-SQI.csv',
                names=["wavfile", "actuals", "pred"])
training_b = pd.read_csv('.../training-b/REFERENCE-SQI.csv',
                names=["wavfile", "actuals", "pred"])
training_c = pd.read_csv('.../training-c/REFERENCE-SQI.csv',
                names=["wavfile", "actuals", "pred"])
training_d = pd.read_csv('.../training-d/REFERENCE-SQI.csv',
                names=["wavfile", "actuals", "pred"])
training_e = pd.read_csv('.../training-e/REFERENCE-SQI.csv',
                names=["wavfile", "actuals", "pred"])
training_f = pd.read_csv('.../training-f/REFERENCE-SQI.csv',
                names=["wavfile", "actuals", "pred"])

train = pd.concat([training_a, training_b, training_c, training_d, training_e, training_f], axis=0)
normals = train.query('actuals == "1"')['wavfile'].tolist()

but the normals list is empty

0 Answers
Related