Python: Extract, Manipulate and Analyze Data with 5 Projects
3.3 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,173 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Python: Extract, Manipulate and Analyze Data with 5 Projects to your Wishlist.

Add to Wishlist

Python: Extract, Manipulate and Analyze Data with 5 Projects

Learn how to extract, manipulate and analyze data using Python
3.3 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,173 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Installation of Python Program and Do basic coding in Python, which will enable you to use python shells for data analysis
  • You will be able analyse Big Data and Visualize them to become an entry-level data analyst
View Curriculum
Requirements
  • Python can as well be your first programming language to learn, so nothing in particular
  • Being an economist or a management consultant, a person may not be very familiar with computer programming. This course would teach you the basics of such programming that you can build on later and become much more employable than you are currently.
  • Irrespective of what educational background you might be from or what profession you might be pursuing at the moment, you can learn data analysis.
Description

Does your profession require you to deal with large data on a regular basis?  

Do you wish you could be better at dealing with those numbers

This course brings about a solution for you by teaching you how to manipulate and analyse the data in the most basic language, Python.

This course doesn’t only seek to teach you about data analysis but also helps you learn how to apply it in real-life situations. Apart from detailed programs on learning the basics of Python and the art of data analysis using Python, the course provides you with five projects that are real-life case studies.

Starting with the basics of Python, learn how to analyse big data, visualise them, and become an entry-level data analyst.
______________________________________________________________________

Here is an outline of what we'll cover through the entire course:

  • Preparing your environment and software installation
  • Logical and looping constructs
  • Dealing with functions
  • Modules and packages
  • Dealing with file I/O in Python
  • Working on different data types such as CSV, JSON, RDBMS, and Excel
  • Dealing with non-relational database management systems
  • Dealing with web-related data
  • Data analysis and visualisation using DataNitro

______________________________________________________________________

Real-Life Project Work was done with Python:

Once we've got a grip of Python and data analysis, it'd be great if we could get some hands-on experience by trying out what we've learned, right? So here are some projects that we'll work on:

  • Project: Data management system using RDBMS 
    Problem statement: A company XYZ sales deals in solar products and they sell their products all across a country to their customers. So far they have been storing their data in an Excel file. But since their growth has exceeded and in sync with the sales, they need a concrete data management system with an organised data structure
  • Project: Store data from a CSV file to RDBMS. 
    Problem statement: Take Yahoo finance data in the CSV format and store the data into an RDBMS.
  • ·Project: Dealing with Web Data  
    Problem statement: Dmoz  is a website, which is an open directory for various websites regarding different categories. We can go to the sports section and get related websites. However, websites keep getting added. So, we need to create a web scraper that automatically fetches all the links in the particular category and stores the data in a CSV format on the file system.
  • Project: Data Analysis and Visualization
    Problem statement: UIDAI (Unique Identification Authority of India) is an Indian authority responsible for creating biometric data-based identification cards for the Indian citizens. They provide data based on state, gender, and rejection and acceptance of the identification cards in the form of a CSV file. We need to create a helpful visualisation to explore which state, age range, or gender got how much percentage of cards rejected or accepted.
  • Project: DataNitro 
    Problem statement: Yahoo finance hosts financial data for different companies. We need to implement a solution that can get finance data of different companies and make charts based on the fetched data. We also take you through DataNitro
    [It lets you run any Python script or library - right in your spreadsheet]. I'm in love with this tool :) [Disclosure - I'm not their affiliate and make no money from their sales]
    ______________________________________________________________________

Important information before you join:

  • Once enrolled, you have unlimited, lifetime access to the course!
  • You will have instant and free access to any updates I'll add to the course.
  • I will give you my full support regarding any issues or suggestions related to the course.
  • Guided practice - over worksheets included for immediate practice
  • Access to all videos 24 x 7 - learn online from anywhere
  • 30-day money back guarantee (we want you to be 100% satisfied) 

-----------------------------------------------------------------------------------------------------------------

If you have read this far, next action is JOINING this course. Invest 6 hrs. for a benefit of the lifetime.

Who is the target audience?
  • Software professionals, ETL developers, and Project Managers
  • Advanced Excel users who want exposure to Big Data
  • Fresh IT/Engineering graduates who are willing to add resourceful knowledge for their better career prospects
Students Who Viewed This Course Also Viewed
Curriculum For This Course
73 Lectures
06:31:39
+
Introduction to Course
1 Lecture 05:55

If you like the course, PLEASE leave a review so other new students can hear about it.

If you are NOT at the 5 star level of happiness with our course, MESSAGE me with any feedback or questions!

I am HAPPY to help you better understand a topic and get you to that 5 STAR HAPPY LEVEL with this course!

Thanks again for joining YodaLearning!

Preview 05:55
+
Preparing your environment
5 Lectures 40:15


Playing with the python shell
11:57

Choosing the right IDECode editor
10:50

Writing your first python code and running it under different environments
08:05
+
Beginning with Basics
6 Lectures 34:19
Dealing with variables and string
06:37

Numbers and different operators in python- Part A
02:42

Numbers and different operators in python- Part B
12:02

Introduction with important built-in types in python - Part A
05:48

Introduction with important built-in types in python - Part B
02:37

Introduction with important built-in types in python - Part C
04:33
+
Logical and looping constructs
4 Lectures 36:58
Understanding logical operators and expressions
11:13

Making decisions through if-else clauses
09:17

Repeating or looping the decisions multiple times and stopinng them
07:38

Handling the errors and exceptions inn our decisions
08:50
+
Dealing with functions
5 Lectures 28:39
Creating your first function
07:16

Understanding input parameters and return type in functions
05:03

Nesting functions
03:01

Calling functions from other function
06:25

Writing recursive functions
06:54
+
Modules & Packages
1 Lecture 09:55
Organizing your code into modules and packages
09:55
+
Dealing with file I/O in Python
4 Lectures 18:11
Dealing with our first file and using write operation
03:27

Reading from files and processing the text
03:30

Handling file errors
03:27

Exploring the OS package to play with paths and directories
07:47
+
Understanding RDBMS
6 Lectures 32:13
Introdunction of RDBMS
06:16

Introduction to POSTGRESQL
05:03

Installing postgresql on different platforms
04:16

Playing with postgresql
04:08

Dealing with postgresql using python
08:22

Case Study
04:08
+
What are the other data sources out there?
12 Lectures 53:26
Introdunction with different data sources
08:42

Understanding JSON
01:28

Dealing with JSON using python
05:46

Understanding CSV
01:59

Dealing with CSV using Python
05:13

Understanding XML
02:52

Dealing with XML using Python
06:05

Understanding EXCEL
01:28

Dealing with EXCEL using python
07:49

Excel Processing - Part 1
04:10

Excel Processing - Part 2
05:00

Case Study
02:54
5 More Sections
About the Instructor
Yoda Learning
4.3 Average rating
1,466 Reviews
35,403 Students
49 Courses
MS OFFICE & PMP | Join 32K+ Udemy Students Become 4X Faster

Yoda Learning is a team of 12+ industry professionals focused on developing “Project-based" learning solutions, which enable the learners explore real world situations and thus, make the learning process engaging and practical. Our Courses on Technology includes everything including Web Development, Mobile App Development, Data Analytics and Design.

The collective work-experience of 80+ yrs. spans across multiple industries like Manufacturing, IT, Sales, Finance, Marketing, Operations, HR and functional domains such as Office suites, Mobile applications, Digital Marketing, Database Technologies, Networking).

Rishabh Pugalia
4.2 Average rating
530 Reviews
9,302 Students
29 Courses
Excel & P.Point Ninja | Taught 12,000+ professionals (LIVE)

Rishabh Pugalia is a Chartered Accountant from India. He has worked with KPMG and J.P. Morgan before venturing into Corporate Training. He founded ExcelNext in December 2009 and has since trained 12,000+ professionals across various multi-national companies and professionals' forums.

He has delivered training programs on "Advanced Excel" in top Corporate houses. He has co-authored a Technical Guide issued by the Institute of Chartered Accountants of India (ICAI) - "Using Excel for Continuous Controls Monitoring" .

He is a visiting faculty at various premier B-Schools and has shared his knowledge on numerous Professionals' public forums.