Extract Data from single sheet in single excel file and then create multiple excel sheets by performing data...
up vote
-3
down vote
favorite
I have created a data frame in python which consists of data contained in excel sheet as per details below.
I have a single sheet in single excel file with 100000 rows and 2 columns ("Location Name","Email Id") like as below format in df:
df.head()
Location Name Email Id
Maxs Qatar 123@gmail.com
Maxs Dubai sfsdf@abc.com
Maxs Dubai sdd@gmail.com
Maxs Kuwait sdd@gmail.com
Maxs Mall sdd@gmail.com
Now, my requirement is to get an excel file with multiple sheets with each location segregated separately as per location name like below using Python dataframe.
Sheet1:
Location Name Email Id
Maxs Qatar 123@gmail.com
Sheet2:
Location Name Email Id
Maxs Dubai sfsdf@abc.com
Maxs Dubai sdd@gmail.com
python-3.x excel pandas
asked Dec 6 at 9:32
yogesh sasanapuri
1
closed as off-topic by Toby Speight, Mast, πάντα ῥεῖ, Graipher, Sᴀᴍ Onᴇᴌᴀ Dec 6 at 14:30
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – Toby Speight, Mast, πάντα ῥεῖ, Graipher, Sᴀᴍ Onᴇᴌᴀ
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
-3
down vote
favorite
I have created a data frame in python which consists of data contained in excel sheet as per details below.
I have a single sheet in single excel file with 100000 rows and 2 columns ("Location Name","Email Id") like as below format in df:
df.head()
Location Name Email Id
Maxs Qatar 123@gmail.com
Maxs Dubai sfsdf@abc.com
Maxs Dubai sdd@gmail.com
Maxs Kuwait sdd@gmail.com
Maxs Mall sdd@gmail.com
Now, my requirement is to get an excel file with multiple sheets with each location segregated separately as per location name like below using Python dataframe.
Sheet1:
Location Name Email Id
Maxs Qatar 123@gmail.com
Sheet2:
Location Name Email Id
Maxs Dubai sfsdf@abc.com
Maxs Dubai sdd@gmail.com
python-3.x excel pandas
asked Dec 6 at 9:32
yogesh sasanapuri
1
closed as off-topic by Toby Speight, Mast, πάντα ῥεῖ, Graipher, Sᴀᴍ Onᴇᴌᴀ Dec 6 at 14:30
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – Toby Speight, Mast, πάντα ῥεῖ, Graipher, Sᴀᴍ Onᴇᴌᴀ
If this question can be reworded to fit the rules in the help center, please edit the question.
1
Welcome to Code Review! Unfortunately your question is off-topic as of now, as the code to be reviewed must be present in the question. Please add the code you want reviewed in your question. Thanks!
– Toby Speight
Dec 6 at 9:49
1
In addition to what @TobySpeight said, the code must also be working (to the best of your knowledge). We can only make working code better here, not add new features or write the code for you in the first place.
– Graipher
Dec 6 at 14:18
add a comment |
up vote
-3
down vote
favorite
up vote
-3
down vote
favorite
I have created a data frame in python which consists of data contained in excel sheet as per details below.
I have a single sheet in single excel file with 100000 rows and 2 columns ("Location Name","Email Id") like as below format in df:
df.head()
Location Name Email Id
Maxs Qatar 123@gmail.com
Maxs Dubai sfsdf@abc.com
Maxs Dubai sdd@gmail.com
Maxs Kuwait sdd@gmail.com
Maxs Mall sdd@gmail.com
Now, my requirement is to get an excel file with multiple sheets with each location segregated separately as per location name like below using Python dataframe.
Sheet1:
Location Name Email Id
Maxs Qatar 123@gmail.com
Sheet2:
Location Name Email Id
Maxs Dubai sfsdf@abc.com
Maxs Dubai sdd@gmail.com
python-3.x excel pandas
asked Dec 6 at 9:32
yogesh sasanapuri
1
I have created a data frame in python which consists of data contained in excel sheet as per details below.
I have a single sheet in single excel file with 100000 rows and 2 columns ("Location Name","Email Id") like as below format in df:
df.head()
Location Name Email Id
Maxs Qatar 123@gmail.com
Maxs Dubai sfsdf@abc.com
Maxs Dubai sdd@gmail.com
Maxs Kuwait sdd@gmail.com
Maxs Mall sdd@gmail.com
Now, my requirement is to get an excel file with multiple sheets with each location segregated separately as per location name like below using Python dataframe.
Sheet1:
Location Name Email Id
Maxs Qatar 123@gmail.com
Sheet2:
Location Name Email Id
Maxs Dubai sfsdf@abc.com
Maxs Dubai sdd@gmail.com
python-3.x excel pandas
python-3.x excel pandas
asked Dec 6 at 9:32
yogesh sasanapuri
1
asked Dec 6 at 9:32
yogesh sasanapuri
1
asked Dec 6 at 9:32
yogesh sasanapuri
1
asked Dec 6 at 9:32
yogesh sasanapuri
1
asked Dec 6 at 9:32
yogesh sasanapuri
1
1
closed as off-topic by Toby Speight, Mast, πάντα ῥεῖ, Graipher, Sᴀᴍ Onᴇᴌᴀ Dec 6 at 14:30
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – Toby Speight, Mast, πάντα ῥεῖ, Graipher, Sᴀᴍ Onᴇᴌᴀ
If this question can be reworded to fit the rules in the help center, please edit the question.
closed as off-topic by Toby Speight, Mast, πάντα ῥεῖ, Graipher, Sᴀᴍ Onᴇᴌᴀ Dec 6 at 14:30
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – Toby Speight, Mast, πάντα ῥεῖ, Graipher, Sᴀᴍ Onᴇᴌᴀ
If this question can be reworded to fit the rules in the help center, please edit the question.
1
Welcome to Code Review! Unfortunately your question is off-topic as of now, as the code to be reviewed must be present in the question. Please add the code you want reviewed in your question. Thanks!
– Toby Speight
Dec 6 at 9:49
1
In addition to what @TobySpeight said, the code must also be working (to the best of your knowledge). We can only make working code better here, not add new features or write the code for you in the first place.
– Graipher
Dec 6 at 14:18
add a comment |
1
Welcome to Code Review! Unfortunately your question is off-topic as of now, as the code to be reviewed must be present in the question. Please add the code you want reviewed in your question. Thanks!
– Toby Speight
Dec 6 at 9:49
1
In addition to what @TobySpeight said, the code must also be working (to the best of your knowledge). We can only make working code better here, not add new features or write the code for you in the first place.
– Graipher
Dec 6 at 14:18
1
1
Welcome to Code Review! Unfortunately your question is off-topic as of now, as the code to be reviewed must be present in the question. Please add the code you want reviewed in your question. Thanks!
– Toby Speight
Dec 6 at 9:49
Welcome to Code Review! Unfortunately your question is off-topic as of now, as the code to be reviewed must be present in the question. Please add the code you want reviewed in your question. Thanks!
– Toby Speight
Dec 6 at 9:49
1
1
In addition to what @TobySpeight said, the code must also be working (to the best of your knowledge). We can only make working code better here, not add new features or write the code for you in the first place.
– Graipher
Dec 6 at 14:18
In addition to what @TobySpeight said, the code must also be working (to the best of your knowledge). We can only make working code better here, not add new features or write the code for you in the first place.
– Graipher
Dec 6 at 14:18
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Welcome to Code Review! Unfortunately your question is off-topic as of now, as the code to be reviewed must be present in the question. Please add the code you want reviewed in your question. Thanks!
– Toby Speight
Dec 6 at 9:49
1
In addition to what @TobySpeight said, the code must also be working (to the best of your knowledge). We can only make working code better here, not add new features or write the code for you in the first place.
– Graipher
Dec 6 at 14:18