Question: Can a python script separate out below excel file into three different excel files based on names and Can python script do this and can
Can a python script separate out below excel file into three different excel files based on names and Can python script do this and can specify where those 3 excel files will be save meaning which location I can save the file can specify in python script.:
| Name | Place | Type |
| Sam | Food | Fun |
| Sam | Flower | Tree |
| Ram | Fry | Gadget |
| Ram | Fan | Gadget |
| Pam | Movie | Fun |
For instance, based on names, 3 excel file will look like this:
Excel file 1 : Sams file
| Name | Place | Type |
| Sam | Food | Fun |
| Sam | Flower | Tree |
Excel file 2: Rams file
| Name | Place | Type |
| Ram | Fry | Gadget |
| Ram | Fan | Gadget |
Excel file 3: Pams file
| Name | Place | Type |
| Pam | Movie | Fun |
Can python script do this and can specify where those 3 excel files will be save meaning which location.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
