Embedded Files
The library Requests (allows for HTTP requests in Python) was used to save a copy of the data set to a folder.
Pandas
Pandas
Pandas library offers its own method to import CSV files and convert them into a dataframe (Multi-dimensional Array)
Has the ability to differentiate between a file on your system and a website URL (as a parameter to the function)
Numerical index is deafult but can be changed if need be
Column titles can be passed as a parameter or included in the file as the first row
pandas.read_csv("file name/path or website URL")
Must be set to a varaible to be saved and implemented
Reading a CSV FileReading a CSV Link
Creating a CSV file from Excel Using XLRD
Creating a CSV file from Excel Using XLRD
**Using XLRD to create a CSV file from a spreadsheet was unessary, all systems have the ability to save a Excel file as a CSV file. Learning to use the library is still valuable for any future data analysis with Excel.**
XLRD
XLRD
Imported library with the ability to access Microsoft Excel files
The Excel File was already cleaned to include only the data in question (columns that were not going to be analyzed were removed and same with countries)
xlrd.open_workbook("file name/path")
Store in a variable so the workbook (file) can be refered to
workbookvariable.sheet_by_index(index of sheet starting from 0)
Store in variavle so sheet methods can be accessed
sheetvariable.cell_value(column, row)
Each cell in the file was read and placed into an array. After every column the array was copied into a master array and reset to read the next column in the spreadsheet
CSV
CSV
Python library used when dealing with CSV files (Ex: reading or writing)
Paired with Python function with open
File "coviddata.csv" was created and using csv.writer(file) the spreadsheet data was imported into the file as a CSV format
Create and open file in write modeCreate CSV writerIterate through dataWrite data into file separated by rowsClose file
Page updated
Google Sites
Report abuse