---
# System prepended metadata

title: Pandas Skill checks

---

---
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.