Python: Extract, Manipulate and Analyze Data with 5 Projects (Udemy.com)
Learn how to extract, manipulate and analyze data using Python
Created by: Yoda Learning
Produced in 2016
What you will 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
Quality Score
Overall Score : 0 / 100
Course Description
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]
______________________________________________________________________
- 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
- A 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 this course is for:
- 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
Instructor Details
- 0.0 Rating
0 Reviews
Yoda Learning
20,000 Classroom Students | 100,000+ Students Online
ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12k+ participants across PwC, EY and Deloitte over last 10 years
I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)
After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2021. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.
If I'm going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed I can't reach my goal without helping you reach yours! 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 20,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) -
More courses by Yoda Learning
Microsoft Advanced Excel Dashboard : Zero To Hero (Complete) (2017)
4.2 (80 Reviews)
Provider: Udemy
Time: 4h
$11.99
Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)
Provider: Udemy
Time: 21h
$11.99
More postgresql courses
SQL and PostgreSQL: The Complete Developer's Guide (2021)
4.8 (60 Reviews)
Provider: Udemy
Time: 22h
$11.99
Practical SQL Bootcamp for Data Analysts and Data Scientists (2021)
4.8 (50 Reviews)
Provider: Udemy
Time: 3.5h
$11.99
Python 3 Complete Masterclass - Make Your Job Tasks Easier! (2021)
4.7 (414 Reviews)
Provider: Udemy
Time: 15.5h
$11.99











