Tutorialspoint

Data Analysis - How to Extract the Data

Data Extraction from different formats like csv, excel, url, databases, etc using Python and R

Course Description

Data Analysis with Pandas and Python introduces you to the popular Pandas library built on top of the Python programming language.

Pandas is a powerhouse tool that allows you to do anything and everything with colossal data sets -- analyzing, organizing, sorting, filtering, pivoting, aggregating, munging, cleaning, calculating, and more!

I call it "Excel on steroids"!

Over the course of more than 19 hours, I'll take you step-by-step through Pandas, from installation to visualization! We'll cover hundreds of different methods, attributes, features, and functionalities packed away inside this awesome library. We'll dive into tons of different datasets, short and long, broken and pristine, to demonstrate the incredible versatility and efficiency of this package.

Data Analysis with Pandas and Python is bundled with dozens of datasets for you to use. Dive right in and follow along with my lessons to see how easy it is to get started with pandas!

Whether you're a new data analyst or have spent years (*cough* too long *cough*) in Excel, Data Analysis with pandas and Python offers you an incredible introduction to one of the most powerful data toolkits available today!

1. Data Extraction from CSV File

2. Data Extraction from Excel File

3. Data Extraction from CLIPBOARD, URL, XML & JSON Files

4. Data Extraction from Databases - Part 1

5. Data Extraction from Databases - Part 2

6. Loading data into Python

7. Loading data from CSV, Excel & URL into Python

8. What is Data Science

9. What is Machine Learning

Who this course is for:

  • Data analysts and business analysts
  • Excel users looking to learn a more powerful software for data analysis

Goals

  • Data Extraction from CSV File
  • Data Extraction from Excel File
  • Data Extraction from CLIPBOARD, URL, XML & JSON Files
  • Data Extraction from Databases
  • Loading data into Python
  • Loading data from CSV, Excel & URL into Python
  • Data Analysis on the loaded data

Prerequisites

  • Basic experience with the Python and R programming language
Show More

Curriculum

  • Introduction
    01:38
    Preview
  • Data Extraction from CSV File
    42:02
    Preview
  • Data Extraction from Excel File
    50:40
  • Data Extraction from CLIPBOARD, URL, XML & JSON Files
    50:04
  • Data Extraction from Databases - Part 1
    52:31
  • Data Extraction from Databases - Part 2
    52:39
  • Loading data into Python
    40:33
  • Loading data from CSV, Excel & URL into Python
    21:24
  • What is Data Science
    30:42
  • What is Machine Learning
    25:06
Feedbacks
  • No Feedbacks Posted Yet..!
Data Analysis - How to Extract the Data
This Course Includes
  • 6 hours
  • 11 Lectures
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

sample certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate

Talk to us

1800-202-0515