Skip to content

Verificando Ocorrências de Valores

Verificando a ocorrência de diversos valores em uma coluna

Verificando a forma (shape) do DF

python
df3.shape
out:
(9994, 11)
Ele nos retorna o número de linhas, número de colunas!


Aplicando um filtro que nos mostra se há a quantidade, 5,7,9 ou 11

python
df3[ df3['Quantidade'].isin([5,7,9, 11])]
out:

ID_Pedido Data_Pedido ID_Cliente Segmento Pais Regiao ID_Produto Categoria Nome_Produto Valor_Venda Quantidade
3 US-2015-108966 2015-10-11 SO-20335 Consumer United States South FUR-TA-10000577 Furniture Bretford CR4500 Series Slim Rectangular Table 957.5775 5.0
5 CA-2014-115812 2014-06-09 BH-11710 Consumer United States West FUR-FU-10001487 Furniture Eldon Expressions Wood and Plastic Desk Access... 48.8600 7.0
9 CA-2014-115812 2014-06-09 BH-11710 Consumer United States West OFF-AP-10002892 Office Supplies Belkin F5C206VTEL 6 Outlet Surge 114.9000 5.0
10 CA-2014-115812 2014-06-09 BH-11710 Consumer United States West FUR-TA-10001539 Furniture Chromcraft Rectangular Conference Tables 1706.1840 9.0
14 US-2015-118983 2015-11-22 HP-14815 Home Office United States Central OFF-AP-10002311 Office Supplies Holmes Replacement Filter for HEPA Air Cleaner... 68.8100 5.0
... ... ... ... ... ... ... ... ... ... ... ...
9974 US-2016-103674 2016-12-06 AP-10720 Home Office United States West OFF-AR-10004752 Office Supplies Blackstonian Pencils 18.6900 7.0
9977 US-2016-103674 2016-12-06 AP-10720 Home Office United States West OFF-FA-10003467 Office Supplies Alliance Big Bands Rubber Bands, 12/Pack 13.8600 7.0
9981 CA-2017-163566 2017-08-03 TB-21055 Consumer United States East OFF-LA-10004484 Office Supplies Avery 476 16.5200 5.0
9982 US-2016-157728 2016-09-22 RC-19960 Consumer United States Central OFF-PA-10002195 Office Supplies RSVP Cards & Envelopes, Blank White, 8-1/2" X ... 35.5600 7.0
9988 CA-2017-163629 2017-11-17 RA-19885 Corporate United States South TEC-PH-10004006 Technology Panasonic KX - TS880B Telephone 206.1000 5.0

2128 rows × 11 columns


Aplicando o mesmo filtro, porém, quero ver apenas o formato do retorno, Quantas linhas e colunas

python
df3[ df3['Quantidade'].isin([5,7,9, 11])].shape
out:
(2128, 11)

Aplicando o mesmo filtro, porém, visualizando apenas as 10 primeiras linhas!

python
df3[ df3['Quantidade'].isin([5,7,9, 11])][:10]
out:

ID_Pedido Data_Pedido ID_Cliente Segmento Pais Regiao ID_Produto Categoria Nome_Produto Valor_Venda Quantidade
3 US-2015-108966 2015-10-11 SO-20335 Consumer United States South FUR-TA-10000577 Furniture Bretford CR4500 Series Slim Rectangular Table 957.5775 5.0
5 CA-2014-115812 2014-06-09 BH-11710 Consumer United States West FUR-FU-10001487 Furniture Eldon Expressions Wood and Plastic Desk Access... 48.8600 7.0
9 CA-2014-115812 2014-06-09 BH-11710 Consumer United States West OFF-AP-10002892 Office Supplies Belkin F5C206VTEL 6 Outlet Surge 114.9000 5.0
10 CA-2014-115812 2014-06-09 BH-11710 Consumer United States West FUR-TA-10001539 Furniture Chromcraft Rectangular Conference Tables 1706.1840 9.0
14 US-2015-118983 2015-11-22 HP-14815 Home Office United States Central OFF-AP-10002311 Office Supplies Holmes Replacement Filter for HEPA Air Cleaner... 68.8100 5.0
21 CA-2016-137330 2016-12-09 KB-16585 Corporate United States Central OFF-AR-10000246 Office Supplies Newell 318 19.4600 7.0
22 CA-2016-137330 2016-12-09 KB-16585 Corporate United States Central OFF-AP-10001492 Office Supplies Acco Six-Outlet Power Strip, 4' Cord Length 60.3400 7.0
27 US-2015-150630 2015-09-17 TB-21520 Consumer United States East FUR-BO-10004834 Furniture Riverside Palais Royal Lawyers Bookcase, Royal... 3083.4300 7.0
35 CA-2016-117590 2016-12-08 GH-14485 Corporate United States Central TEC-PH-10004977 Technology GE 30524EE4 1097.5440 7.0
36 CA-2016-117590 2016-12-08 GH-14485 Corporate United States Central FUR-FU-10003664 Furniture Electrix Architect's Clamp-On Swing Arm Lamp, ... 190.9200 5.0