Split .csv files by rows.

split_csv_by_row.py

def split_and_save_df(df, name='NoName', chunk_size=100, output_dir=''):
    """Split a dataframe and save each chunk in a different csv file.

    Parameters:
        df : data frame ( df = pd.read_csv('file.csv')
        name : name of output file
        chunk_size : chunk size
        output_dir : directory where to write the divided dataframe
    """
    import os
    for i in range(0, df.shape[0], chunk_size):
        start = i
        end = min(i + chunk_size - 1, df.shape[0])
        subset = df.loc[start:end]
        output_path = os.path.join(output_dir, f"{name}_{start}_{end}.csv")
        print(f">> Going to write into {output_path}")
        subset.to_csv(output_path)
        output_size = os.stat(output_path).st_size
        print(f">> Wrote {output_size} bytes")