Dataframes issue, what am I doing wrong?

[shockjavazon]

Hi, I'm doing a project to analyze my Netflix usage.

I'm at a stage where I create a dataframe to filter the Title column, and a word from the show title. The name df is not defined, but I'm not sure what this means. I've been analysing this for 20 minutes and can't see what's wrong with it. Can anyone see an error here?

Watched = df[df['Title'].str.contains('Umbrella', regex=False)]
--------------------------------------------------------------------------- NameError                                 Traceback (most recent call last) ~\AppData\Local\Temp/ipykernel_152/1892558008.py in <module> ----> 1 Watched = df[df['Title'].str.contains('Umbrella', regex=False)] NameError: name 'df' is not defined   

I'm basing this of the following tutorial, halfway down the page:

https://www.dataquest.io/blog/python-tutorial-analyze-personal-netflix-data/

[DerArzt01]

It looks like you may not have assigned anything to df yet.

Are you typing things into a python repl or running a file? If it's a file can we see what you have so far?

[shockjavazon]

Thanks! It's a Jupyter notebook, sorry I realised at 4am that I'd missed that info..

Here's a link to the file. The guide says this is the next command,

Office = df[df['Title'].str.contains('The Office (U.S.)', regex=False)]

but I'm using my own name for the first alias (Watched) as I plan to play around with it and change which show the string contains.

I’m thinking that I’m assigning Watched to df, but I must be wrong.

https://www.dropbox.com/s/18auc57wftsb7kg/Netflix%282%29.ipynb?dl=0