Pinned Repositories
Amazon-Vine-Analysis
After creating an Amazon RDS and creating a database and schema for tables in pgadmin, I extracted an s3 dataset file into google colab and inserted the data and columns into these tables by connecting Amazon RDS to our tables. Afterward, I exported the vine table, and I transformed the data to answer specific questions needed for the project.
Bikesharing
Several visualizations have been requested from us to show whether this business proposal is acceptable or not. These visualizations consist of displaying the length of time all genders use these bikes, and counting the number of bike trips for all genders and type of users for each hour of every day in the week.
Credit-Risk-Analysis
I am asked to resample the credit card data since it is not balanced. First, I start to split the data and perform oversampling with RandomOverSampler and SMOTE method, and I undersample with ClusterCentroids algorithm. Then, I utilize the SMOTEENN method to oversample and undersample the data. Finally, I used ensemble models.
Cryptocurrrencies
The purpose of this project was to utilize unsupervised machine learning to evaluate a cryptocurrency database and provide a report that categorizes traded cryptocurrencies into groups based on their characteristics.
Global-Crop-Yield-Analysis
This project showcased the influence of global rainfall and temperature on crop yield, predicted the yield based on the customer's input, and recommended the three most efficient crops for a specific country.
Movies-ETL
The purpose of this project is to extract the kaggle, wiki movies and ratings dataframe and transform them into usable data and finally load the data inside a PostgreSQL database.
Pewlett-Hackard-Analysis
The purpose of the analysis is creating several tables with SQL in order to determine the number of retiring empolyees per title and find out who is eligible to sign up for the mentorship program
Plotly
Representing the top 10 sample values of bacteria found in the candidate's belly button based on their OTU ID with bar and bubble chart and showing the belly button washing frequency of candidate's weekly with gauge chart.
UFO
It is requested that we modify the UFO sightings website that we already have, which filtered the data by clicking on a filter table button to create five input boxes to filter the data based on date, city, state, country, and shape by noticing the change of the text in the input boxes without clicking a button.
World-Weather-Analysis
The goal of this project is to create a vacation map that allows users to search for suitable travel destinations and present the user with selected suitable hotels within their preferred trip destinations using Google APIs.
SohrabRezaei's Repositories
SohrabRezaei/Global-Crop-Yield-Analysis
This project showcased the influence of global rainfall and temperature on crop yield, predicted the yield based on the customer's input, and recommended the three most efficient crops for a specific country.
SohrabRezaei/Cryptocurrrencies
The purpose of this project was to utilize unsupervised machine learning to evaluate a cryptocurrency database and provide a report that categorizes traded cryptocurrencies into groups based on their characteristics.
SohrabRezaei/Movies-ETL
The purpose of this project is to extract the kaggle, wiki movies and ratings dataframe and transform them into usable data and finally load the data inside a PostgreSQL database.
SohrabRezaei/Pewlett-Hackard-Analysis
The purpose of the analysis is creating several tables with SQL in order to determine the number of retiring empolyees per title and find out who is eligible to sign up for the mentorship program
SohrabRezaei/Plotly
Representing the top 10 sample values of bacteria found in the candidate's belly button based on their OTU ID with bar and bubble chart and showing the belly button washing frequency of candidate's weekly with gauge chart.
SohrabRezaei/UFO
It is requested that we modify the UFO sightings website that we already have, which filtered the data by clicking on a filter table button to create five input boxes to filter the data based on date, city, state, country, and shape by noticing the change of the text in the input boxes without clicking a button.
SohrabRezaei/World-Weather-Analysis
The goal of this project is to create a vacation map that allows users to search for suitable travel destinations and present the user with selected suitable hotels within their preferred trip destinations using Google APIs.
SohrabRezaei/Amazon-Vine-Analysis
After creating an Amazon RDS and creating a database and schema for tables in pgadmin, I extracted an s3 dataset file into google colab and inserted the data and columns into these tables by connecting Amazon RDS to our tables. Afterward, I exported the vine table, and I transformed the data to answer specific questions needed for the project.
SohrabRezaei/Bikesharing
Several visualizations have been requested from us to show whether this business proposal is acceptable or not. These visualizations consist of displaying the length of time all genders use these bikes, and counting the number of bike trips for all genders and type of users for each hour of every day in the week.
SohrabRezaei/Credit-Risk-Analysis
I am asked to resample the credit card data since it is not balanced. First, I start to split the data and perform oversampling with RandomOverSampler and SMOTE method, and I undersample with ClusterCentroids algorithm. Then, I utilize the SMOTEENN method to oversample and undersample the data. Finally, I used ensemble models.
SohrabRezaei/Election-Analysis
The purpose of this challenge was to complete an election analysis of a local congressional election Using Python
SohrabRezaei/Kickstarter-Analysis
Performing Analysis on our Kickstarter data to uncover trends
SohrabRezaei/Mapping-Earthquakes
The purpose of this project was to display the tectonic plates, earthquakes and earthquakes with a magnitude greater than 4.5 throughout the whole world by utilizing Leaflet. Also, it is possible to switch between three different overlays by simply clicking on the desired overlay.
SohrabRezaei/MechaCar-Statistical-Analysis
Metrics such as vehicle length, weight, spoiler angle, ground clearance, AWD capabilities, MPG, and PSI have been evaluated between different manufacturer lots and how these parameters could influence the production of a new prototype.
SohrabRezaei/Mission-To-Mars
HTML Web scraping on mars data to create a flask web application using Python, BeautifulSoup, Splinter, Bootstrap, and MongoDB
SohrabRezaei/Neural-Network-Charity-Analysis
This analysis aims to create a deep neural network to classify whether the donations that were given to this charity are being used appropriately. Afterward, we try to optimize the whole model by first increasing neurons, then adding a hidden layer, and finally increasing the epochs.
SohrabRezaei/Pyber-Analysis
The goal of this challenge is to create a new dataframe based on type of city for a ride sharing company and to create a chart to display the total fares of each city type weekly with resample.
SohrabRezaei/School-District-Analysis
The purpose of this project was to drop the ninth-grade results of Thomas High School and then try to figure out how such alternation has affected the previous analysis as a whole.
SohrabRezaei/Stock-Analysis
Refactoring the original code in order to run the VBA codes faster. Refactoring helps to remove excessive codes and repition while occupying less space to deliver a better result.
SohrabRezaei/Surfs-up
We are asked to assess the feasibility of opening up a surf shop by obtaining the temperature data for June and December. This is done by utilizing SQL ALCHEMY and creating a SQLite database engine.