Football database design
The goal was to implement MySQL (MariaDB) database filling by sports data gathered through REST API. DB schema was designed and tested on performance and internal consistency. Data were processed with parser written on Python.
- Data mining and web scraping using Python - Providing and using API (REST, GraphQL) - Any web automation, search automation using Selenium Webdriver - Data exploring and processing, tasks and processes automation using Python - Data converting from/to XLSX, JSON, XML, PDF, DOCX, etc. - Desktop applications, Windows applications using PyQT - SQL, NoSQL Database integration: MongoDB, MySql, MariaDB, etc. Data exploring & statistical analysis using R and Python: Scipy, Numpy, Pandas - Linear regression - Logistic regression - Pearson product-moment correlation coefficient - Spearman's rank correlation coefficient - Kendall tau rank correlation coefficient - Pearson's chi-squared test - Fisher's exact test - Student's t-test - Mann - Whitney U-test - Analysis of variance (ANOVA) - Kruskal-Wallis test - Cluster analysis - Principal component analysis, etc. I would be pleased to consider proposals for long-term projects!