Advertisement
pexea12

upwork python data extraction project 4 output

Feb 22nd, 2019
259
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.32 KB | None | 0 0
  1. step 1
  2. ['Shree', 'Karthik', 'Engineering', 'TAX', 'INVOICE', '263', '/', '264', ',', 'G', 'I', 'DC', ',', 'Ichchapore', '-', 'Bhatpore', 'Phone', 'No', '.', ':', '+', '919825800890', ',', 'Near', 'GAIL', ',', 'SURAT', '-', '394', '510', '.', 'Email', ':', 'shreekarthikengg', '@', 'gmail', '.', 'com', 'GSTIN', ':', '24ABIFS0267Q1ZO', 'PAN', 'NO', ':', 'ABIFS0267Q', 'Page', '1', 'of', '1', 'TO', ':', 'CONSIGNEE', '(', 'Shipped', 'To', '–', 'Address', 'of', 'Delivery', ')', 'ESSAR', 'STEEL', 'INDIA', 'LIMITED', 'Order', 'No', '.', 'ESTL', '-', 'DTA', '/', 'SCC', '/', '4400116403', '27TH', 'KM', ',', 'SURAT', '-', 'HAZIRA', 'ROAD', '102100', 'Order', 'Date', '26', '/', '09', '/', '2017', '2100', 'HAZIRA', ',', 'SURAT', 'Invoice', 'No', '.', '1819960', 'SUART', 'GUJARAT', '394270', 'Invoice', 'Date', '25', '/', '12', '/', '2018', 'GSTIN', 'NO', ':', '24AAACE1741P1ZN', 'PAN', 'NO', ':', 'AAACE1741P', 'Vendor', 'Code', '102100', 'SAC', 'Code', 'MAINTENANCE', 'AND', 'REPAIR', 'SERVICES', 'OF', 'PLACE', 'OF', 'SUPPLY', 'STATE', 'CODE', 'ORIGINAL', 'FOR', '098717', 'COMMERCIAL', 'AND', 'INDUSTRIAL', 'MACHINERY', '|', 'HAZIRA', '.', 'SURAT', '|', '24', 'GUJARATI', 'RECIPIENT', 'Sr', '.', 'Rate', 'Per', 'Description', 'Unit', 'Qty', 'Amount', 'No', '.', ':', 'Unit', 'GATE', 'PASS', 'NO', ':', '2100026882', 'DATE', ':', '28', '/', '09', '/', '2017', 'CHALLAN', 'NO', ':', '8593', 'DATE', ':', '25', '/', '12', '/', '2018', '300146434', ':', 'MOTOR', ',', 'DC', ',', '18', '.', '50', 'KW', ',', '440', 'NO', '|', '56', ',', '255', '.', '00', '|', '.', '1', 'VOLTS', '56', ',', '255', '.', '00', 'BillAmount', '(', '+', ')', '56', ',', '255', '.', '00', 'CGST', '@', '9', '%', '5', ',', '062', '.', '95', '(', '+', ')', 'SGST', '@', '9', '%', '5', ',', '062', '.', '95', 'RUPEES', 'SIXTY', 'SIX', 'THOUSAND', 'THREE', 'HUNDRED', 'EIGHTY', 'AND', 'Total', 'Tax', '10', ',', '125', '.', '90', 'NINETY', 'PAISE', 'ONLY', 'Net', 'Amount', '66', ',', '380', '.', '90', '5000281327', '2', '19', '-', '0150449', '-', '118', 'N2000HZ', 'TAX', 'CODE', 'N3', 'bow', 'ITG', 'ELIGIBLE', 'ITC', 'MOT', 'ELIGIBLE', 'GST', 'PAYABLE', 'GST', 'EXEMPTED', 'LAND', 'biko', 'Reverse', 'Charge', '(', 'Yes', '/', 'No', '-', ')', ':', 'No', 'Shree', 'Karthik', 'Engineering', 'E', '&', 'O', 'E', 'Subject', 'to', 'SURAT', 'Jurisdiction', 'U', 'Surat', 'Authorised', 'Signatory', 'w', 'Rewinding', ',', 'Overhauling', ',', 'Repairing', 'of', 'all', 'types', 'of', 'HT', 'wwwwww', '&', 'LT', 'AC', '/', 'DC', 'Motors', ',', 'Generators', ',', 'Transformers', ',', 'Rectifiers', ',', 'Electrical', '&', 'Mechanical', 'Jobs', 'etc', 'WWW', '.', 'Tinicly', 'completion', 'of', 'work', 'with', 'best', 'quality', 'of', 'workman', '-', 'ship', '.', 'Maintaining', 'highest', 'safety', 'standards', '&', 'utilization', 'of', 'best', 'quality', 'materials', '.', 'Service', 'is', 'our', 'Motto']
  3.  
  4. step 2
  5. 125 ['Shree', 'Karthik', 'Engineering']
  6. 145 ['TAX', 'INVOICE']
  7. 245 ['263 / 264 ,', 'G', 'I', 'DC', ',', 'Ichchapore - Bhatpore', 'Phone', 'No . ', ' +', '919825800890']
  8. 252 [',']
  9. 316 ['Near GAIL', ',', 'SURAT', '-', '394', '510 .']
  10. 324 ['Email', '', '', 'shreekarthikengg', '@', 'gmail .']
  11. 331 ['com']
  12. 394 ['GSTIN', '', '', '24ABIFS0267Q1ZO']
  13. 462 ['PAN', 'NO', '', '', 'ABIFS0267Q']
  14. 475 ['Page', '1', 'of', '1']
  15. 565 ['TO', '', '', 'CONSIGNEE', '( Shipped', 'To', '–', 'Address']
  16. 573 ['of', 'Delivery )']
  17. 632 ['ESSAR', 'STEEL', 'INDIA', 'LIMITED']
  18. 648 ['Order', 'No .', 'ESTL - DTA / SCC / 4400116403']
  19. 698 ['27TH', 'KM', ', SURAT']
  20. 706 ['- HAZIRA', 'ROAD']
  21. 714 ['102100', 'Order', 'Date', '26', '/ 09 / 2017']
  22. 743 ['2100']
  23. 776 ['HAZIRA , SURAT']
  24. 791 ['Invoice', 'No .', '1819960']
  25. 846 ['SUART GUJARAT', '394270']
  26. 859 ['Invoice', 'Date', '25 / 12 / 2018']
  27. 912 ['GSTIN', 'NO', '', ' 24AAACE1741P1ZN', 'PAN']
  28. 919 ['NO', '', ' AAACE1741P']
  29. 933 ['Vendor', 'Code', '102100']
  30. 1024 ['SAC', 'Code', 'MAINTENANCE', 'AND', 'REPAIR', 'SERVICES']
  31. 1032 ['OF', 'PLACE', 'OF', 'SUPPLY', 'STATE', 'CODE', 'ORIGINAL']
  32. 1040 ['FOR']
  33. 1064 ['098717', 'COMMERCIAL']
  34. 1072 ['AND', 'INDUSTRIAL MACHINERY']
  35. 1080 ['|', 'HAZIRA .', 'SURAT']
  36. 1087 ['|', '24', 'GUJARATI', 'RECIPIENT']
  37. 1193 ['Sr']
  38. 1200 ['.']
  39. 1214 ['Rate', 'Per']
  40. 1227 ['Description', 'Unit']
  41. 1236 ['Qty', 'Amount']
  42. 1243 ['No .', '', '']
  43. 1263 ['Unit']
  44. 1316 ['GATE', 'PASS', 'NO', '', ' 2100026882', 'DATE']
  45. 1323 ['', '', '28 / 09 / 2017']
  46. 1376 ['CHALLAN', 'NO ', '', '8593', 'DATE']
  47. 1383 ['', '', '25 / 12 / 2018']
  48. 1429 ['300146434', '', ' MOTOR ,', 'DC ,', '18 . 50', 'KW', ', 440', 'NO', '|', '56 , 255 . 00', '|', '.', '1']
  49. 1436 ['VOLTS', '56 , 255']
  50. 1443 ['. 00']
  51. 1535 ['BillAmount', '( + )', '56 , 255 . 00']
  52. 1609 ['CGST', '@', '9', '%', '5 , 062 . 95']
  53. 1616 ['(', '+']
  54. 1625 [')']
  55. 1678 ['SGST', '@', '9', '%', '5 , 062 . 95']
  56. 1729 ['RUPEES', 'SIXTY', 'SIX', 'THOUSAND', 'THREE']
  57. 1736 ['HUNDRED', 'EIGHTY', 'AND', 'Total']
  58. 1743 ['Tax', '10 , 125 . 90']
  59. 1781 ['NINETY', 'PAISE', 'ONLY']
  60. 1807 ['Net Amount']
  61. 1820 ['66 , 380 . 90']
  62. 2244 ['5000281327']
  63. 2406 ['2']
  64. 2520 ['19 - 0150449']
  65. 2529 ['-']
  66. 2537 ['118']
  67. 2555 ['N2000HZ']
  68. 2604 ['TAX', 'CODE']
  69. 2611 ['N3', 'bow']
  70. 2637 ['ITG MOT', 'ELIGIBLE ELIGIBLE']
  71. 2673 ['ITC GST']
  72. 2710 ['PAYABLE']
  73. 2744 ['GST', 'EXEMPTED']
  74. 2786 ['LAND']
  75. 2968 ['biko']
  76. 2998 ['Reverse', 'Charge', '( Yes / No', '-']
  77. 3005 [')', '', ' No', 'Shree']
  78. 3012 ['Karthik', 'Engineering']
  79. 3041 ['E', '&', 'O', 'E', 'Subject', 'to', 'SURAT', 'Jurisdiction']
  80. 3079 ['U', 'Surat']
  81. 3201 ['Authorised', 'Signatory']
  82. 3236 ['w']
  83. 3245 ['Rewinding , Overhauling , Repairing', 'of', 'all', 'types of HT', 'wwwwww']
  84. 3252 ['&', 'LT AC / DC Motors , Generators , Transformers , Rectifiers']
  85. 3259 [', Electrical', '&', 'Mechanical', 'Jobs', 'etc WWW .']
  86. 3287 ['Tinicly', 'completion', 'of work', 'with', 'best', 'quality', 'of workman']
  87. 3294 ['- ship . Maintaining highest', 'safety', 'standards &', 'utilization']
  88. 3301 ['of best', 'quality materials .']
  89. 3348 ['Service', 'is', 'our', 'Motto']
  90.  
  91. requesting...
  92. step 3
  93. 125 ['Shree', 'Karthik', 'Engineering']
  94. 145 ['TAX', 'INVOICE']
  95. 245 ['263 / 264 ,', 'G', 'I', 'DC', ',', 'Ichchapore - Bhatpore', 'Phone', 'No . ', ' +', '919825800890']
  96. 252 [',']
  97. 316 ['Near GAIL', ',', 'SURAT', '-', '394', '510 .']
  98. 324 ['Email', '', '', 'shreekarthikengg', '@', 'gmail .']
  99. 331 ['com']
  100. 394 ['GSTIN', '', '', '24ABIFS0267Q1ZO']
  101. 462 ['PAN', 'NO', '', '', 'ABIFS0267Q']
  102. 475 ['Page', '1', 'of', '1']
  103. 565 ['TO', '', '', 'CONSIGNEE', '( Shipped', 'To', '–', 'Address']
  104. 573 ['of', 'Delivery )']
  105. 632 ['ESSAR', 'STEEL', 'INDIA', 'LIMITED']
  106. 648 ['Order', 'No .', 'ESTL - DTA / SCC / 4400116403']
  107. 698 ['27TH', 'KM', ', SURAT']
  108. 706 ['HAZIRA', 'ROAD']
  109. 714 ['102100', 'Order', 'Date', '26', '/ 09 / 2017']
  110. 743 ['2100']
  111. 776 ['HAZIRA']
  112. 791 ['Invoice', 'No .', '1819960']
  113. 846 ['SUART GUJARAT', '394270']
  114. 859 ['Invoice', 'Date', '25 / 12 / 2018']
  115. 912 ['GSTIN', 'NO', '', ' 24AAACE1741P1ZN', 'PAN']
  116. 919 ['NO', '', ' AAACE1741P']
  117. 933 ['Vendor', 'Code', '102100']
  118. 1024 ['SAC', 'Code', 'MAINTENANCE', 'AND', 'REPAIR', 'SERVICES']
  119. 1032 ['OF', 'PLACE', 'OF', 'SUPPLY', 'STATE', 'CODE', 'ORIGINAL']
  120. 1040 ['FOR']
  121. 1064 ['098717', 'COMMERCIAL']
  122. 1072 ['AND', 'INDUSTRIAL MACHINERY']
  123. 1080 ['|', 'HAZIRA', 'SURAT']
  124. 1087 ['|', '24', 'GUJARATI', 'RECIPIENT']
  125. 1193 ['Sr']
  126. 1200 ['.']
  127. 1214 ['Rate', 'Per']
  128. 1227 ['Description', 'Unit']
  129. 1236 ['Qty', 'Amount']
  130. 1243 ['No .', '', '']
  131. 1263 ['Unit']
  132. 1316 ['GATE', 'PASS', 'NO', '', ' 2100026882', 'DATE']
  133. 1323 ['', '', '28 / 09 / 2017']
  134. 1376 ['CHALLAN', 'NO ', '', '8593', 'DATE']
  135. 1383 ['', '', '25 / 12 / 2018']
  136. 1429 ['300146434', '', ' MOTOR ,', 'DC ,', '18 . 50', 'KW', ', 440', 'NO', '|', '56 , 255 . 00', '|', '.', '1']
  137. 1436 ['VOLTS', '56 , 255']
  138. 1443 ['. 00']
  139. 1535 ['BillAmount', '( + )', '56 , 255 . 00']
  140. 1609 ['CGST', '@', '9', '%', '5 , 062 . 95']
  141. 1616 ['(', '+']
  142. 1625 [')']
  143. 1678 ['SGST', '@', '9', '%', '5 , 062 . 95']
  144. 1729 ['RUPEES', 'SIXTY', 'SIX', 'THOUSAND', 'THREE']
  145. 1736 ['HUNDRED', 'EIGHTY', 'AND', 'Total']
  146. 1743 ['Tax', '10 , 125 . 90']
  147. 1781 ['NINETY', 'PAISE', 'ONLY']
  148. 1807 ['Net Amount']
  149. 1820 ['66 , 380 . 90']
  150. 2244 ['5000281327']
  151. 2406 ['2']
  152. 2520 ['19 - 0150449']
  153. 2529 ['-']
  154. 2537 ['118']
  155. 2555 ['N2000HZ']
  156. 2604 ['TAX', 'CODE']
  157. 2611 ['N3', 'bow']
  158. 2637 ['ITG MOT', 'ELIGIBLE ELIGIBLE']
  159. 2673 ['ITC GST']
  160. 2710 ['PAYABLE']
  161. 2744 ['GST', 'EXEMPTED']
  162. 2786 ['LAND']
  163. 2968 ['biko']
  164. 2998 ['Reverse', 'Charge', '( Yes / No', '-']
  165. 3005 [')', '', ' No', 'Shree']
  166. 3012 ['Karthik', 'Engineering']
  167. 3041 ['E', '&', 'O', 'E', 'Subject', 'to', 'SURAT', 'Jurisdiction']
  168. 3079 ['U', 'Surat']
  169. 3201 ['Authorised', 'Signatory']
  170. 3236 ['w']
  171. 3245 ['Rewinding , Overhauling , Repairing', 'of', 'all', 'types of HT', 'wwwwww']
  172. 3252 ['&', 'LT']
  173. 3259 [', Electrical', '&', 'Mechanical', 'Jobs', 'etc WWW .']
  174. 3287 ['Tinicly', 'completion', 'of work', 'with', 'best', 'quality', 'of workman']
  175. 3294 ['- ship . Maintaining highest', 'safety', 'standards &', 'utilization']
  176. 3301 ['of best', 'quality materials .']
  177. 3348 ['Service', 'is', 'our', 'Motto']
  178.  
  179. find info ...
  180. find header title
  181. step 4
  182. {
  183. "items": [
  184. {
  185. "919825800890": "Address",
  186. " +": "\u2013",
  187. "No . ": "To",
  188. "Phone": "( Shipped",
  189. "Ichchapore - Bhatpore": "CONSIGNEE",
  190. ",": "",
  191. "DC": "",
  192. "I": "TO"
  193. }
  194. ],
  195. "Invoice_No": "263 / 264 ,",
  196. "GSTIN": "24ABIFS0267Q1ZO",
  197. "Invoice_Date": "26",
  198. "Vendor_Name": "FOR",
  199. "CGST": "@",
  200. "SGST": "@",
  201. "Total": "10,125.9066,380.9050002813272118"
  202. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement