python - Plotting pandas groupby -

-

i have dataframe car data - structure pretty simple. have id, year of production, kilometers, price , fuel type (petrol/diesel).

in [106]: stack.head()  out[106]:     year    km      price   fuel 0   2003    165.286 2.350   petrol 1   2005    195.678 3.350   diesel 2   2002    125.262 2.450   petrol 3   2002    161.000 1.999   petrol 4   2002    164.851 2.599   diesel

i trying produce chart pylab/matplotlib x-axis year , then, using groupby, have 2 plots (one each fuel type) averages year (mean function) price , km.

any appreciated.

maybe there's more straight way it, following. first groupby , take means price:

meanprice = df.groupby(['year','fuel'])['price'].mean().reset_index()

and km:

meankm = df.groupby(['year','fuel'])['km'].mean().reset_index()

then merge 2 resulting dataframes data in one:

d = pd.merge(meanprice,meankm,on=['year','fuel']).set_index('year')

setting index year ley things easy while plotting pandas. resulting dataframe is:

        fuel   price       km year                          2002  diesel  2.5990  164.851 2002  petrol  2.2245  143.131 2003  petrol  2.3500  165.286 2005  diesel  3.3500  195.678

at end can plot filtering fuel:

d[d['fuel']=='diesel'].plot(kind='bar')  d[d['fuel']=='petrol'].plot(kind='bar')

obtaining like:

enter image description here

enter image description here

i don't know if kind of plot expected, can modify them kind keyword. hope helps.


Comments

Post a Comment

Popular posts from this blog

c - How to retrieve a variable from the Apache configuration inside the module? -

-
i'm building custom apache module. how retrieve variable apache configuration inside module? see variable "some_var_config_from_apache_or_htaacess" inside apache module: /* source: http://people.apache.org/~humbedooh/mods/examples/mod_example_1.c */ /* include required headers httpd */ #include "httpd.h" #include "http_core.h" #include "http_protocol.h" #include "http_request.h" static void register_hooks(apr_pool_t *pool); static int example_handler(request_rec *r); /* define our module entity , assign function registering hooks */ module ap_module_declare_data example_module = { standard20_module_stuff, null, // per-directory configuration handler null, // merge handler per-directory configurations null, // per-server configuration handler null, // merge handler per-server configurations null, // directives may have httpd register_hoo
Read more

c# - Constructor arguments cannot be passed for interface mocks -

-
when debug code , read line mocklessonplannerafactory creation error: constructor arguments cannot passed interface mocks. var mockschoolclasscodeservice = new mock<ischoolclasscodeservice>(); var mockdateservice = new mock<idateservice>(); var mocklessonplannerafactory = new mock<ilessonplannerafactory>(mockdateservice.object); var mocklessonplannerbfactory = new mock<ilessonplannerbfactory>(mockdateservice.object); var service = new timetableservice(mockunitofwork.object, mocklessonplannerafactory.object, mocklessonplannerbfactory.object, mockschoolclasscodeservice.object); my timetableservice accepts instances of interface type only. mocklessonplannerafactory , bfactory... want in constructor idateservice passed. what wrong code? the clue in error message "constructor arguments cannot passed interface mocks." the mock created interface have default constructor because interfaces don't have constructor. remember mockin
Read more

python - malformed header from script index.py Bad header -

-
i want run python code in apache2(ubuntu 14.04) server. have followed these steps , getting error: step 1: configuration 1: have created directory , file under /var/www/cgi-bin configuration 2 : have edited /etc/apache2/sites-available/000-default.conf alias /cgi-bin /var/www/cgi-bin <directory "/var/www/cgi-bin"> options indexes followsymlinks execcgi addhandler cgi-script .cgi .py allow </directory> <directory /var/www/cgi-bin> options </directory> step 2: and python script is: index.py #!/usr/bin/env python import cgi; import cgitb;cgitb.enable() print "content-type: text/plain\n" print "<b>hello python</b>" step 3: when ran through chrome browser using: url : http://localhost/cgi-bin/index.py step 4: i getting error in error-log malformed header script 'index.py': bad header: hello python you should end header \r\n, must print out yet \r\n signal body coming. (i
Read more