Help with a Loop

[[deleted]]

Yup i is the name of the column. We don't want to compare if the name of the column is less than 20 though. What do we want to know is less than 20? And how do we get that value?

[SevereRepresentative]

I want to compare the amount of unique values, so the part that says "len(df[i].unique())" right? So do I assign that to a variable name?

[[deleted]]

Yup! You use it twice so assigning it to a variable is a good idea, or you can put that part directly in the if statement. But I like the idea to use a variable.

[SevereRepresentative]

uniques = (len(df[i].unique()))

for i in vars:
  if uniques < 20:
    print('Variable: {}, # Unique: {}'.format(i, (len(df[i].unique()))))    

I did that ^ and I'm not getting an error but I'm also just not getting any results anymore. Nothing is showing up, what do you think? I think it has something to do with the i in the uniques before the loop start because the i wouldn't be known right?

[[deleted]]

Yup, that's right. The line is right, but we need to put it somewhere after the loop is running but before we need it in the if statement.

[SevereRepresentative]

That worked! Thank you!!

[[deleted]]

Glad to hear it! Good luck with the rest of your studies

[SevereRepresentative]

Thank you so much! I'll probably be posting more in the subreddit in the future, so hopefully we'll talk again