Using Python 3 preferably Using Selenium or any other Python Package Create a pr

Question

Using Python 3 preferably

Using Selenium or any other Python Package

Create a program that downloads that (CSV) file, Changes it's name (You pick a simple name) and imports it and outputs a graph(for example you can use Pandas or Matplotlib to create graphs) you'd be using the CSV file whose link is given the graph should compare at least 2 or 4 different values (you decide which ones you can choose any to your liking)

Important Note - When the Program downloads the file and changes (re-names) it have it so that every time it does that it overwrites it for example if you rename the file name to "Chegg Excel" (name it whatever you want) have it so that if the file already exists with the same name i.e (Chegg Excel) that the code overwrites it or that theres is function in the code that overwrites it or deletes the previous one so only one "Chegg Excel" file exsists.

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

Explanation / Answer

import xlsxwriter
import random
# Example data
# Try to do as much processing outside of initializing the workbook
# Everything beetween Workbook() and close() gets trapped in an exception
import pandas as pd
df=pd.read_csv('myfile.csv', sep=',',header=1)
dataxls = df.value

# Data location inside excel
data_start_loc = [0, 0] # xlsxwriter rquires list, no tuple
data_end_loc = [data_start_loc[0] + len(dataxls), 0]

workbook = xlsxwriter.Workbook('Chegg Excel.xlsx')

# Charts are independent of worksheets
chart = workbook.add_chart({'type': 'line'})
chart.set_y_axis({'name': 'Random jiggly bit values'})
chart.set_x_axis({'name': 'Sequential order'})
chart.set_title({'name': 'Insecure randomly jiggly bits'})

worksheet = workbook.add_worksheet()

# A chart requires data to reference data inside excel
worksheet.write_column(*data_start_loc, data=dataxls)
# The chart needs to explicitly reference data
chart.add_series({
'values': [worksheet.name] + data_start_loc + data_end_loc,
'name': "Random data",
})
worksheet.insert_chart('B1', chart)

workbook.close() # Write to file

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

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