Pinned Repositories
excel2sql
Excel to Database Converter__________________________________________________ A python script that converts an Excel XML spreadsheet into an sqlite database copying the rows and columns into the database just the way they are in the Excel file. The code automatically cleans the XML file in order for it to be readable by the python library.
ituneslib
Itunes Library Analyzer________________________________________________________ This python script analyzes an xml Itunes library and extracts data of all the songs present (song name, artist name, album name and play count) and stores that info in a relational SQL database. Then it searches for the most played song
opensubs
Subtitles List Downloader______________________________________________________ A python script that retrieves the 40 latest subtitles info from opensubtitles.org (subtitle id, subtitle language, movie/episode name, year released) and stores that information in a txt file and also in a sqlite relational database.
vgsales-analysis
Videogame Sales Visualizations_____________________________________________ #Python #SQLITE #database #matplotlib #numpy #Tableau #barplots #seaborn #DataAnalysis
vgsales-csv-data-cleaning-
Excel csv file cleaning: Rows with missing Year ('it says N/A'), Rows with missing Publisher ('it says N/A' or 'Unknown'), Rows where Global sales doesn't equal to the sum of regional sales (NA sales, EU sales, JP sales, Other sales)
vgsales-dashboard
Video Game Sales - Tableau Interactive Dashboard____________________________ This dashboard displays the sales data and gives information on the most successful game genres, platforms and publishers. The user can use of parameter controls and filters to affect the data displayed.
nathan-mosesuk's Repositories
nathan-mosesuk/excel2sql
Excel to Database Converter__________________________________________________ A python script that converts an Excel XML spreadsheet into an sqlite database copying the rows and columns into the database just the way they are in the Excel file. The code automatically cleans the XML file in order for it to be readable by the python library.
nathan-mosesuk/ituneslib
Itunes Library Analyzer________________________________________________________ This python script analyzes an xml Itunes library and extracts data of all the songs present (song name, artist name, album name and play count) and stores that info in a relational SQL database. Then it searches for the most played song
nathan-mosesuk/opensubs
Subtitles List Downloader______________________________________________________ A python script that retrieves the 40 latest subtitles info from opensubtitles.org (subtitle id, subtitle language, movie/episode name, year released) and stores that information in a txt file and also in a sqlite relational database.
nathan-mosesuk/vgsales-analysis
Videogame Sales Visualizations_____________________________________________ #Python #SQLITE #database #matplotlib #numpy #Tableau #barplots #seaborn #DataAnalysis
nathan-mosesuk/vgsales-csv-data-cleaning-
Excel csv file cleaning: Rows with missing Year ('it says N/A'), Rows with missing Publisher ('it says N/A' or 'Unknown'), Rows where Global sales doesn't equal to the sum of regional sales (NA sales, EU sales, JP sales, Other sales)
nathan-mosesuk/vgsales-dashboard
Video Game Sales - Tableau Interactive Dashboard____________________________ This dashboard displays the sales data and gives information on the most successful game genres, platforms and publishers. The user can use of parameter controls and filters to affect the data displayed.