Turn one dataframe into several dfs and add them as CSVs to zip archive (without saving files locally)

Question

I have a data frame which I read in from a locally saved CSV file. I then want to loop over said file and create several CSV files based on a string in one column.

Lastly, I want to add all those files to a zip file, but without saving them locally. I just want one zip archive including all the different CSV files.

All my attempts using the io or zipfile modules only resulted in one zip file with one CSV file in it (pretty much with what I started with)

Any help would be much appreciated! Here is my code so far, which works but saves all CSV files just to my hard drive.

import pandas as pd
from zipfile import ZipFile

df = pd.read_csv("myCSV.csv")
channelsList = df["Turn one column to list"].values.tolist()
channelsList = list(set(channelsList)) #delete duplicates from list

for channel in channelsList:
    newDf = df.loc[df['Something to match'] == channel]
    
    newDf.to_csv(f"{channel}.csv") # saves csv files to disk