why drop row got error AttributeError: 'DataFrame' object has no attribute 'No'

Question

Hi I am trying to drop a row from a Data frame, loaded from a CSV file:

no_show_raw_data = pd.read_csv("noshowappointments.csv")

df = no_show_raw_data

new_df = df[df.No-show != 'No']

but i get this error:

AttributeError: 'DataFrame' object has no attribute 'No'

576i · Accepted Answer · 2018-11-24 13:30:08Z

1

The columns No-show has a minus sign in the name, try brackets instead:

no_show_raw_data = pd.read_csv("noshowappointments.csv")

df = no_show_raw_data

new_df = df[df['No-show'] != 'No']

answered Nov 24, 2018 at 13:30

576i

8,44216 gold badges62 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

If it worked for you, please mark this question as solved, so it's no longer open.