Advertisement
Guest User

mesto stariot

a guest
Jun 28th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.01 KB | None | 0 0
  1. import reading as rd
  2. import numpy as np
  3. import pandas as pd
  4. import time
  5. semana3= rd.get_train(3)
  6. semana4 = rd.get_train(4)
  7. semana5 = rd.get_train(5)
  8. train = semana3.append(semana4)
  9. train = train.append(semana5)
  10. del semana3
  11. del semana4
  12. del semana5
  13. semana6 = rd.get_train(6)
  14. semana7 = rd.get_train(7)
  15. semana8 = rd.get_train(8)
  16. train = train.append(semana6)
  17. del semana6
  18. semana9 = rd.get_train(9)
  19. train =train.append(semana7)
  20. del semana7
  21. train =train.append(semana8)
  22. del semana8
  23. train = train.append(semana9)
  24. del semana9
  25. #ovde go imame train
  26. product_client = train[['Producto_ID','Cliente_ID','Demanda_uni_equil']]
  27. del train
  28. product_client = product_client.groupby(['Producto_ID','Cliente_ID']).median()
  29. product_client = product_client.reset_index()
  30. print "Ovde 1"
  31. test = rd.get_test()
  32. print "OVde 2"
  33. test = test[['id','Producto_ID','Cliente_ID']]
  34. izlez = pd.merge(left=test,right=product_client,how='left',on=['Producto_ID','Cliente_ID'])
  35. izlez = izlez.fillna('3')
  36. print test
  37. izlez.to_csv('out.csv')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement