Add a header to begin generating the table of contents

    Write SQL in R and Python Best of 3 world

    Write SQL in R and Python Best of 3 world

    Start using SQL queries in R and Python

    Integrate R and Python with Database and execute SQL command on them for data analysis and Visualizations.

    Start using filter , having clause , joins with multiple tables ,aggregators etc.

    Create DDL commands and modify the schema objects.

    Write SQL in R and Python Best of 3 world

    Project Description

    Task 1 .

    1.Upload the market fact data csv file into Python console using Jupyter lab.

    2.Do the data analysis using SQL queries to find out the following:

    2.1) Find the sales data for each sub-category

    2.2) Find which customer segment is most profitable

    2.3) Do the data visualiazations for Sales data ( plot box plot for each prod category )

    2.4) Do the visualiazations for Profit Data vs Sales ( plot scatter plot )

    2.5) Post you conclusions in the community.

    Task 2.

    1.Connect Python with MySQL database

    2.Fetch the data of employee and department in python

    3.Write SQL queries to join employee and department and find the no. of employees by each department

    4. Create a table in python console and post in MySQL database

    5. Insert a record in the table created in step 4.

    Task 3 :

    Repeat the task 1 in R programming.

    Task 4 :

    Repeat the task2 in R programming

    Post conclusion of data analysis and visualizations from Task1 and Task3 in the community

    Resources(5)
    cust_dimen.csv

    113 KB

    market_fact.csv

    605 KB

    orders_dimen.csv

    212 KB

    prod_dimen.csv

    797 bytes

    shipping_dimen.csv

    332 KB

    Course information :

    MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
    Genre: eLearning | Language: English | Duration: 11 Lessons (1h 2m) | Size: 412.9 MB

    Course Link :

    https://www.skillshare.com/classes/Write-SQL-in-R-and-Python-Best-of-3-world/

    Key words :

    Course Write SQL in R and Python Best of 3 world.

    Download Write SQL in R and Python Best of 3 world.

    Likk Download :

    File-Up
    UpToBox
    NitroFlare
    Rapidgator

    See More

    With regards CourseDown.Com

    Sorry, we couldn't find any posts. Please try a different search.

    Links Download

    Share on facebook
    Facebook
    Share on twitter
    Twitter
    Share on whatsapp
    WhatsApp
    Share on pinterest
    Pinterest
    Scroll to Top