SHARE
TWEET

Untitled

a guest Jun 18th, 2019 58 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. +------+-----------+---------------+-------------+-------------+
  2. |MTH_ID| store_id  |     brand     |    brndSales|   TotalSales|
  3. +------+-----------+---------------+-------------+-------------+
  4. |201801|      10941|            115|  80890.44900| 135799.66400|
  5. |201712|      10941|            123| 517440.74500| 975893.79000|
  6. |201711|      10941|            99 | 371501.92100| 574223.52300|
  7. |201710|      10941|            115| 552435.57800| 746912.06700|
  8. |201709|      10941|            115|1523492.60700|1871480.06800|
  9. |201708|      10941|            115|1027698.93600|1236544.50900|
  10. |201707|      10941|            33 |1469219.86900|1622949.53000|
  11.      
  12. +------+-----------+---------------+-------------+-------------+
  13. |MTH_ID| store_id  |     brand     |    brndSales|   TotalSales|switchdate
  14. +------+-----------+---------------+-------------+-------------+
  15. |201801|      10941|            115|  80890.44900| 135799.66400| 201712
  16. |201712|      10941|            123| 517440.74500| 975893.79000| 201711
  17. |201711|      10941|            99 | 371501.92100| 574223.52300| 201710
  18. |201710|      10941|            115| 552435.57800| 746912.06700| 201707
  19. |201709|      10941|            115|1523492.60700|1871480.06800| 201707
  20. |201708|      10941|            115|1027698.93600|1236544.50900| 201707
  21. |201707|      10941|            33 |1469219.86900|1622949.53000| 201706
  22.      
  23. val data = Seq((201801,      10941,            115,  80890.44900, 135799.66400),(201712,      10941,            123, 517440.74500, 975893.79000),(201711,      10941,            99 , 371501.92100, 574223.52300),(201710,      10941,            115, 552435.57800, 746912.06700),(201709,      10941,            115,1523492.60700,1871480.06800),(201708,      10941,            115,1027698.93600,1236544.50900),(201707,      10941,            33 ,1469219.86900,1622949.53000)).toDF("MTH_ID", "store_id" ,"brand" ,"brndSales","TotalSales")
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top