Data Science using Pandas (from basics)

The following topics are covered:

• What is Data Science

• How to get (real) stock data , how to plot data in Jupyter

• SQL and MySQL interaction using Pandas

• read csv file and do various operations. Stocks data is considered as example

• write csv file and associated operations

• Handling missing data,

• Data filtering / Wrangling using Pandas

• Group by support in Pandas

• Concat support in Pandas

• Merge of Dataframes

• Pivot Table support in Pandas

• Stack / Unstack support in Pandas

• Reshape with Pandas

• Cross Tab with Pandas

• excel support

• Time series Support for calendar ( Business Days, Holidays)

• Time series Support for resampling, indexing time series data

  
  

  Hands-on / Practical with various datasets like: stock /share data, weather data etc