I have an excel file with about 128000 rows and I want to split it to several excel file in pandas, each with 6000 rows & then again read all in one data frame.
Any ideas how to make it?
Thanks in Advance
I have an excel file with about 128000 rows and I want to split it to several excel file in pandas, each with 6000 rows & then again read all in one data frame.
Any ideas how to make it?
Thanks in Advance