2021-06-15 00:49:18 -07:00
---
id: 5e9a093a74c4063ca6f7c15c
2021-07-26 23:39:21 +09:00
title: Criar colunas com o Pandas
2021-06-15 00:49:18 -07:00
challengeType: 11
videoId: _sSo2XZoB3E
2021-10-03 12:24:27 -07:00
bilibiliIds:
aid: 975568901
bvid: BV1b44y1b7Cg
cid: 409018052
2021-06-15 00:49:18 -07:00
dashedName: pandas-creating-columns
---
# --description--
2021-07-26 23:39:21 +09:00
*Ao invés de usar notebooks.ai como foi mostrado no vídeo, você pode usar o Google Colab como substituto.*
2021-06-15 00:49:18 -07:00
2021-07-26 23:39:21 +09:00
Mais recursos:
2021-06-15 00:49:18 -07:00
2021-07-26 23:39:21 +09:00
- [Notebooks no GitHub ](https://github.com/ine-rmotr-curriculum/freecodecamp-intro-to-pandas )
- [Como abrir notebooks do GitHub usando o Google Colab. ](https://colab.research.google.com/github/googlecolab/colabtools/blob/master/notebooks/colab-github-demo.ipynb )
2021-06-15 00:49:18 -07:00
# --question--
## --text--
2021-07-26 23:39:21 +09:00
Qual código adicionaria uma coluna "Certificates per month" ao DataFrame `certificates_earned` como este abaixo?
2021-06-15 00:49:18 -07:00
2021-07-26 23:39:21 +09:00
< pre > Certificates Time (in months) Longest streak
Tom 8 16 13
Kris 2 5 11
Ahmad 5 9 9
Beau 6 12 7< / pre >
2021-06-15 00:49:18 -07: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