Question: Question 2 - Data Manipulating: Pandas ( 1 8 Pts ) Implement the following tasks by using Pandas library. [ Task - 2 . 1

Question 2- Data Manipulating: Pandas (18 Pts)
Implement the following tasks by using Pandas library.
[Task-2.1](2 Pts) Load "state_areas.csv", "state_abbrevs.csv" and "state_population.csv" files into separate DataFrames and print them.
[Task-2.2](4 Pts) Merge "state_abbrevs" and "state_areas". Name the DataFrame as "df1". Print the result.
[Task-2.3](4 Pts) Merge "df1" and "state-pop" using necessary keywords to obtain the Data Frame given in Figure-1. Name the DataFrame as "df2". Print the result.
2
\table[[,state,abbreviation,rea,ages,year,population],[0,Alabama,AL,52423,total,2012.0,4817528.0],[1,Alaska,AK,656425,total,2012.0,730307.0],[2,California,CA,163707,total,NaN,37999878.0],[3,Louisiana,LA,51843,total,2012.0,4602134.0],[4,Louisiana,LA,51843,under18,2011.0,1116579.0],[5,Mississippi,MS,48434,under18,2012.0,742941.0],[6,Washington,WA,71303,total,2011.0,NaN
 Question 2- Data Manipulating: Pandas (18 Pts) Implement the following tasks

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!