Data Analysis Course - How to Extract the Data
Data Extraction from different formats like csv, excel, url, databases, etc using Python and R
Data Analysis,IT Certification
Lectures -11
Duration -6 hours
30-days Money-Back Guarantee
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
- 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
![Data Analysis Course - How to Extract the Data Data Analysis Course - How to Extract the Data](https://d3mxt5v3yxgcsr.cloudfront.net/courses/2637/course_2637_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Data Analysis - How to Extract the Data
10 Lectures
-
Introduction 01:38 01:38
-
Data Extraction from CSV File 42:02 42:02
-
Data Extraction from Excel File 50:40 50:40
-
Data Extraction from CLIPBOARD, URL, XML & JSON Files 50:04 50:04
-
Data Extraction from Databases - Part 1 52:31 52:31
-
Data Extraction from Databases - Part 2 52:39 52:39
-
Loading data into Python 40:33 40:33
-
Loading data from CSV, Excel & URL into Python 21:24 21:24
-
What is Data Science 30:42 30:42
-
What is Machine Learning 25:06 25:06
Instructor Details
![DATAhill Solutions Srinivas Reddy](https://www.tutorialspoint.com/assets/profiles/163817/profile/200_161404-1579756642.jpg)
DATAhill Solutions Srinivas Reddy
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual 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 Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)