<h2>Import modules</h2>
<pre class="language-python"><code>#import modules
import pandas as pd</code></pre>
<h2>Create a dummy dataframe</h2>
<pre class="language-python"><code>#create a dataframe
data = {'name': ['Cristiano Ronaldo', 'Neymar','Kylian Mbapp&eacute;','Erling Haaland','L&eacute;o Messi','Karim Benzema'],
'age': [36, 29,22,20,33,33],
'height_cm': [187, 175,178,194,170, 187],
'club': ['Juventus FC', 'Paris Saint Germain','Paris Saint Germain','Borussia Dortmund','FC Barcelona', 'Real Madrid'],
'country': ['Portugal', 'Brazil','France','Norway','Argentina','France']}
df = pd.DataFrame(data)
df</code></pre>
<div class="prompt output_prompt">&nbsp;</div>
<div class="output_html rendered_html output_subarea output_execute_result">
<div>
<table class="dataframe" border="1">
<thead>
<tr>
<th>&nbsp;</th>
<th>name</th>
<th>age</th>
<th>height_cm</th>
<th>club</th>
<th>country</th>
</tr>
</thead>
<tbody>
<tr>
<th>0</th>
<td>Cristiano Ronaldo</td>
<td>36</td>
<td>187</td>
<td>Juventus FC</td>
<td>Portugal</td>
</tr>
<tr>
<th>1</th>
<td>Neymar</td>
<td>29</td>
<td>175</td>
<td>Paris Saint Germain</td>
<td>Brazil</td>
</tr>
<tr>
<th>2</th>
<td>Kylian Mbapp&eacute;</td>
<td>22</td>
<td>178</td>
<td>Paris Saint Germain</td>
<td>France</td>
</tr>
<tr>
<th>3</th>
<td>Erling Haaland</td>
<td>20</td>
<td>194</td>
<td>Borussia Dortmund</td>
<td>Norway</td>
</tr>
<tr>
<th>4</th>
<td>L&eacute;o Messi</td>
<td>33</td>
<td>170</td>
<td>FC Barcelona</td>
<td>Argentina</td>
</tr>
<tr>
<th>5</th>
<td>Karim Benzema</td>
<td>33</td>
<td>187</td>
<td>Real Madrid</td>
<td>France</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
</div>
</div>
<h2>Filters on rows containing word "Paris Saint Germain"</h2>
<pre class="language-python"><code>
#Filter on players playing in Paris Saint Germain
df_filtered = df[df['club'].str.contains('Paris Saint Germain')]
df_filtered</code></pre>
<div class="prompt output_prompt">&nbsp;</div>
<div class="output_html rendered_html output_subarea output_execute_result">
<div>
<table class="dataframe" border="1">
<thead>
<tr>
<th>&nbsp;</th>
<th>name</th>
<th>age</th>
<th>height_cm</th>
<th>club</th>
<th>country</th>
</tr>
</thead>
<tbody>
<tr>
<th>1</th>
<td>Neymar</td>
<td>29</td>
<td>175</td>
<td>Paris Saint Germain</td>
<td>Brazil</td>
</tr>
<tr>
<th>2</th>
<td>Kylian Mbapp&eacute;</td>
<td>22</td>
<td>178</td>
<td>Paris Saint Germain</td>
<td>France</td>
</tr>
</tbody>
</table>
</div>
</div>

Filter rows that contain a string in Pandas dataframe

<h2>Import modules</h2>
<pre class="language-python"><code>#import modules
import pandas as pd</code></pre>
<h2>Create a dataframe</h2>
<pre class="language-python"><code>#create a dataframe
data = {'name': ['Cristiano Ronaldo', 'Cristiano Ronaldo','Neymar','Kylian Mbapp&eacute;','Erling Haaland','L&eacute;o Messi','L&eacute;o Messi','Karim Benzema'],
'age': [36,36, 29,22,20,33,33,33],
'height_cm': [187,187, 175,178,194,170,170, 187],
'club': ['Juventus FC','Juventus FC', 'Paris Saint Germain','Paris Saint Germain','Borussia Dortmund','FC Barcelona','FC Barcelona', 'Real Madrid'],
'country': ['Portugal','Portugal', 'Brazil','France','Norway','Argentina','Argentina','France']}
df = pd.DataFrame(data)
df</code></pre>
<div class="prompt output_prompt">&nbsp;</div>
<div class="output_html rendered_html output_subarea output_execute_result">
<div>
<table class="dataframe" border="1">
<thead>
<tr>
<th>&nbsp;</th>
<th>name</th>
<th>age</th>
<th>height_cm</th>
<th>club</th>
<th>country</th>
</tr>
</thead>
<tbody>
<tr>
<th>0</th>
<td>Cristiano Ronaldo</td>
<td>36</td>
<td>187</td>
<td>Juventus FC</td>
<td>Portugal</td>
</tr>
<tr>
<th>1</th>
<td>Cristiano Ronaldo</td>
<td>36</td>
<td>187</td>
<td>Juventus FC</td>
<td>Portugal</td>
</tr>
<tr>
<th>2</th>
<td>Neymar</td>
<td>29</td>
<td>175</td>
<td>Paris Saint Germain</td>
<td>Brazil</td>
</tr>
<tr>
<th>3</th>
<td>Kylian Mbapp&eacute;</td>
<td>22</td>
<td>178</td>
<td>Paris Saint Germain</td>
<td>France</td>
</tr>
<tr>
<th>4</th>
<td>Erling Haaland</td>
<td>20</td>
<td>194</td>
<td>Borussia Dortmund</td>
<td>Norway</td>
</tr>
<tr>
<th>5</th>
<td>L&eacute;o Messi</td>
<td>33</td>
<td>170</td>
<td>FC Barcelona</td>
<td>Argentina</td>
</tr>
<tr>
<th>6</th>
<td>L&eacute;o Messi</td>
<td>33</td>
<td>170</td>
<td>FC Barcelona</td>
<td>Argentina</td>
</tr>
<tr>
<th>7</th>
<td>Karim Benzema</td>
<td>33</td>
<td>187</td>
<td>Real Madrid</td>
<td>France</td>
</tr>
</tbody>
</table>
</div>
</div>

Drop duplicate rows in a Pandas dataframe

<div class="row">
<div class="inner_cell">
<h2 class="text_cell_render border-box-sizing rendered_html"><span style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, 'Open Sans', 'Helvetica Neue', sans-serif;">&nbsp;Import module</span></h2>
</div>
</div>
<div class="row">
<div class="inner_cell">
<div class="text_cell_render border-box-sizing rendered_html">
<h2 id="import-modules"></h2>
<pre class="language-python"><code>#import modules
import pandas as pd
</code></pre>
<div class="prompt output_prompt">&nbsp;</div>
<h2 id="import-modules">Create a dummy dataframe</h2>
<pre class="language-python"><code>#create a dataframe
data = {'name': ['Cristiano Ronaldo', 'Neymar','Kylian Mbapp&eacute;','Erling Haaland','L&eacute;o Messi','Karim Benzema'],
'age': [36, 29,22,20,33,33],
'height_cm': [187, 175,178,194,170, 187],
'club': ['Juventus FC', 'Paris Saint Germain','Paris Saint Germain','Borussia Dortmund','FC Barcelona', 'Real Madrid'],
'country': ['Portugal', 'Brazil','France','Norway','Argentina','France']}
df = pd.DataFrame(data)
df</code></pre>
<div class="prompt output_prompt">&nbsp;</div>
<div class="output_html rendered_html output_subarea output_execute_result">
<table class="dataframe" border="1">
<thead>
<tr>
<th>&nbsp;</th>
<th>name</th>
<th>age</th>
<th>height_cm</th>
<th>club</th>
<th>country</th>
</tr>
</thead>
<tbody>
<tr>
<th>0</th>
<td>Cristiano Ronaldo</td>
<td>36</td>
<td>187</td>
<td>Juventus FC</td>
<td>Portugal</td>
</tr>
<tr>
<th>1</th>
<td>Neymar</td>
<td>29</td>
<td>175</td>
<td>Paris Saint Germain</td>
<td>Brazil</td>
</tr>
<tr>
<th>2</th>
<td>Kylian Mbapp&eacute;</td>
<td>22</td>
<td>178</td>
<td>Paris Saint Germain</td>
<td>France</td>
</tr>
<tr>
<th>3</th>
<td>Erling Haaland</td>
<td>20</td>
<td>194</td>
<td>Borussia Dortmund</td>
<td>Norway</td>
</tr>
<tr>
<th>4</th>
<td>L&eacute;o Messi</td>
<td>33</td>
<td>170</td>
<td>FC Barcelona</td>
<td>Argentina</td>
</tr>
<tr>
<th>5</th>
<td>Karim Benzema</td>
<td>33</td>
<td>187</td>
<td>Real Madrid</td>
<td>France</td>
</tr>
</tbody>
</table>
<h2>&nbsp;</h2>
<h2 id="import-modules">Rename columns</h2>
<pre class="language-python"><code>#rename columns name and age
df.rename(columns={'name': 'full_name', 'age': 'player_age'}, inplace=True)
df</code></pre>
<div class="prompt output_prompt">&nbsp;</div>
<div class="output_html rendered_html output_subarea output_execute_result">
<div>
<table class="dataframe" border="1">
<thead>
<tr>
<th>&nbsp;</th>
<th>full_name</th>
<th>player_age</th>
<th>height_cm</th>
<th>club</th>
<th>country</th>
</tr>
</thead>
<tbody>
<tr>
<th>0</th>
<td>Cristiano Ronaldo</td>
<td>36</td>
<td>187</td>
<td>Juventus FC</td>
<td>Portugal</td>
</tr>
<tr>
<th>1</th>
<td>Neymar</td>
<td>29</td>
<td>175</td>
<td>Paris Saint Germain</td>
<td>Brazil</td>
</tr>
<tr>
<th>2</th>
<td>Kylian Mbapp&eacute;</td>
<td>22</td>
<td>178</td>
<td>Paris Saint Germain</td>
<td>France</td>
</tr>
<tr>
<th>3</th>
<td>Erling Haaland</td>
<td>20</td>
<td>194</td>
<td>Borussia Dortmund</td>
<td>Norway</td>
</tr>
<tr>
<th>4</th>
<td>L&eacute;o Messi</td>
<td>33</td>
<td>170</td>
<td>FC Barcelona</td>
<td>Argentina</td>
</tr>
<tr>
<th>5</th>
<td>Karim Benzema</td>
<td>33</td>
<td>187</td>
<td>Real Madrid</td>
<td>France</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<pre class="language-python"><code>#drop duplicate rows
df = df.drop_duplicates(subset='name', keep='first')
df
</code></pre>
<div class="prompt output_prompt">&nbsp;</div>
<div class="output_html rendered_html output_subarea output_execute_result">
<div>
<table class="dataframe" border="1">
<thead>
<tr>
<th>&nbsp;</th>
<th>name</th>
<th>age</th>
<th>height_cm</th>
<th>club</th>
<th>country</th>
</tr>
</thead>
<tbody>
<tr>
<th>0</th>
<td>Cristiano Ronaldo</td>
<td>36</td>
<td>187</td>
<td>Juventus FC</td>
<td>Portugal</td>
</tr>
<tr>
<th>2</th>
<td>Neymar</td>
<td>29</td>
<td>175</td>
<td>Paris Saint Germain</td>
<td>Brazil</td>
</tr>
<tr>
<th>3</th>
<td>Kylian Mbapp&eacute;</td>
<td>22</td>
<td>178</td>
<td>Paris Saint Germain</td>
<td>France</td>
</tr>
<tr>
<th>4</th>
<td>Erling Haaland</td>
<td>20</td>
<td>194</td>
<td>Borussia Dortmund</td>
<td>Norway</td>
</tr>
<tr>
<th>5</th>
<td>L&eacute;o Messi</td>
<td>33</td>
<td>170</td>
<td>FC Barcelona</td>
<td>Argentina</td>
</tr>
<tr>
<th>7</th>
<td>Karim Benzema</td>
<td>33</td>
<td>187</td>
<td>Real Madrid</td>
<td>France</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>