Hfrxdjt

Why was the term "discrete" used in discrete logarithm?

Is it true that "carbohydrates are of no use for the basal metabolic need"?

3 doors, three guards, one stone

Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?

How does debian/ubuntu knows a package has a updated version

How to bypass password on Windows XP account?

Why did the rest of the Eastern Bloc not invade Yugoslavia?

How to react to hostile behavior from a senior developer?

Identifying polygons that intersect with another layer using QGIS?

Book where humans were engineered with genes from animal species to survive hostile planets

Why are Kinder Surprise Eggs illegal in the USA?

How come Sam didn't become Lord of Horn Hill?

How do I name drop voicings

How does the particle を relate to the verb 行く in the structure「A を + B に行く」?

Why light coming from distant stars is not discreet?

Identify plant with long narrow paired leaves and reddish stems

Withdrew £2800, but only £2000 shows as withdrawn on online banking; what are my obligations?

When do you get frequent flier miles - when you buy, or when you fly?

How do pianists reach extremely loud dynamics?

Sci-Fi book where patients in a coma ward all live in a subconscious world linked together

What does the "x" in "x86" represent?

Apollo command module space walk?

English words in a non-english sci-fi novel

Short Story with Cinderella as a Voo-doo Witch

how to export the tables into a csv file pandas

0

$begingroup$

The following is a piece of code I wrote to create a pivot table for categorical vs continuous variable.

for row in categorical:
 for col in numeric:
 ptable = pd.pivot_table(df, values = col, index = row, aggfunc = ['min','max','median','mean','std',lambda x: 100*x.count()/df.shape[0]])
 print(ptable)
 writer = pd.ExcelWriter('report.xlsx')
 ptable.to_excel(writer, 'Sheet1')
 writer.save()

It displays the output as in the image:

but this is not a data frame and when writing into an excel file it displays only the last iteration values.

how do I get all the iterated tables into the excel file or separate excel files?

python pandas ipython

share|improve this question

edited Jun 19 '18 at 14:59

Harpal

2661310

asked Jun 19 '18 at 11:22

Abraham WilsonAbraham Wilson

63

$endgroup$

bumped to the homepage by Community♦ 21 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

$begingroup$

The following is a piece of code I wrote to create a pivot table for categorical vs continuous variable.

for row in categorical:
 for col in numeric:
 ptable = pd.pivot_table(df, values = col, index = row, aggfunc = ['min','max','median','mean','std',lambda x: 100*x.count()/df.shape[0]])
 print(ptable)
 writer = pd.ExcelWriter('report.xlsx')
 ptable.to_excel(writer, 'Sheet1')
 writer.save()

It displays the output as in the image:

but this is not a data frame and when writing into an excel file it displays only the last iteration values.

how do I get all the iterated tables into the excel file or separate excel files?

python pandas ipython

share|improve this question

edited Jun 19 '18 at 14:59

Harpal

2661310

asked Jun 19 '18 at 11:22

Abraham WilsonAbraham Wilson

63

$endgroup$

bumped to the homepage by Community♦ 21 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

$begingroup$

The following is a piece of code I wrote to create a pivot table for categorical vs continuous variable.

for row in categorical:
 for col in numeric:
 ptable = pd.pivot_table(df, values = col, index = row, aggfunc = ['min','max','median','mean','std',lambda x: 100*x.count()/df.shape[0]])
 print(ptable)
 writer = pd.ExcelWriter('report.xlsx')
 ptable.to_excel(writer, 'Sheet1')
 writer.save()

It displays the output as in the image:

but this is not a data frame and when writing into an excel file it displays only the last iteration values.

how do I get all the iterated tables into the excel file or separate excel files?

python pandas ipython

share|improve this question

edited Jun 19 '18 at 14:59

Harpal

2661310

asked Jun 19 '18 at 11:22

Abraham WilsonAbraham Wilson

63

$endgroup$

for row in categorical:
 for col in numeric:
 ptable = pd.pivot_table(df, values = col, index = row, aggfunc = ['min','max','median','mean','std',lambda x: 100*x.count()/df.shape[0]])
 print(ptable)
 writer = pd.ExcelWriter('report.xlsx')
 ptable.to_excel(writer, 'Sheet1')
 writer.save()

share|improve this question

edited Jun 19 '18 at 14:59

Harpal

2661310

asked Jun 19 '18 at 11:22

Abraham WilsonAbraham Wilson

63

share|improve this question

edited Jun 19 '18 at 14:59

Harpal

2661310

asked Jun 19 '18 at 11:22

Abraham WilsonAbraham Wilson

63

edited Jun 19 '18 at 14:59

Harpal

2661310

edited Jun 19 '18 at 14:59

Harpal

2661310

asked Jun 19 '18 at 11:22

Abraham WilsonAbraham Wilson

63

asked Jun 19 '18 at 11:22

Abraham WilsonAbraham Wilson

63

1 Answer
1

active

oldest

votes

0

$begingroup$

Your current code overwrites the previous sheet, which is why only the last iteration is present. Setting each sheet to the same name (Sheet1) will overwrite the sheet. This name will need to be changed for each interation.

Try this:

for row_index, row in enumerate(categorical):
 for col_index, col in enumerate(numeric):
 ptable = pd.pivot_table(df, values = col, index = row, aggfunc = ['min','max','median','mean','std',lambda x: 100*x.count()/df.shape[0]])
 print(ptable)
 writer = pd.ExcelWriter('report.xlsx')
 ptable.to_excel(writer, 'Sheet1__'.format(row_index, col_index))
 writer.save()

This should save each iteration as an individual sheet

share|improve this answer

answered Jun 19 '18 at 12:17

HarpalHarpal

2661310

$endgroup$

• 
  
  
  

  
  

  
  
  
  
  
  

  
  $begingroup$
  i ran into the following error: Exception: Excel worksheet name 'Sheet1_Runners-Up_QualifiedTeams' must be <= 31 chars.
  $endgroup$
  – Abraham Wilson
  Jun 19 '18 at 14:00
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  $begingroup$
  Instead of writing it into different CSV, is it possible to convert the ptable into dataframes??
  $endgroup$
  – Abraham Wilson
  Jun 20 '18 at 11:52
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "557"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f33370%2fhow-to-export-the-tables-into-a-csv-file-pandas%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

$begingroup$

Your current code overwrites the previous sheet, which is why only the last iteration is present. Setting each sheet to the same name (Sheet1) will overwrite the sheet. This name will need to be changed for each interation.

Try this:

for row_index, row in enumerate(categorical):
 for col_index, col in enumerate(numeric):
 ptable = pd.pivot_table(df, values = col, index = row, aggfunc = ['min','max','median','mean','std',lambda x: 100*x.count()/df.shape[0]])
 print(ptable)
 writer = pd.ExcelWriter('report.xlsx')
 ptable.to_excel(writer, 'Sheet1__'.format(row_index, col_index))
 writer.save()

This should save each iteration as an individual sheet

share|improve this answer

answered Jun 19 '18 at 12:17

HarpalHarpal

2661310

$endgroup$

• 
  
  
  

  
  

  
  
  
  
  
  

  
  $begingroup$
  i ran into the following error: Exception: Excel worksheet name 'Sheet1_Runners-Up_QualifiedTeams' must be <= 31 chars.
  $endgroup$
  – Abraham Wilson
  Jun 19 '18 at 14:00
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  $begingroup$
  Instead of writing it into different CSV, is it possible to convert the ptable into dataframes??
  $endgroup$
  – Abraham Wilson
  Jun 20 '18 at 11:52
  

  
  
  
  

add a comment | 

0

$begingroup$

Your current code overwrites the previous sheet, which is why only the last iteration is present. Setting each sheet to the same name (Sheet1) will overwrite the sheet. This name will need to be changed for each interation.

Try this:

for row_index, row in enumerate(categorical):
 for col_index, col in enumerate(numeric):
 ptable = pd.pivot_table(df, values = col, index = row, aggfunc = ['min','max','median','mean','std',lambda x: 100*x.count()/df.shape[0]])
 print(ptable)
 writer = pd.ExcelWriter('report.xlsx')
 ptable.to_excel(writer, 'Sheet1__'.format(row_index, col_index))
 writer.save()

This should save each iteration as an individual sheet

share|improve this answer

answered Jun 19 '18 at 12:17

HarpalHarpal

2661310

$endgroup$

• 
  
  
  

  
  

  
  
  
  
  
  

  
  $begingroup$
  i ran into the following error: Exception: Excel worksheet name 'Sheet1_Runners-Up_QualifiedTeams' must be <= 31 chars.
  $endgroup$
  – Abraham Wilson
  Jun 19 '18 at 14:00
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  $begingroup$
  Instead of writing it into different CSV, is it possible to convert the ptable into dataframes??
  $endgroup$
  – Abraham Wilson
  Jun 20 '18 at 11:52
  

  
  
  
  

add a comment | 

$begingroup$

Your current code overwrites the previous sheet, which is why only the last iteration is present. Setting each sheet to the same name (Sheet1) will overwrite the sheet. This name will need to be changed for each interation.

Try this:

for row_index, row in enumerate(categorical):
 for col_index, col in enumerate(numeric):
 ptable = pd.pivot_table(df, values = col, index = row, aggfunc = ['min','max','median','mean','std',lambda x: 100*x.count()/df.shape[0]])
 print(ptable)
 writer = pd.ExcelWriter('report.xlsx')
 ptable.to_excel(writer, 'Sheet1__'.format(row_index, col_index))
 writer.save()

This should save each iteration as an individual sheet

share|improve this answer

answered Jun 19 '18 at 12:17

HarpalHarpal

2661310

$endgroup$

for row_index, row in enumerate(categorical):
 for col_index, col in enumerate(numeric):
 ptable = pd.pivot_table(df, values = col, index = row, aggfunc = ['min','max','median','mean','std',lambda x: 100*x.count()/df.shape[0]])
 print(ptable)
 writer = pd.ExcelWriter('report.xlsx')
 ptable.to_excel(writer, 'Sheet1__'.format(row_index, col_index))
 writer.save()

share|improve this answer

answered Jun 19 '18 at 12:17

HarpalHarpal

2661310

answered Jun 19 '18 at 12:17

HarpalHarpal

2661310

answered Jun 19 '18 at 12:17

HarpalHarpal

2661310