Topics

• Reshaping and pivoting
• Creating DataFrames
• Indexing and selecting data
• Pandas Datareader
• Merge, join, and concatenate
• Pandas IO tools (reading and saving data sets)
• Simple manipulation of DataFrames

Examples

• Basic saving to a csv file
• Spreadsheet to dict of DataFrames
• Read a specific sheet
• Adding a new column
• Save to CSV file
• Filtering columns (selecting "interesting", dropping unneeded, using RegEx, etc.)
• Reading financial data (for multiple tickers) into pandas panel - demo
• Merging / concatenating / joining multiple data frames (horizontally and vertically)
• Using HDFStore
• Filtering / selecting rows using `.query()` method
• Delete / drop rows from DataFrame
• Split (reshape) CSV strings in columns into multiple rows, having one element per row