Data Wrangling using Pandas

GlobalMart is a fledgling startup in the burgeoning E-Commerce space with a presence in the North America region.

It has a presence across 120 markets and primarily deals with 3 lines of businesses :

• Technology
• Office Supplies
• Furniture

Being in the early stages of their business, GlobalMart has touched more than 1000 customers placing 5000+ orders till date. The company maintains its business transactions in plain Excel as of now. It also relies on Excel for all data analysis, reporting and visualization requirements.

However, off late, the Data Analysts at the company are facing a number of challenges :

• Lot of manual and repetitive tasks have made working in Excel very difficult
• Frequent duplicate records, missing values, incorrect data types issues in Excel
• Lots of functions being maintained across sheets. Any change in any function can have cascading impact leading to opening of a pandora’s box of problems
• VBA has become an old school way of automating repetitive data analysis tasks. Need something modern and easy way for performing data analysis
• Visualization options in Excel are good to start. However, the options are limited when it comes to statistical analysis. Also, presenting visuals in a neat dashboard is always a challenge

You have joined GlobalMart as a Data Analyst. Your job is to help the data team collect, clean, analyze and visualize business data to provide actionable insights to business teams.

Your Data Team Head has suggested everyone to learn an easy to learn and apply tool for Data Analysis which also happens to be a general purpose programming language : Python

In this learning journey, you’ll learn essential skills in Python which will help you perform quick, fast and easy data analysis and visualization and hence improve your productivity at work manifold