How split a pandas dataframe in muliple excel files -


i have data frame sales related different countries. need crate different excel each of country have in dataframe. not sure how can accomplish in pandas

consider dataframe df

df = pd.dataframe(dict(         sales=[1, 2, 3, 4],         country=['jp', 'cn', 'uk', 'au']     ))  print(df)    country  sales 0      jp      1 1      cn      2 2      uk      3 3      au      4

we can iterate through groupby object , use to_excel

for n, g in df.groupby('country'):     # `n` group name, country     g.to_excel('{}.xlsx'.format(n))

this have created files

['au.xlsx', 'cn.xlsx', 'jp.xlsx', 'uk.xlsx']

-

Comments

Post a Comment

Popular posts from this blog

cookies - Yii2 Advanced - Share session between frontend and mainsite (duplicate of frontend for www) -

i have custom members system have made: yii2 members system . can refer full details, or install can work question. i have frontend , backend yii2 provides, few modifications separate sessions/cookies backend works admin model , pulls admin table. similar old traditional member systems. mainsite clone of frontend , it's role main website. when go www.site.com or site.com . here 3 apps , example domains: mainsite = www.site.com or site.com frontend = users.site.com backend = admin.site.com when user logs in ( users.site.com/site/login ) , go homepage ( mainsite @ www.site.com ) want know logged in , show username. how frontend operates default advanced app. from have far, login , head mainsite , reads an internal server error occurred. . doesn't yii error, server error? when in yii logs under runtime, mentions access control: 2017-04-14 13:38:25 [127.0.0.1][1][-][error][yii\web\httpexception:403] exception 'yii\web\forbiddenhttpexception'...
Read more

angular - password and confirm password field validation angular2 reactive forms -

i need check whether password , confirm password fields have same value using reactive form angular2. did see lot of answers on same here, angular 2 form validating repeat password , comparing fields in validator angular2 , none seemed work me.can please help."this" undefined in validate function :( . sharing code, this.addedituserform = this.builder.group({ firstname: ['', validators.required], lastname: ['', validators.required], title: ['', validators.required], email: ['', validators.required], password: ['', validators.required], confirmpass: ['', [validators.required, this.validatepasswordconfirmation]] }); validatepasswordconfirmation(group: formgroup): any{ let valid = true; // if (this.addedituserform.controls.password != this.addedituserform.controls.confirmpass) { // valid = false; // this.add...
Read more

javascript - Angular2 intelliJ config error.. Cannot find module '@angular/core' -

Image
i new angular2. following tutorial angular2 example . first simple tutorial called guess-the-number i used code described in github provided example https://github.com/chandermani/angular2byexample/tree/master/guessthenumber . it loads fine in browser. intellij setup i'm having issues. intellij returning following error.. seen in screenshot. cannot find module '@angular/core' my properties file follows systemjs.config.js system.config({ map : { 'app': 'app', 'rxjs': 'https://unpkg.com/rxjs@5.0.0-beta.12', '@angular/common': 'https://unpkg.com/@angular/common@2.0.0', '@angular/compiler': 'https://unpkg.com/@angular/compiler@2.0.0', '@angular/core': 'https://unpkg.com/@angular/core@2.0.0', '@angular/platform-browser': 'https://unpkg.com/@angular/platform-browser@2.0.0', '@angular/platform-browser-dynamic': 'https://unpkg.c...
Read more