--- breaks: false --- ## Pandas Skill checks ### Series - [x] Create a `pd.Series` using a python list - [x] Create a `pd.Series` with a custom index - [x] Update the data within a `pd.Series` - [x] Update the `pd.Series.index` - [x] Create a time-indexed Series - [x] Shift the time of a Series by a certain period. - [x] Slicing into a series. - [x] Know how to use `Series.loc` and `Series.iloc` - [ ] Plotting a Series (using Matplotlib) ### Dataframes - [ ] Create a `pd.DataFrame` using a dictionary - [ ] Create a `pd.Series` corresponding to a column from a `DataFrame` - [ ] Create a Change the column names of the `DataFrame` - [ ] Interchange the columns on a DataFrame - [ ] Create a `pd.DataFrame` with a particular set of indices - [ ] Sort the DataFrame by some ordering on its indices - [ ] Extract a subset of columns of a DataFrame into another DataFrame - [ ] Elementwise operations on a dataframe - [ ] Elementwise operation on a subset of columns - [ ] Get sum of a column of a dataframe - [ ] Get mean of a column of a dataframe - [ ] Extract a subset of rows of a DataFrame - [ ] Demonstrate familiarity with `DataFrame.loc`, `DataFrame.iloc` - [ ] Concatenate columns of two dataframes - [ ] Get a boolean mask corresponding to index of a DataFrame - [ ] Use a boolean mask on the index of a DataFrame to extract a subset of rows (Hint `DataFrame.where`) - [ ] Plotting a DataFrame using Matplotlib. ### Xarray - [ ] Understand what a `xr.DataArray` is and what a `xrDataSet` is. - [ ] Contrast `xr.DataArray` with a numpy array. - [ ] Create a `xr.DataArray` from coordinates and data values being Numpy arrays. - [ ] Crete a `xr.DataSet` from `xr.DataArray`'s - [ ] Get coordinates of a data array - [ ] Selecting elements in a `xr.DataArray` or `xr.DataSet` by coordinate values (See `.sel`.) - [ ] Selecting elements in a `xr.DataArray` or `xr.DataSet` by coordinate indices (See `.isel`.) - [ ] Slicing elements in a `xr.DataArray` or `xr.DataSet` - [ ] Getting mean for a particular subset of a dataarray - [ ] Getting the coordinates of a dataarray for which the entries satisfy a particular condition. - [ ] Getting mean, sum. - [ ] Plotting a `xarray.DataArray`. - Advanced concepts for later quiz: - [ ] resample, groupby, rolling, etc.