Learn Data Analysis with Python

Table of Contents1. IntroductionHow to use this bookInstalling iPython NotebookWhat is iPython notebook?What is Anaconda?Getting StartedGetting the datasets for the workbook's exercises2. Getting Data into and out of PythonLoading Data from CSV FilesSaving Data to CSVLoading Data from Excel FilesSaving Data to Excel FilesCombining Data from Multiple Excel Files:Loading Data from SQLSaving Data to SQLRandom Numbers and Creating Random Data3. Preparing Data is Half the BattleCleaning DataCalculating and Removing OutliersMissing Data in Pandas DataframesFiltering Inappropriate ValuesFinding Duplicate RowsRemoving Punctuation from Column ContentsRemoving Whitespace from Column ContentsStandardizing DatesStandardizing Text like SSN's, Phone #'s and Zip CodesCreating New VariablesBinning DataApplying Function to Groups, Bins and ColumnsRanking Rows of DataCreate a Column Based on a ConditionalMaking New Columns Using FunctionsConverting String Categories to Numeric VariablesOrganizing the DataRemoving and Adding ColumnsSelecting ColumnsChange Column NameSetting Column Names to Lower CaseFinding Matching RowsFilter Rows Based on Conditions:Selecting Rows Based on ConditionsRandom Sampling Dataframe4. Finding the MeaningComputing aggregate statisticsComputing Aggregate Statistics on Matching RowsSorting DataCorrelationRegressionRegression without InterceptBasic Pivot TableRandom Sampling DataframeSelecting Pandas DataFrame Rows Based on ConditionsDistribution AnalysisCategorical Variable AnalysisTime Series Analysis5. Visualizing DataData Quality ReportGraph a Dataset - Line PlotGraph a Dataset - Bar PlotGraph a Dataset - Box PlotGraph a Dataset - HistogramGraph a Dataset - Pie ChartGraph a Dataset - Scatter PlotPlotting w/ ImagePlotting Data on a Map with BasemapPlotting a Gantt ChartSetting ticks, labels & gridsAdding legends & annotationsMoving Spines to the Center6. Practice ProblemsPivot Exercise 1Pivot Exercise 2Pivot Exercise 2Pivot Exercise 3LegendRegression Exercise 1Regression Exercise 2Regression Exercise 3Analysis ProjectNotes