2020-04-21 12:42:19 -04:00
---
id: 5e9a093a74c4063ca6f7c15c
title: Pandas Creating Columns
challengeType: 11
videoId: _sSo2XZoB3E
2021-10-01 12:24:12 +08:00
bilibiliIds:
aid: 975568901
bvid: BV1b44y1b7Cg
cid: 409018052
2021-01-13 03:31:00 +01:00
dashedName: pandas-creating-columns
2020-04-21 12:42:19 -04:00
---
2020-11-27 19:02:05 +01:00
# --description--
2020-08-04 20:56:41 +01:00
2020-11-27 19:02:05 +01:00
*Instead of using notebooks.ai like it shows in the video, you can use Google Colab instead.*
2020-09-03 12:48:42 -04:00
2020-07-17 05:12:45 -04:00
More resources:
2020-09-03 12:48:42 -04:00
2020-11-27 19:02:05 +01:00
- [Notebooks on GitHub ](https://github.com/ine-rmotr-curriculum/freecodecamp-intro-to-pandas )
- [How to open Notebooks from GitHub using Google Colab. ](https://colab.research.google.com/github/googlecolab/colabtools/blob/master/notebooks/colab-github-demo.ipynb )
# --question--
## --text--
What code would add a "Certificates per month" column to the `certificates_earned` DataFrame like the one below?
2021-01-21 19:12:42 +01:00
< pre > Certificates Time (in months) Certificates per month
2020-11-27 19:02:05 +01:00
Tom 8 16 0.50
Kris 2 5 0.40
Ahmad 5 9 0.56
2021-01-21 19:12:42 +01:00
Beau 6 12 0.50< / pre >
2020-11-27 19:02:05 +01:00
## --answers--
```py
certificates_earned['Certificates'] /
certificates_earned['Time (in months)']
```
---
```py
certificates_earned['Certificates per month'] = round(
certificates_earned['Certificates'] /
certificates_earned['Time (in months)']
)
```
---
```py
certificates_earned['Certificates per month'] = round(
certificates_earned['Certificates'] /
certificates_earned['Time (in months)'], 2
)
```
## --video-solution--
3
