Using Python preferablly Python 3 (you can use any Python package you like) Crea

Question

Using Python preferablly Python 3 (you can use any Python package you like)

Create a program that imports an excel file and outputs a graph (for example you can use MatplotLib to create graphs) you'd be using the CSV file whose link is given the graph should compare at least 2 values (you decide which ones) in the CSV file and must be able to generate a graph off of that data in the CSV file.

If a program could be made where it asks the user specifically what to compare with what would be better if not then make a program that compares any at least 2 things and list the name of the 2 values you selected that would be used to generate a graph. Preferablly we are looking for the graph to output 4 values. Link to the CSV file is given

CSV File Link - https://www.dropbox.com/s/np27ad1np39cssg/Excel%20Heavily%20Modded%20CSV.csv?dl=0

Explanation / Answer

edited:

import pandas as pd

import matplotlib.pyplot as plt

vers=pd.read_csv("Excel Heavily Modded CSV")

p=pd.DataFrame(list(zip(vers['Students_Failed'],vers['InternationalStudents_Failure%'])),index=vers['Region of State'],columns=['a','b'])

p.plot.bar()

This basically plots the student failed and InternationalStudents_Failure% in a bar graph according to the regions on x axis.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.