python 3.x - Scatter plots from averaging a columns values -


i'm working 2 columns csv file: month_num , freight_in_(tonnes)

i'm attempting plot average value of freight each month 1987 2016. can show each months average freight in, in table format i'm struggling show in scatter plot.

here current code.

from matplotlib import pyplot plt  import pandas pd  df = pd.read_csv('citypairs.csv')  month = df.groupby(['month_num'])['freight_in_(tonnes)'] month.mean()  plt.scatter(df['month_num'], df['freight_in_(tonnes)']) plt.show()

try this: df.groupby(['month_num']).mean().reset_index().plot(kind='scatter',x='month_num',y='freight_in_(tonnes)')


Comments

Post a Comment

Popular posts from this blog

resizing Telegram inline keyboard -

telegram's inline keyboard great feature lots of different use cases. inline buttons added list of items this: inline_keyboard = [[inlinekeyboardbutton(text="button", callback_data="button"), inlinekeyboardbutton(text="reset",callback_data="reset")]] inline_keyboard_markup = inlinekeyboardmarkup(inline_keyboard) update.message.reply_text("hi", reply_markup=inline_keyboard_markup) the above code adds 2 buttons each half width of chat screen. i know the normal keyboard button there resize_keyboard parameter somehow can used. my question is there way resize inline buttons ? example make full width or quarter width. unfortunately, can't now. :( you can suggest @botsupport , might add feature next version.
Read more

javascript - How to bind ViewModel Store to View? -

i'm pretty new ext js , trying embed multiselect inside panel . the viewmodel has stores property can see here: ext.define('test.view.controls.search.searchfiltermodel', { extend: 'ext.app.viewmodel', alias: 'viewmodel.filter', data: { title: '' }, stores: { test: { fields: [ 'id', 'name' ], proxy: { type: 'ajax', url: 'api/test', reader: 'array' }, autoload: true } } }); i bind in view this: viewmodel: { type: 'filter' }, layout: 'fit', border: 1, plain: true, scrollable: 'y', layout: 'fit', bind: { title: '{title}', }, items: { xtype: 'multiselect', scrollable: false, allowblank: true, ddreorder: true, bind: { store: '{test}' }, valuefield: 'id', displayfield: 'name' } ...
Read more

javascript - Solution fails to pass one test with large inputs? -

function birthdaycakecandles(n, ar) { // complete function ar.sort(); var biggestno = ar[(ar.length - 1)]; var total = 0; (var = 0; < ar.length; i++) { if (ar[i] === biggestno) total++; } return total; } here's problem - https://www.hackerrank.com/challenges/birthday-cake-candles/problem there no need sort array, can problem in o(n) times function birthdaycakecandles(arr, n) { var total = 0; var len = arr.length; (var = 0; < len; i++) { if (ar[i] === n) total++; } return total;
Read more