Notes in Python - Pandas

To Subscribe, use this Key

Status	Last Update	Fields
Published	05/03/2024	load data
Published	05/03/2024	look at data
Published	05/03/2024	print summary statistics about data
Published	05/03/2024	plot histrogram about data
Published	05/03/2024	histrogram by group
Published	05/03/2024	Select only variable = 'A' data# Create mock time series dataimport numpy as npfrom pandas import DataFrameimport pandas.util.testing as tm; tm.N = 3d…
Published	05/03/2024	Create pivot table by variable# Create mock times series dataimport numpy as npfrom pandas import DataFrameimport pandas.util.testing as tm; tm.N = 3d…
Published	05/03/2024	Create a pivot table by variable for means of each day# Create mock times series dataimport numpy as npfrom pandas import DataFrameimport pandas.util.…
Published	05/03/2024	drop a column from dataframe
Published	05/03/2024	get common info about dataframe
Published	05/03/2024	Get mean for each yearimport numpy as npimport pandas as pdimport pylab as pl df = pd.read_csv("http://bit.ly/144sh7t")df.head()
Published	05/03/2024	select rows/columns based on MultiIndex level values i
Published	05/03/2024	.ix is especially useful when dealing with _____
Published	05/03/2024	What is .loc used for?
Published	05/03/2024	What is panels?
Published	05/03/2024	What is vbench?
Published	05/03/2024	series
Published	05/03/2024	select by values in another columnsemployers = df_grouped.index[0:2]
Published	05/03/2024	Get length of series
Published	05/03/2024	create multiple aggretion groupby columns
Published	05/03/2024	If each dict represents a row, you could pass a ______________ to pd.DataFrame
Published	05/03/2024	Convert column names to lowercase
Published	05/03/2024	Rename some columns
Published	05/03/2024	Changing values in a Column
Published	05/03/2024	Applying Functions to Multiple Columns
Published	05/03/2024	Counting Rows with NaNs
Published	05/03/2024	Select non-NaN Rows
Status	Last Update	Fields