Question

Using pandas Read in the movies.csv into a dataframe named movies, display the first 5 rows and answer

* Use the filter method to select the column names that contain the exact string facebook

[ ]

* Use the count method to find the number of non-missing values for each column.

[ ]

* Display the count of missing values for each column

Answer 1

import pandas as pd

movies = pd.read_csv('movies.csv')
movies.head(5)     #5 is also the default, if you do not pass anything

#Complete data frame
print(movies)

movies.filter(like='facebook')

#Count of non-missing values column-wise
movies.notnull().sum()

movies.isnull().sum()