Index
A
Anaconda
B
Bar plot
Box plot
C
Cleaning data
calculating and removing outliers
interquartile range (IQR)
standard deviations
description
filtering inappropriate values
finding duplicate rows
pandas dataframes, missing data
removing punctuation, column contents
removing whitespace, column contents
SSNs, phone numbers, and zip codes
standardizing dates
Combining data, multiple excel files
Computing aggregate statistics
create dataset
matching rows
measures, central tendency
sorting data
starting dataset
variance
Correlation
D, E, F, G
Data quality report
Datasets
bar plot
box plot
histograms
line plot
pie chart
scatter plot
unzipping
H
Histograms
I
Interquartile range (IQR)
J, K
Jupyter Notebook
L, M, N
Line plot
Loading data
CSV files
Excel files
SQL
O
Organizing data
change column name
description
filter rows
finding matching rows
random sampling dataframe
removing and adding columns
selecting columns
selecting rows
setting column names to lower case
P, Q
Pie chart
Pivot tables
average grade and hours, gender
averages of numeric columns
dataframe and index
load data
max grade, gender and age
minimum grade, gender
Practice problems
algebra data
Axis Auto Sales
DVD sales
SouthStyle Foods
Tami
R
Random numbers
Regression
Regression without Intercept
S, T, U
Saving data
CSV files
Excel files
SQL
Scatter plot
SouthStyle Foods
V, W, X, Y, Z
Variables
applying functions
bins
column
group
loading dataframe
columns
conditional
functions
converting string to numeric
data binning
ranking rows of data
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.