Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Data Analysis Course - How to Extract the Data

person icon DATAhill Solutions Srinivas Reddy

4.4

Data Analysis Course - How to Extract the Data

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

updated on icon Updated on Apr, 2024

language icon Language - English

person icon DATAhill Solutions Srinivas Reddy

English [CC]

category icon Data Analysis,IT Certification

Lectures -11

Duration -6 hours

4.4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

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

What will you learn in this course:

  • 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

What are the prerequisites for this course?

  • Basic experience with the Python and R programming language
Data Analysis Course - How to Extract the Data

Curriculum

Check out the detailed breakdown of what’s inside the course

Data Analysis - How to Extract the Data
10 Lectures
  • play icon Introduction 01:38 01:38
  • play icon Data Extraction from CSV File 42:02 42:02
  • play icon Data Extraction from Excel File 50:40 50:40
  • play icon Data Extraction from CLIPBOARD, URL, XML & JSON Files 50:04 50:04
  • play icon Data Extraction from Databases - Part 1 52:31 52:31
  • play icon Data Extraction from Databases - Part 2 52:39 52:39
  • play icon Loading data into Python 40:33 40:33
  • play icon Loading data from CSV, Excel & URL into Python 21:24 21:24
  • play icon What is Data Science 30:42 30:42
  • play icon What is Machine Learning 25:06 25:06

Instructor Details

DATAhill Solutions Srinivas Reddy

DATAhill Solutions Srinivas Reddy

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515