Playing with Data by using of Python, Pandas
abhijeet mote (~abhijeet61) |
Description:
Installation of the Pandas, Ipython package using Pip - Quick guide for Anaconda, Spyder
Check the installed version of python and pandas Reading csv/txt/excel/json file using Pandas
- Understanding what is dataframe?
- Understanding what is series Using head, tail, describe
- Making hands dirty with data manupulation
- Create a Pandas DataFrame
- Create blank dataframes
- Data Filtering
- How To Select an Index or Column From a Pandas DataFrame
- using lambda expression,
- adding new columns to existing dataframe
- joins of dataframes
- Iterating the dataset
- Filter, Sort and Groupby
- Removing the blank values from dataframe
- Replace values in dataframe(data transformation)
- Playing with Time series data Writing the new dataframe into csv,excel,txt format
- plot the dataframe using matplotlib(discuss other alternatives)
Audience Level:Intermediate (Python programming experience is required)
Prerequisites:
Basic of python and keen to play with data
Content URLs:
https://github.com/abhijeetmote/playing_with_data_using_pandas https://slides.com/abhijeetmote/deck-1#/
Speaker Info:
I am Python Evangelist and enthusiastic about the open source technology. I am hosting the Python Penang Meetup group, and involving people to work on python programming stack and use it in a day to day life, also by sharing the knowledge acquired by me in this years. I give training to the students, teachers and enthusiastic developers without any cost, also mentor the students for their final year projects. I also contributed to Open source accounting software(GNU-Khata) and IITBombayX MOOCs platform.