Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas
- data = pandas.DataFrame({'Local':['são paulo','rio','bahia'], '01/09/2007': [1,2,0], '01/10/2007': [0,1,0], '01/11/2007': [2,1,1], '01/12/2007': [2,0,3], '01/01/2008': [0,1,1], 'contato':['2345-1244','5422-1244','2345-8674']})
- data = pandas.melt(data.reset_index(), id_vars=['Local', 'contato'],
- var_name='mes', value_name='quantidade').sort(['Local','quantidade'], ascending=False)
- data = data[data.mes.str.contains("index") == False]
Add Comment
Please, Sign In to add comment