Back to Freecodecamp

Pandas Conditional Selection and Modifying DataFrames

curriculum/challenges/english/blocks/data-analysis-with-python-course/5e9a093a74c4063ca6f7c15b.md

latest1.5 KB
Original Source

--description--

Instead of using notebooks.ai like it shows in the video, you can use Google Colab instead.

More resources:

  • <a href="https://github.com/ine-rmotr-curriculum/freecodecamp-intro-to-pandas" target="_blank" rel="noopener noreferrer nofollow">Notebooks on GitHub</a>
  • <a href="https://colab.research.google.com/github/googlecolab/colabtools/blob/master/notebooks/colab-github-demo.ipynb" target="_blank" rel="noopener noreferrer nofollow">How to open Notebooks from GitHub using Google Colab.</a>

--questions--

--text--

What will the following code print out?

py
import pandas as pd

certificates_earned = pd.DataFrame({
    'Certificates': [8, 2, 5, 6],
    'Time (in months)': [16, 5, 9, 12]
})
names = ['Tom', 'Kris', 'Ahmad', 'Beau']

certificates_earned.index = names
longest_streak = pd.Series([13, 11, 9, 7], index=names)
certificates_earned['Longest streak'] = longest_streak

print(certificates_earned)

--answers--

<pre> Tom 13 Kris 11 Ahmad 9 Beau 7 Name: Longest streak, dtype: int64 </pre>
<pre> Certificates Time (in months) Longest streak Tom 8 16 13 Kris 2 5 11 Ahmad 5 9 9 Beau 6 12 7 </pre>
<pre> Certificates Longest streak Tom 8 13 Kris 2 11 Ahmad 5 9 Beau 6 7 </pre>

--video-solution--

2