{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Python for SAS Users" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Chapter orginization\n", "\n", "These chapters are meant to be read in order as they start with foundational concepts used to build up more complex ideas. \n", "\n", "Chapter 00 -- Motivation \n", "\n", "Chapter 01 -- Introduction \n", "\n", "Chapter 02 -- Data Sctructures \n", "\n", "       list \n", "\n", "       indexing \n", "\n", "       tuple \n", "\n", "       dictionary \n", "\n", "       sequences \n", "\n", "       set \n", "\n", "       Resources\n", " \n", "Chapter 03 -- Data Types and Formatting \n", "\n", "       Numerics \n", "\n", "       Boolean \n", "\n", "       Numerical Precision\n", "\n", "       Strings \n", "\n", "       String Slicing \n", "\n", "       String Formatting \n", "\n", "       Resources \n", "\n", "\n", "Chapter 04 -- Pandas, Part 1 \n", "\n", "       Importing Packages\n", "\n", "       Series \n", "\n", "       DataFrames \n", "\n", "       Read .csv files \n", "\n", "       Inspection \n", "\n", "       Missing Values Identification\n", "\n", "       Missing Value Replacement \n", "\n", "       Resources \n", " \n", "\n", "Chapter 05 -- Understanding Indexes\n", " \n", "       Indices \n", "\n", "       .iloc indexer \n", "\n", "       Setting and resetting Indicies\n", "\n", "       .loc indexer \n", "\n", "        Mixing .loc indexer with Boolean Operations \n", "\n", "        Altering DataFrame values using the .loc indexer \n", "\n", "       Conditionaly Apply Values Based on Another Column Value \n", "\n", "        .ix indexer \n", "\n", "        Indexing Issues \n", "\n", "        Resources \n", " \n", "\n", "Chapter 06 Hierarchical Indexing \n", "\n", "       Multi Indexed Selection\n", "\n", "       xs() method for Cross-sections\n", "\n", "       Advanced Indexing with .loc Indexer\n", "\n", "       Using Boolean Operators with .loc Indexer\n", "\n", "       stack() and unstack() methods\n", "\n", "       Resources\n", "\n", "\n", "Chapter 07 -- Pandas, Part 2\n", "\n", "       SAS Sort/Merge with by-groups\n", "\n", "       Inner Join\n", "\n", "       Right Outer Join\n", "\n", "       Left Outer Join\n", "\n", "       Full Outer Join\n", "\n", "       Outer Join no Matched Keys\n", "\n", "       Outer Join no Matched Keys in Right\n", "\n", "       No Matched Keys in Left\n", "\n", "       Many-to-Many Join\n", "\n", "\n", "       GroupBy: Split-Apply-Combine Introduction\n", "\n", "       Replace Missing Values with Group Mean\n", "\n", "       FIRST.variable and LAST.variable Processing\n", "\n", "        Resources\n", "\n", "Chapter 08 -- Date, Time and Timepart Objects\n", "\n", "       String Literal Mapped to datetime timestamp\n", "\n", "       date objects\n", "\n", "       strfime() and strptime() methods\n", "\n", "       dateutil.parser\n", "\n", "       time objects\n", "\n", "       timedelta objects\n", "\n", "       Resources\n", "\n", "Chapter 09 -- Panda Time Series and Date Handling\n", "\n", "       Creating and Manipulating a Fixed Frequency of Dates and Time Spans\n", "\n", "       Time-Series Walk-through\n", "\n", "       Returning Unique Levels of Categories\n", "\n", "       Return a Row Using a Minimum Value\n", "\n", "\n", "       Return a Row Using a Maximum Value\n", "\n", "       Convert Time-Series from one Frequency to Another \n", "\n", "       Plotting with bokeh\n", "\n", "       Resources\n", "\n", "Chapter 10 -- GroupBy\n", "\n", "       Setting Display Options\n", " \n", "       Read 'pickled' DataFrame\n", "\n", "       Create GroupBy Object\n", "\n", "       GroupBy with Aggregations\n", "\n", "       Understanding Binning\n", "\n", "       Applying Functions to Groups\n", "\n", "       Applying Transformations to Groups\n", "\n", "        Top/Bottom N Processing\n", "\n", "       Resources\n", "\n", " Chapter 11 -- Panda Readers \n", "\n", "       pd.read_csv(URL) method\n", "\n", "       SQLAlchemy Under the Covers\n", "\n", "       read_sql_table() method\n", "\n", "       read_sql_query()method\n", "\n", "       DataFrame.to_sql() method\n", "\n", "       pd.read_sas() method\n", "\n", "       Resources\n", "\n", "Chapter 12 -- Additional Data Handling\n", "\n", "       Sort and Sort Sequences\n", "\n", "       Drop/Keep Columns\n", "\n", "       Rename Columns\n", "\n", "       Find Duplicate Values\n", "\n", "       Drop Duplicate Rows\n", "\n", "       Extract Duplicate Values\n", "\n", "       Add a New DataFrame Column\n", "\n", "       Cast Strings to Float\n", "\n", "       Concatenating DataFrames (Join)\n", "\n", "       Crosstabs\n", "\n", "       Sampling\n", "\n", "       Binning Continous Values\n", "\n", "       Save to Disk ('pickling')\n", "\n", "       Resources\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Navigation\n", "\n", " Return to Chapter List " ] } ], "metadata": { "anaconda-cloud": {}, "kernelspec": { "display_name": "Python [Root]", "language": "python", "name": "Python [Root]" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.5.2" } }, "nbformat": 4, "nbformat_minor": 0 }