STEP 1. Please read the posts for Week 12. STEP 2. Download and install Python on your personal…

STEP 1. Please read the posts for Week 12.

STEP 2. Download and install Python on your personal computer.

STEP 3. Download and install Visual Code on your personal computer.

STEP 4. Create a folder A12_YourLastName (i.e., A12_Pangelinan).

STEP 5. Create all the following Python files in your folder:

1. data-read-01.py
2. pandas-01.py
3. pandas-02.py
4. pandas-03.py
5. pandas-04.py

STEP 6. Download the following files to your folder:

1. data-01.csv Download data-01.csv
2. white_house_2017_salaries.csv Download white_house_2017_salaries.csv
3. university_rankings.csv Download university_rankings.csv

STEP 7. data-read-01.py. (20 points)

1. In your source code, import csv, which will assist in parsing your file, data-01.csv.
2. Open the file and read each row.
3. Print each row to the terminal.

STEP 8. pandas-01.py. (20 points)

1. Install pandas by using pip install.
2. Open the file, data-01.csv, and read each row using pandas.
3. Print each row to the terminal.

STEP 9. pandas-02.py. (20 points)

1. Import pandas as pd.
2. Create a dictionary of series below
d = {‘Name’:pd.Series([‘Tom’,’James’,’Ricky’,’Vin’,’Steve’,’Smith’,’Jack’,
‘Lee’,’David’,’Gasper’,’Betina’,’Andres’]),
‘Age’:pd.Series([25,26,25,23,30,29,23,34,40,30,51,46]),
‘Rating’:pd.Series([4.23,3.24,3.98,2.56,3.20,4.6,3.8,3.78,2.98,4.80,4.10,3.65])
}
3. Create a DataFrame named df.
4. Print the DataFrame.

STEP 10. pandas-03.py. (50 points)

1. Import pandas as pd.
2. Read the Salaries file, white_house_2017_salaries.csv, as a DataFrame called sal.
3. Print DataFrame head (first two rows). Include heading, “DATAFRAME HEAD”.
4. Print DataFrame info. Include heading, “DATAFRAME INFORMATION”.
5. Print the average salary. Include string, “AVERAGE SALARY = “.
6. Print the maximum salary. Include string, “MAXIMUM SALARY = “.
7. Print the minimum salary. Include string, “MINIMUM SALARY = “.
8. Print the Dino L. LaVerghetta’s position. Include heading, “DINO LAVERGHETTA’S POSITION TITLE”.
9. Print all the data items for Monica J. Block. Include heading, “MONICA BLOCK’S DATA ITEMS”.
10. Print the least paid employees. Include heading, “LEAST PAID EMPLOYEE(S)”.
11. Print the total number of positions. Include heading, “NUMBER OF POSITIONS”.
12. Print the Top 3 most common positions. Include heading, “TOP 3 POSITIONS”.
13. Print the sum of positions that contain the word, “Assistant”. Include heading, “SUM OF POSITIONS CONTAINING THE WORD, ASSISTANT”.

STEP 11. pandas-04.py. (40 points)

1. Import pandas as pd.
2. Read the University Rankings file, university_rankings.csv, as a DataFrame called rank.
3. Print DataFrame head (first two rows). Include heading, “DATAFRAME HEAD”.
4. Print DataFrame info. Include heading, “DATAFRAME INFORMATION”.
5. Print the number of ranked USA colleges/universities in 2014. Include heading, “NUMBER OF RANKED USA COLLEGES/UNIVERSITIES IN 2014”.
6. Print the Top 10 ranked JAPAN colleges/universities in 2015. Include heading, “TOP 10 JAPAN COLLEGES/UNIVERSITIES IN 2015”.

STEP 12. Compress your folder into a zip file and upload it to this assignment.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Online Academic Experts
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Other
Thank you , Excellent work
Customer 453201, June 2nd, 2022
Management
Love this writer!!! Great work
Customer 452597, April 5th, 2021
Business Studies
Amazing!
Customer 452985, November 11th, 2021
Business Studies
Paper is great. Just only needed the one reference. Thank you
Customer 453139, May 4th, 2022
Education
Very fast response and did a excellent job.
Customer 453201, May 31st, 2022
Psychology
quick and before due date/time.
Customer 453027, January 29th, 2022
History
Looks great and appreciate the help.
Customer 452675, April 26th, 2021
History
Thank you. No issues
Customer 453139, April 17th, 2022
Human Resources Management (HRM)
Very well written and very impressed with this service!
Customer 453077, February 16th, 2022
Business Studies
Thank you so much! I had to take my dog to the ER and had no time for the assignment. I really appreciate your help! I can't thank you enough! I really appreciate the work and integrity put into it. Thank you for taking it seriously and not bullshiting the paper.
Customer 452815, July 26th, 2021
Nursing
thank you so much
Customer 452749, June 10th, 2021
Health Care
The writer did not follow my choice of topic (Food/Water Insecurity, Hunger, & Poverty), the paper was instead written about Climate Change in Africa. However, the paper was still great and informative. Thank you!
Customer 452777, January 28th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
AllEscortAllEscort
Live ChatWhatsApp
AllEscort