How to discard names with a single character from data frame?

Question

Can anyone tell me how can I remove all 'A's and other data like this from the data frame? and I also want to remove XXXX rows from the data frame.

Answer 1

Use Series.str.len with Series.ne to performance a boolean indexing

if you want to delete the column where name is A :

df[df['name'].ne('A') & df['year'].ne('XXXX'))]

to detect when lenght of string in column name is greater than one.

df[df['name'].str.len().gt(1) & df['year'].ne('XXXX')]

Answer 2

In order to remove all the lines where in column name you have 1-character long string just do:

df = df.drop(df.index[df["name"].str.len().eq(1)], axis=0)

Similarly for the XXXX rows:

df = df.drop(df.index[df["year"].eq("XXXX")], axis=0)

And combined:

df = df.drop(df.index[df["name"].str.len().eq(1) | df["year"].eq("XXXX")],axis=0)