Question: You can access json data from the following url: http://jsonplaceholder.typicode.com/users. From the user data, make a DataFrame df that consists of 'username', 'email', 'zipcode', 'lat',

You can access json data from the following url: http://jsonplaceholder.typicode.com/users.

From the user data, make a DataFramedfthat consists of 'username', 'email', 'zipcode', 'lat', 'lng', and 'company_name'. ('zipcode' is under 'address', 'lat', and 'lng' are under 'geo' under 'address', and 'company_name' is 'name' under 'company'.)

Select the rows whose 'lng' values are greater than 0 and whose 'lat' is less than 0. You may display all the columns. Name itdf_a.

create output file ofdf_ain the csv format named 'output.csv'.

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 Programming Questions!