Project 1

his project is focused on analyzing and understanding user behavior in an e-commerce platform. The goal is to gain insights into the user's database and develop a better understanding of user behavior and business perspective. The target audience for this project includes data analysts, data scientists, and business analysts.

To achieve these goals, the following tasks will be completed:
1. Create a new schema in MySQL called ecommerce.
2. Import the users_data .csv file into the ecommerce schema.
3. Run SQL commands to see the structure of the table and select the first 100 rows of the database.
4. Determine the number of distinct values that exist in the table for the country and language fields.
5. Check whether male users or female users have the maximum number of followers.
6. Calculate the total number of users who use a profile picture, use the application for e-commerce, use the Android app, or use the iOS app.
7. Calculate the total number of buyers for each country and sort the results in descending order of total number of buyers.
8. Calculate the total number of sellers for each country and sort the results in ascending order of total number of sellers.
9. Display the name of the top 10 countries with the maximum products pass rate.
10. Calculate the number of users on the e-commerce platform for different language choices.
11. Check the choice of female users about putting the product in a wishlist or to like socially on an e-commerce platform using UNION.
12. Check the choice of male users about being a seller or buyer using UNION.
13. Determine which country has the maximum number of buyers.
14. List the top 10 products with the highest rating.

These tasks will provide valuable insights into user behavior and help inform business decisions related to the e-commerce platform.