Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a variable named df _ bank _ row _ count and assign the number of rows ( aka number of observations ) in the

Create a variable named df_bank_row_count and assign the number of rows (aka number of observations) in the bank data (
df
bank). Create a variable named
df
bank_column_count and assign the number of columns (aka number of variables) in the bank data (
df
bank). Create a variable named df_movies_row_count and assign the number of rows (aka number of observations) in the movies data (
df
movies). Create a variable named df_movies_column_count and assign the number of columns (aka number of variables) in the movies data (df_movies). Note: Your code goes in the below cell. Do not hard code it (do not look up the excel file and count the number of rows and observations manually). Use pandas operations/functions.[10]"'Your code goes in this cell."'[11]\# Run this cell. It will display the results of your code for two cases \# Do not change this cell. print (df_bank_row_count) print (df_bank_column_count) print (df_movies_row_count) print (df movies_column count) Test case for question 1-\# Run this cell. \# This is a test case \# It will tell you whether or not you pass the question \# Do not change this cell. try: if
((df
_bank_row_count
==11162)&(df
_bank_column_count
==17)&(df
movies_row_count
==1000)&(df
_movies_column_count
==12))
: score['question 1']= 'pass' else: score['question 1']= 'fail' except: score['question 1']= 'fail' score

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro Database Migration To Azure Data Modernization For The Enterprise

Authors: Kevin Kline, Denis McDowell, Dustin Dorsey, Matt Gordon

1st Edition

1484282299, 978-1484282298

More Books

Students also viewed these Databases questions