Pinned Repositories
ETL-with-Apps-script-and-VBA
Transforming and gathering data from google spreadsheets and loading an output to main Excel file
PCPP
Certified Professional in Python Programming 1 (My Solutions)
Data-analysis-predictive-with-R-and-EViews-
Quantitative(statistical) data analysis and ML
Data-mining-and-analysis-with-Linux-and-Python
More than 20k .csv files given. The structure of each file doesn't have a "data frame" structure, however the structure of each file is similar to another. The task is to join all .csv files in one and to keep such form of file that will allow to make further analysis. For this purpose Linux(bash) was used. For further analysis, Python (pandas) was used.
Deduplication-task-with-Python-and-snowflake
Two(or more) car sellers have similar names, such as "Car Angelo" and "Car Angelo s.r.o". The task is to calculate the percentage of name similarity by using Levenshtein distance, and then to analyze how many cars in stock have two sellers with similar name, also to determine whether these cars are "duplicates".
Frequency-of-words-using-SQL-snowflake-
Data from online car store is given. Each car has it's description in form of text. This text was standardized by removing all symbols except strings, then this strings was lowered. The lowered standardized text was divided by each word, using " "(space) as delimiter. As a final output, row numbers of table were extended due to increase of one row to multiple rows by number of words in text. This table can be used as input for visualization (e.g. Power BI) to show the percentage of each word frequency in whole data.
Google-translate
Text translation in Python
My-Tic-Tac-Toe-in-Python
Simple game was made by using only lists and dictionaries.
OOP-BLACKJACK-MULTIPLAYER
Interactive Blackjack multiplayer game. Made by using Object Oriented programming principles
OOP-Simple-game
Card game "War" using OOP paradigm
dedem7's Repositories
dedem7/PCPP
Certified Professional in Python Programming 1 (My Solutions)
dedem7/ETL-with-Apps-script-and-VBA
Transforming and gathering data from google spreadsheets and loading an output to main Excel file
dedem7/OOP-BLACKJACK-MULTIPLAYER
Interactive Blackjack multiplayer game. Made by using Object Oriented programming principles
dedem7/OOP-Simple-game
Card game "War" using OOP paradigm
dedem7/Replacement-of-category
Cars dataset is given. There different models of cars with different transmissions such as automatic, semi automatic and manual. The task is to investigate whether the car feature of semi automatic transmission can be replaced by automatic. (scatter plots and cluster analysis)
dedem7/My-Tic-Tac-Toe-in-Python
Simple game was made by using only lists and dictionaries.
dedem7/Univariate-analysis-Python
Comparison of car prices between Germany and Czech republic markets by conducting dependency analysis and linear model.
dedem7/Deduplication-task-with-Python-and-snowflake
Two(or more) car sellers have similar names, such as "Car Angelo" and "Car Angelo s.r.o". The task is to calculate the percentage of name similarity by using Levenshtein distance, and then to analyze how many cars in stock have two sellers with similar name, also to determine whether these cars are "duplicates".
dedem7/Frequency-of-words-using-SQL-snowflake-
Data from online car store is given. Each car has it's description in form of text. This text was standardized by removing all symbols except strings, then this strings was lowered. The lowered standardized text was divided by each word, using " "(space) as delimiter. As a final output, row numbers of table were extended due to increase of one row to multiple rows by number of words in text. This table can be used as input for visualization (e.g. Power BI) to show the percentage of each word frequency in whole data.
dedem7/Google-translate
Text translation in Python
dedem7/Data-analysis-predictive-with-R-and-EViews-
Quantitative(statistical) data analysis and ML
dedem7/Data-mining-and-analysis-with-Linux-and-Python
More than 20k .csv files given. The structure of each file doesn't have a "data frame" structure, however the structure of each file is similar to another. The task is to join all .csv files in one and to keep such form of file that will allow to make further analysis. For this purpose Linux(bash) was used. For further analysis, Python (pandas) was used.