{ "cells": [ { "cell_type": "code", "execution_count": 22, "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 23, "metadata": {}, "outputs": [], "source": [ "data = pd.read_excel('data.xlsx')" ] }, { "cell_type": "code", "execution_count": 24, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | Outlet code | \n", "Image No. | \n", "Pepsodent AI Qty. | \n", "
|---|---|---|---|
| 0 | \n", "K41-0005 | \n", "K41-0005_Bera_April_.jpeg | \n", "NaN | \n", "
| 1 | \n", "K41-0110 | \n", "K41-0110_Bera_April_.jpeg | \n", "NaN | \n", "
| 2 | \n", "K41-0112 | \n", "K41-0112_Bera_April _.jpeg | \n", "NaN | \n", "
| 3 | \n", "K41-0745 | \n", "K41-0745_Bera_April _.jpeg | \n", "NaN | \n", "
| 4 | \n", "K41-1087 | \n", "K41-1087_Bera_April_.jpeg | \n", "NaN | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "
| 3776 | \n", "C04-0090 | \n", "C04-0090_Sunamganj Town.jpeg | \n", "NaN | \n", "
| 3777 | \n", "C04-1064 | \n", "C04-1064_Sunamganj Town.jpeg | \n", "NaN | \n", "
| 3778 | \n", "C04-1406 | \n", "C04-1406_Sunamganj Town.jpeg | \n", "NaN | \n", "
| 3779 | \n", "C04-2281375 | \n", "C04-2281375_Sunamganj Town.jpeg | \n", "NaN | \n", "
| 3780 | \n", "C04-2550986 | \n", "C04-2550986_Sunamganj Town.jpeg | \n", "NaN | \n", "
3781 rows × 3 columns
\n", "| \n", " | Outlet code | \n", "Image No. | \n", "Pepsodent AI Qty. | \n", "
|---|---|---|---|
| 0 | \n", "K41-0005 | \n", "K41-0005_Bera_April_.jpeg | \n", "NaN | \n", "
| 1 | \n", "K41-0110 | \n", "K41-0110_Bera_April_.jpeg | \n", "NaN | \n", "
| 2 | \n", "K41-0112 | \n", "K41-0112_Bera_April _.jpeg | \n", "555.0 | \n", "
| 3 | \n", "K41-0745 | \n", "K41-0745_Bera_April _.jpeg | \n", "NaN | \n", "
| 4 | \n", "K41-1087 | \n", "K41-1087_Bera_April_.jpeg | \n", "NaN | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "
| 3776 | \n", "C04-0090 | \n", "C04-0090_Sunamganj Town.jpeg | \n", "NaN | \n", "
| 3777 | \n", "C04-1064 | \n", "C04-1064_Sunamganj Town.jpeg | \n", "NaN | \n", "
| 3778 | \n", "C04-1406 | \n", "C04-1406_Sunamganj Town.jpeg | \n", "NaN | \n", "
| 3779 | \n", "C04-2281375 | \n", "C04-2281375_Sunamganj Town.jpeg | \n", "NaN | \n", "
| 3780 | \n", "C04-2550986 | \n", "C04-2550986_Sunamganj Town.jpeg | \n", "NaN | \n", "
3781 rows × 3 columns
\n", "