Question: need help in python using panda dataframe for this coding practice Load the dataset file into a variable named df and do the following: 1.

need help in python using panda dataframe for this coding practice

Load the dataset file into a variable named df and do the following: 1. Perform the merge of the FIRST_NAME and CITY columns separated by a , (comma) only for students with MAJOR_DESC = Biology and store them in another variable called "series" (This variable will be "m" rows by 1 column).

need help in python using panda dataframe for this coding practice Load 2. Transform series(mx1) to a single row and 1 column by concatenating all rows and save it to another variable out (separated by commas)

the dataset file into a variable named df and do the following: 3. Save the result contained in out to a file outFile_1.CSV

1. Perform the merge of the FIRST_NAME and CITY columns separated by

NOTE: Use a for loop to automatically produce the 1 outFile_*.CSV files for Biology. The general idea is presented in the following figure.

a , (comma) only for students with MAJOR_DESC = Biology and store______> outfile_1.csv

dataset.csv

FIRST_NAME CITY MAJOR_DESC GPA
ABIMAEL Manati CRIMINAL JUST FORENSIC INVEST 3.18
ADIAN Carolina BUSINESS ADMIN GENERAL PROGRAM 3
ADIELYS San Juan BUSINESS ADMIN GENERAL PROGRAM 1.5
ADRIANA Bayamon BIOLOGY 2.25
ADRIANA Sabana Seca CRIMINAL JUST FORENSIC INVEST 2.9
ADRIANA San Juan CRIMINAL JUST FORENSIC INVEST 3.26
ADRIANA San Juan MARKETING 3
AIRAM Bayamon FORENSIC SCIENCES 1.29
ALANIS Corozal COSMETOLOGY TECHNICIAN 4

Qute = adriana, Balumon, alondra, Tae-basa.on (11) "save" outfile_1.csy dataset \& Progrima

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!