Question: Q1 Structured Data: Manipulating Series 6 Points Consider the enrollF16.csv file shown below: College Baruch Brooklyn City Hunter John Jay Lehman Medgar Evers NYCCT Queens

Q1 Structured Data: Manipulating Series 6 Points Consider the enrollF16.csv file shown below: College Baruch Brooklyn City Hunter John Jay Lehman Medgar Evers NYCCT Queens Staten Island York Full-time 11,288 10,198 10,067 12,223 9,831 6,600 4,760 10,912 11,693 9,584 5,066 Undergraduate Part-time 3,922 4,208 3,250 4,500 2,843 4,720 2,059 6,370 4,633 2,948 3,192 Total 15,210 14,406 13,317 16,723 12.674 11,320 6,819 17,282 16,326 12,532 8,258 and the following code: import pandas as pd df = pd.read_csv('enrollF16.csv',skiprows=1) Answer the following questions. Q1.1 2 Points What is the output for: print(df['Part-time'].min() IMPORTANT: to get credit you must report the data exactly as it appears in the table above, including commas. Enter your answer here Q1.2 2 Points Write the code that would print out the average total enrollment: IMPORTANT: to get credit, type the instruction on a single line with no spaces. Use single quotes around column names. Enter your answer here Q1.3 2 Points Write the code that would create a new column named 'Fraction Full-time' from values in the existing columns: IMPORTANT: to get credit, type the on a single line with no spaces. Use single quotes around column names. Enter your answer here
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
