Análisis de los 25 retailers más grandes de Estados Unidos
Exploración inicial
Importación de datos:
Companyobject
Walmart US4%
Kroger4%
23 others92%
Salesint64
16592 - 658119
0
Walmart US
658119
1
Kroger
115037
2
Costco
90048
3
Home Depot
83976
4
Walgreen Boots
78924
5
CVS incl. Target
77792
6
Amazon
71687
7
Target
71208
8
Lowe's
60311
9
Albertsons
56829
Salesfloat64
Storesfloat64
count
25
23
mean
71063.08
3466.565217
std
125405.7276
4038.708714
min
16592
231
25%
24402
1029
50%
34980
1828
75%
71687
4242
max
658119
14250
Reconocimiento de distribución
Limpieza de los datos
df['Category'].fillna(value='Electronic/Mail Order', inplace=True)
df = df.replace(to_replace ="Warehouse Club",value ="Warehouse Clubs")
#df['Stores'].fillna(value= 0, inplace=True)
df_shorted = df.sort_values('Sales', ascending=0)[1:]
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:2: UserWarning: FixedFormatter should only be used together with FixedLocator
df_shorted['Sales'].median()
Ahora si... ¡ Let's go!
Preguntas del negocio
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:5: UserWarning: FixedFormatter should only be used together with FixedLocator
"""
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:6: UserWarning: FixedFormatter should only be used together with FixedLocator
Valor minimo de ventas:16592
Rango de ventas:33408
Promedio de ventas de la mayoria de compañias:25415.571428571428
3. ¿Cuántas tiendas tiene la mayoría de las compañías?
Valor minimo de tiendas:231.0
Rango de cantidad de tiendas:2319.0
Promedio de cantidad de tiendas:1232.5333333333333
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:3: UserWarning: FixedFormatter should only be used together with FixedLocator
This is separate from the ipykernel package so we can avoid doing imports until
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:9: UserWarning: FixedFormatter should only be used together with FixedLocator
if __name__ == '__main__':
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:15: UserWarning: FixedFormatter should only be used together with FixedLocator
from ipykernel import kernelapp as app
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:19: UserWarning: FixedFormatter should only be used together with FixedLocator
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:25: UserWarning: FixedFormatter should only be used together with FixedLocator
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:28: UserWarning: FixedFormatter should only be used together with FixedLocator
valor minimo:16592
valor maximo:115037
Rango de ventas:98445
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:6: UserWarning: FixedFormatter should only be used together with FixedLocator
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:12: UserWarning: FixedFormatter should only be used together with FixedLocator
if sys.path[0] == '':
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:3: UserWarning: FixedFormatter should only be used together with FixedLocator
This is separate from the ipykernel package so we can avoid doing imports until
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:9: UserWarning: FixedFormatter should only be used together with FixedLocator
if __name__ == '__main__':