generate functionMon, 29 May 2023

seleccionar datos de 900 mil filas de un excel con pandas y dividirlo en 2 hojas

import pandas as pd df = pd.read_excel('../dummy_data/dummy.xlsx') len(df) df.head(5) df_1 = df.loc[0:90000] df_2 = df.loc[90000:] df_1.to_excel("../dummy_data/df_1.xlsx", index = False) df_2.to_excel("../dummy_data/df_2.xlsx", index = False)

Want to kickstart your project?Use the new AI Studio to create your code