Learn how to extract, manipulate and analyze data using Python
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 f 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
Wking 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 Wk 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 wk 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 sting 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 ganised data structure
Project: Ste data from a CSV file to RDBMS.
Problem statement: Take Yahoo finance data in the CSV fmat and ste the data into an RDBMS.
ĚProject: Dealing with Web Data
Problem statement: Dmoz is a website, which is an open directy f various websites regarding different categies. We can go to the spts 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 categy and stes the data in a CSV fmat on the file system.
Project: Data Analysis and Visualization
Problem statement: UIDAI (Unique Identification Authity of India) is an Indian authity responsible f creating biometric data-based identification cards f the Indian citizens. They provide data based on state, gender, and rejection and acceptance of the identification cards in the fm of a CSV file. We need to create a helpful visualisation to exple which state, age range, gender got how much percentage of cards rejected accepted.
Problem statement: Yahoo finance hosts financial data f 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
t lets you run any Python script library - right in your spreadsheet.
I recommends Buy premimum account for High speed+parallel downloads!