Advertisement
pexea12

upwork python data extraction output

Feb 18th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 5.10 KB | None | 0 0
  1. File 1
  2.  
  3. [
  4.   {
  5.     "Customer": "SILVER Copper",
  6.     "Entry date": "17.01.19",
  7.     "SO": "2100182639",
  8.     "Item": "10",
  9.     "Product": "HRPO",
  10.     "Grade": "CDRW02",
  11.     "Thick": "1.8",
  12.     "Width": "1250.00",
  13.     "Qty": "40",
  14.     "Proposed_NSR": 52600.0,
  15.     "System_NSR": 54667.0,
  16.     "Diff_Surcharge_Discount_toaddinthesystem": -2067.0
  17.   }
  18. ]
  19.  
  20.  
  21. File 2
  22.  
  23. [
  24.   {
  25.     "Customer": "Steel Customer",
  26.     "Entry date": "16.01.2019",
  27.     "SO": "3410058593",
  28.     "Item": "10",
  29.     "Product": "HRCF",
  30.     "Grade": "GENP6",
  31.     "Thick": "2.5",
  32.     "Width": "1050",
  33.     "Qty": "300",
  34.     "Proposed_NSR": 41000.0,
  35.     "System_NSR": 43089.0,
  36.     "Diff_Surcharge_Discount_toaddinthesystem": -2089.0
  37.   },
  38.   {
  39.     "Customer": "Steel Customer",
  40.     "Entry date": "16.01.2019",
  41.     "SO": "3410058593",
  42.     "Item": "20",
  43.     "Product": "HRCF",
  44.     "Grade": "GENP6",
  45.     "Thick": "2.5",
  46.     "Width": "1180",
  47.     "Qty": "300",
  48.     "Proposed_NSR": 41000.0,
  49.     "System_NSR": 43089.0,
  50.     "Diff_Surcharge_Discount_toaddinthesystem": -2089.0
  51.   },
  52.   {
  53.     "Customer": "Steel Customer",
  54.     "Entry date": "16.01.2019",
  55.     "SO": "3410058593",
  56.     "Item": "30",
  57.     "Product": "HRCF",
  58.     "Grade": "GENP6",
  59.     "Thick": "3",
  60.     "Width": "1250",
  61.     "Qty": "100",
  62.     "Proposed_NSR": 41500.0,
  63.     "System_NSR": 43589.0,
  64.     "Diff_Surcharge_Discount_toaddinthesystem": -2089.0
  65.   },
  66.   {
  67.     "Customer": "Steel Customer",
  68.     "Entry date": "16.01.2019",
  69.     "SO": "3410058593",
  70.     "Item": "40",
  71.     "Product": "HRCF",
  72.     "Grade": "GENP6",
  73.     "Thick": "3.15",
  74.     "Width": "1250",
  75.     "Qty": "200",
  76.     "Proposed_NSR": 41000.0,
  77.     "System_NSR": 43589.0,
  78.     "Diff_Surcharge_Discount_toaddinthesystem": -2589.0
  79.   },
  80.   {
  81.     "Customer": "Steel Customer",
  82.     "Entry date": "16.01.2019",
  83.     "SO": "3410058593",
  84.     "Item": "50",
  85.     "Product": "HRCF",
  86.     "Grade": "GENP6",
  87.     "Thick": "3.2",
  88.     "Width": "1250",
  89.     "Qty": "100",
  90.     "Proposed_NSR": 41000.0,
  91.     "System_NSR": 43589.0,
  92.     "Diff_Surcharge_Discount_toaddinthesystem": -2589.0
  93.   },
  94.   {
  95.     "Customer": "Steel Customer",
  96.     "Entry date": "16.01.2019",
  97.     "SO": "3410058593",
  98.     "Item": "60",
  99.     "Product": "HRCF",
  100.     "Grade": "GENP6",
  101.     "Thick": "3.5",
  102.     "Width": "1250",
  103.     "Qty": "100",
  104.     "Proposed_NSR": 41000.0,
  105.     "System_NSR": 42989.0,
  106.     "Diff_Surcharge_Discount_toaddinthesystem": -1989.0
  107.   },
  108.   {
  109.     "Customer": "Steel Customer",
  110.     "Entry date": "16.01.2019",
  111.     "SO": "3410058593",
  112.     "Item": "70",
  113.     "Product": "HRCF",
  114.     "Grade": "GENP6",
  115.     "Thick": "4",
  116.     "Width": "1250",
  117.     "Qty": "100",
  118.     "Proposed_NSR": 41000.0,
  119.     "System_NSR": 42989.0,
  120.     "Diff_Surcharge_Discount_toaddinthesystem": -1989.0
  121.   },
  122.   {
  123.     "Customer": "Steel Customer",
  124.     "Entry date": "16.01.2019",
  125.     "SO": "3410058593",
  126.     "Item": "80",
  127.     "Product": "HRCF",
  128.     "Grade": "GENP6",
  129.     "Thick": "4",
  130.     "Width": "1830",
  131.     "Qty": "100",
  132.     "Proposed_NSR": 41500.0,
  133.     "System_NSR": 43489.0,
  134.     "Diff_Surcharge_Discount_toaddinthesystem": -1989.0
  135.   },
  136.   {
  137.     "Customer": "Steel Customer",
  138.     "Entry date": "16.01.2019",
  139.     "SO": "3410058593",
  140.     "Item": "90",
  141.     "Product": "HRCF",
  142.     "Grade": "GENP6",
  143.     "Thick": "4.5",
  144.     "Width": "1830",
  145.     "Qty": "100",
  146.     "Proposed_NSR": 41500.0,
  147.     "System_NSR": 43489.0,
  148.     "Diff_Surcharge_Discount_toaddinthesystem": -1989.0
  149.   },
  150.   {
  151.     "Customer": "Steel Customer",
  152.     "Entry date": "16.01.2019",
  153.     "SO": "3410058593",
  154.     "Item": "10",
  155.     "Product": "HRCF",
  156.     "Grade": "GENP6",
  157.     "Thick": "4",
  158.     "Width": "1500",
  159.     "Qty": "50",
  160.     "Proposed_NSR": 41000.0,
  161.     "System_NSR": 43489.0,
  162.     "Diff_Surcharge_Discount_toaddinthesystem": -2489.0
  163.   },
  164.   {
  165.     "Customer": "Steel Customer",
  166.     "Entry date": "16.01.2019",
  167.     "SO": "3410058593",
  168.     "Item": "10",
  169.     "Product": "HRCF",
  170.     "Grade": "GENP6",
  171.     "Thick": "4",
  172.     "Width": "1500",
  173.     "Qty": "50",
  174.     "Proposed_NSR": 41000.0,
  175.     "System_NSR": 43489.0,
  176.     "Diff_Surcharge_Discount_toaddinthesystem": -2489.0
  177.   }
  178. ]
  179.  
  180.  
  181. File 3:
  182.  
  183. [
  184.   {
  185.     "Customer": "Cust-A",
  186.     "Entry date": "31.01.2019",
  187.     "SO": "1.8E+09",
  188.     "Item": "10",
  189.     "Product": "Metal1",
  190.     "Grade": "Grade1",
  191.     "Thick": "0.8",
  192.     "Width": "1250",
  193.     "Qty": "25",
  194.     "Proposed_NSR": 72750.0,
  195.     "System_NSR": 74750.0,
  196.     "Diff_Surcharge_Discount_toaddinthesystem": -2000.0
  197.   },
  198.   {
  199.     "Customer": "Cust-A",
  200.     "Entry date": "31.01.2019",
  201.     "SO": "1.8E+09",
  202.     "Item": "20",
  203.     "Product": "Metal1",
  204.     "Grade": "Grade2",
  205.     "Thick": "1.2",
  206.     "Width": "1250",
  207.     "Qty": "15",
  208.     "Proposed_NSR": 72750.0,
  209.     "System_NSR": 74750.0,
  210.     "Diff_Surcharge_Discount_toaddinthesystem": -2000.0
  211.   },
  212.   {
  213.     "Customer": "Cust-A",
  214.     "Entry date": "31.01.2019",
  215.     "SO": "1.8E+09",
  216.     "Item": "30",
  217.     "Product": "Metal1",
  218.     "Grade": "Grade3",
  219.     "Thick": "1.5",
  220.     "Width": "1250",
  221.     "Qty": "5",
  222.     "Proposed_NSR": 72750.0,
  223.     "System_NSR": 74750.0,
  224.     "Diff_Surcharge_Discount_toaddinthesystem": -2000.0
  225.   }
  226. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement