How to solve a Python/Pandas problem?

Question

Python

Stuck on a Python task (Yandex Practicum)
import pandas as pd
data = pd.read_excel('/datasets/seo_data.xlsx', sheet_name='traffic_data')

Task:
Calculate how many rows are in the dataframe and display on the screen in the format:
Number of rows: 1000
Then display the rows that have a value of 'total' in the 'subcategory_id' column. Examine the results: how many rows corrupt the entire dataset?


Which way to solve??

Answer 1

print('Количество строк: {}'.format(len(data.index)))
data[data['subcategory_id'] == 'total']