Python: Extract, Manipulate and Analyze Data with 5 Projects

Yoda Learning, Become 4X faster

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
74 Videos (6h 47m)
    • Know how Becoming Data Analyst can be a good career for you.

      3:31
    • 0101 Understanding the significance of programming in your personal and professional life

      5:55
    • 0201 Installing python on windowslinuxmac

      3:53
    • 0202 Playing with pip and installing packages

      5:30
    • 0203 Playing with the python shell

      11:57
    • 0204 Choosing the right IDECode editor

      10:50
    • 0205 Writing your first python code and running it under different environments

      8:05
    • 0301 Dealing with variables and string

      6:37
    • 0302 Numbers and different operators in python

      2:42
    • 0302b Numbers and different operators in python

      12:02
    • 0303 Introduction with important built in types in python

      5:48
    • 0303b Introduction with important built in types in python

      2:37
    • 0303c Introduction with important built in types in python

      4:33
    • 0401 Understanding logical operators and expressions

      11:13
    • 0402 Making decisions through if else clauses

      9:17
    • 0403 Repeating or looping the decisions multiple times and stopinng them

      7:38
    • 0404 Handling the errors and exceptions inn our decisions

      8:50
    • 0501 Creating your first function

      7:16
    • 0502 Understanding input parameters and return type in functions

      5:03
    • 0503 Nesting functions

      3:01
    • 0504 Calling functions from other function

      6:25
    • 0505 writing recursive functions

      6:54
    • 0601 Organizing your code into modules and packages

      9:55
    • 0701 Dealing with our first file and using write operation

      3:27
    • 0702 Reading from files and processing the text

      3:30
    • 0703 handling file errors

      3:27
    • 0704 Exploring the OS package to play with paths and directories

      7:47
    • 0801 What is data Science and what does data scientists do

      7:01
    • 0802 Why python for data analysis and other data related tasks

      4:42
    • 0901 Introdunction of RDBMS

      6:16
    • 0902 Introdunction to POSTGRESQL

      5:03
    • 0903 Installing postgresql on different platforms

      4:16
    • 0904 Playing with postgresql

      4:08
    • 0904b Playing with postgresql

      11:47
    • 0905 Dealing with postgresql using python

      8:22
    • 0906 Case study

      4:08
    • 1001 Introdunction with different data sources

      8:42
    • 1002 Understanding JSON

      1:28
    • 1003 Dealing with JSON using python

      5:46
    • 1004 Understanding CSV

      1:59
    • 1005 Dealing with CSV using python

      5:13
    • 1006 Understanding XML

      2:52
    • 1007 Dealing with XML using python

      6:05
    • 1008 Understanding EXCEL

      1:28
    • 1009 Dealing with EXCEL using python

      7:49
    • 1010 excel processing 1

      4:10
    • 1011 Excel Processing 2

      5:00
    • 1012 Case study

      2:54
    • 1101 Brief introdunction to Big Data

      4:38
    • 1102 What is NOSQL

      2:43
    • 1103 MONGODB The first inrtodunction

      3:29
    • 1104 Installing MONGODB on your platfrom

      4:57
    • 1105 Getting down with MONGODB

      6:45
    • 1106 Interacting with MONGODB with python using PYTMONGO

      5:20
    • 1201 Understanding the WEB world Why would need data from web

      4:51
    • 1202 What is Web Scraping

      7:21
    • 1203 The Introdunction to Requests and Beautiful Soup module

      9:18
    • 1203b The Introdunction to Requests and Beautiful Soup module

      3:47
    • 1204 Creating a simple web sraper using python

      5:30
    • 1205 Dealing with scraped data using NOSQL

      3:30
    • 1206 Case study

      3:12
    • 1207 Web Scraper Solution

      4:03
    • 1301 What is Data Analysis What are its applications

      6:30
    • 1302 Brief introdunction to NUMPY and PANDAS

      4:55
    • 1303 Playing with your Data Frame

      4:02
    • 1304 Visualizing and understanding your scraped data

      5:42
    • 1305 Data Visualization Example

      2:56
    • 1306 Case study

      4:39
    • 1401 What is EDA(Exploratory Data Analysis)

      4:15
    • 1402 Introdunction to Data Nitro

      3:15
    • 1403 Basics Operation of Data Nitro

      4:17
    • 1404 Charts in Data Nitro

      4:34
    • 1405 Data Nitro Example

      2:54
    • 1406 Case study

      2:40

About This Class

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 ----------------------------------------------------------------------------------------------------------------- If you have read this far, next action is JOINING this course. Invest 6 hrs. for a benefit of the lifetime.

32

Students

--

Projects

Yoda Learning

Become 4X faster

Hello, I'm Yoda

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, ...

See full profile