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


    113 KB


    605 KB


    212 KB


    797 bytes


    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 :

    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 :


    See More

    With regards CourseDown.Com

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

    Links Download

    Share on facebook
    Share on twitter
    Share on whatsapp
    Share on pinterest
    Scroll to Top