Project 1

Here I have done my Project_01 for SQL For Data Science .In this Project working with MYSQL RDBMS for easy approach to work,with in this project i am doing this based on the below information

Business model Customer to Customer (C2C) allows customers to do business with each other. This model is growing fast with e-commerce platforms where sellers may be required to pay some amount and buyer can buy it without paying anything. E-Commerce website brings the seller and buyer to the same platform.

Analyzing the user's database will lead to understanding the business perspective. Behaviour of the users can be traced in terms of business with exploration of the user’s database.

Dataset: One .csv file with name users_data with 98913 rows and 27 columns

I am performing the analyzing and investigating with this user_data with some Filtrations,Data sortings,combining the data by GROUP BY ,ORDER BY functions ,comparision operators,aggregation functions and Union operators.

1. Create new schema as ecommerce

2.Import .csv file users_data into MySQL
(right click on ecommerce schema -> Table Data import Wizard -> Give path of the file -> Next -> choose options : Create a new table , select delete if exist -> next -> next)

3.structure of database