Skip to content

Instantly share code, notes, and snippets.

@ElisonSherton

ElisonSherton/df_demo.ipynb

Created June 1, 2022 12:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ElisonSherton/c1d3f86f28e4699d30d2c958ed4a4567 to your computer and use it in GitHub Desktop.
Save ElisonSherton/c1d3f86f28e4699d30d2c958ed4a4567 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
df_demo.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "6cb1a2d3-0196-44d3-8c65-4759ed3635b6",
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "3af2d82b-8dfb-4cdf-84de-55b754c4569f",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>FileName</th>\n",
" <th>Species</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>a.png</td>\n",
" <td>weed0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>b.png</td>\n",
" <td>weed1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>c.png</td>\n",
" <td>weed2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" FileName Species\n",
"0 a.png weed0\n",
"1 b.png weed1\n",
"2 c.png weed2"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"temp = pd.DataFrame([[\"a.png\", \"weed0\"], [\"b.png\", \"weed1\"], [\"c.png\", \"weed2\"]], columns = [\"FileName\", \"Species\"])\n",
"temp"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "e5b6be82-594e-43b7-b4fe-8dee8fcd4202",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>FileName</th>\n",
" <th>Species</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>a.png</td>\n",
" <td>weed0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" FileName Species\n",
"0 a.png weed0"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# This has the index 0\n",
"temp[temp.FileName.str.contains(\"a.png\")]"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "dcd5f188-5cd8-478e-b8e6-842d7baa6560",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>FileName</th>\n",
" <th>Species</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>b.png</td>\n",
" <td>weed1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" FileName Species\n",
"1 b.png weed1"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# This does not have the index\n",
"temp[temp.FileName.str.contains(\"b.png\")]"
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "a4e03cd1-d802-41f5-9a30-949b12eebeec",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>FileName</th>\n",
" <th>Species</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>b.png</td>\n",
" <td>weed1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" FileName Species\n",
"0 b.png weed1"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# This does not have the index, so you can reset the index and then get use iloc[0] again\n",
"temp[temp.FileName.str.contains(\"b.png\")].reset_index(drop = True)"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 (ipykernel)",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.8.12"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment