Playing with DATA using

Python & Pandas

• Abhijeet Mote,
• Software Development Engineer @ UST Global, Malaysia
• Open Source Evangelist
• Teaching Open source technologies
• Helping students in final year projects

Twitter   :   @abhijeet_mote

Github   :   abhijeetmote

email Id :   abhijeetmote@gmail.com

@whoami 

What is this workshop about?

Learning Pandas

How to Wrangling with Data

Data Technology

Data is new Gold

Make sense of this data

We will See how Extraction Transformation & Loading 

Prerequisite Softwares

• Python 3.X
• Pandas 
• Numpy
• Anaconda distribution(Recommended)

Downloads:

Python https://www.python.org/downloads/

Anaconda https://www.anaconda.com/distribution/

Installation using pip

​​

pip install <package name>

example:

Installation using Conda

​​

pip install <package name>

example:

• Easy to install
• Agile data exploration
• Powerful data analysis
• Simple to collaborate
• Accessible to everyone

 Introduction to

Pandas 

What is Pandas?

• Data import

• Filtering

• Aggregating

• Merging

• Data Export

• Histogram and Scatter Plots

Demo : 

Practical

Introduction to

Pandas

• Series

• DataFrames

Pandas data structures

What is series?

• one-dimensional labeled array

• capable of holding any type data of  

• similar to ndArray

Hands On

for

Series

What is DataFrame

• Potentially columns are of different types
• Size – Mutable
• Labeled axes (rows and columns)
• Can Perform Arithmetic operations on rows and columns

Hands on for DataFrames

References

http://pandas.pydata.org/pandas-docs/version/0.15/tutorials.html 

https://docs.anaconda.com/

https://www.python.org/doc/

Happy Learning Thanks :)

Twitter   :   @abhijeet_mote

Github   :   abhijeetmote

email Id :   abhijeetmote@gmail.com