Skip to content

Instantly share code, notes, and snippets.

@mudssrali

mudssrali/pdf-to-csv.py

Created November 23, 2022 04:13
Show Gist options
  • Save mudssrali/6b0991a4370a6b71a984578355df6dfa to your computer and use it in GitHub Desktop.
Save mudssrali/6b0991a4370a6b71a984578355df6dfa to your computer and use it in GitHub Desktop.
Download ZIP
Python script to convert Excel tables from PDF file to CSV
Raw
pdf-to-csv.py
import pandas as pd
from tabula import read_pdf
# Specify file name
FILE_NAME = "sample.pdf"
# Total Pages
TOTAL_PAGES = 2
# Read the first page.
final_frame = read_pdf(FILE_NAME, pages="1")[0]
for page in range(1, TOTAL_PAGES):
data = read_pdf(FILE_NAME, pages=page)[0]
data.columns = final_frame.columns
final_frame = pd.concat([final_frame, data], ignore_index=True)
print("Page", page, "Size", len(final_frame))
# Write final frame (records) to CSV
final_frame.to_csv("output.csv")
# See the output
print(final_frame)
# Log the records length
print("Total Size (in Rows): ", len(final_frame))
@mudssrali
Copy link
Author

Sample PDF: https://mudssrali.keybase.pub/sample.pdf
Output (CSV)

,Seller_Code,Name,Location,City,Profile
0,CNWL1202-7495@SELLER,COLLAR WORLD  PHOTO,COLLEGE ROAD NEAR UNIVERSITY OF NAROWAL TEHDISTT NAROWAL,NAROWAL,Retailer
1,NDIK1203-0422@SELLER,FAINI MOBILE,CITY CENTER OPP BYCO PETROL PUMP CIRCULAR ROAD SHOP NO 8,DERA ISMAIL KHAN,Retailer
2,CGUJ5101-0004@SELLER,al madina bakers,mandiyala road ilyas colony Gujranwala,Gujranwala,Retailer
3,FLQT7201-3417@SELLER,ABID AND ASIF KARYANA STORE,CHAK NO 125 NP NEAR GIRLS MIDDLE SCHOOL,LIAQUATPUR,Retailer
4,CSLT1208-0037@SELLER,Ali Mobile Center,Pasrur road near Hbl bank sialkot,sialkot,Retailer
5,JBD-KB-1058@SELLER,REHMAN CLOTH AND PCO,1Nal Daftar Union Council No 18 Khushab - - -,KHUSHAB,Retailer
6,TMG-MB-1058@SELLER,Zia Mobile center,Main bazar timergara near DHQ hospital District lower dir,Tamargara,Retailer
7,SKHI1232-0626@SELLER,ABDUL AHAD COMM,SHOP NO 5 GULSHAN E JAMAL KARACHI,KARACHI,Retailer
8,OGH-9032@SELLER,Al hadi mobile shop,shop number 3 tobbaco compani oghi road bher kund,mansehra,Covid19 Retailer
9,SGD-04-4532@SELLER,HAFIZ KARYANA STORE,FAISALABAD ROAD MADNI TOWN NEAR MADNI MASJID SARGODHA,SARGODHA,Retailer
10,SKNS7201-0417@SELLER,RAJA MEDICAL STORE,MAIN ROAD KNSHAH - - -,KHAIRPUR NATHAN SHAH,Retailer
11,NSWB1201-0679@SELLER,REHMAN FLOWER NURSERY,ZAKORI TOWN DRABAN ROAD---DERA ISMAIL KHAN G.P.O.near draban  road zak - - -,SAWABI,Retailer
12,SELF-SKR-066@SELLER,CHOUHAN COMMUNICATION,CITY POINT BYEPASS BACHAL SHAH MIYAN NEAR ASKARI PARK SHOP NO  05,SUKKUR,Covid19 Retailer
13,TNK-DR-0001@SELLER,AL TAWAKAL MOBILES,MAIN BAZAR - - -,TANK,Retailer
14,COKR1202-JHU-001@SELLER,SIDDIQUE KARYANA STORE,CHAK JHUJIAN HAMOON POST OFFICE MANDI AHMAD ABAD TEHSIL DEPALPURDISTTOKARA,DEPALPUR,Retailer
15,NABT1203-1929@SELLER,MOBILE SPOT,FOWARA CHOWK ABBOTABAD - - -,ABBOTABAD,Retailer
16,SKOT1103@SELLER,NAQEEBIA COMMUNICATION,SHOP NO 4  AMEER COMPLEX NEAR TELENOR MICRO FINANCE BANK ALLAH WALA CHOWK KOTRI,KOTRI,Franchise
17,ORO-SB-0139@SELLER,RUZWAN GENERAL STORE,RUZWAN GENERAL STORE AND MOBILE COMMUNICATION Alnoor Sugar Mill Area - - -,MORO,Retailer
18,NTOP1101-BD-204@SELLER,BISMILALLAH BOOK CENTER,BISMILALLAH BOOK CENTER MAIN BAZAR TOPI TEH TOPI DISTRICT SWABI,TOPI,Retailer
19,NSWB1201-2129@SELLER,SAAD GENeRAL STORE,SAAD GENRAL STORE JANAK BANDA SALEEM KHAN - - -,Swabi,Retailer
20,NABT5201-BD-020@SELLER,fahad mobile shop,NEAR GGHS DHAMTOUR ABBOTTABAD,abbottabad,Retailer
21,NATT1202-1930@SELLER,MUZAMIL GENERAL STORE,VILLAGE MIRZA ATTOCK - - -,Attock,Blocked Retailer
22,LAR-VR-1033@SELLER,ABDUL GHAFAR COMMUNICATION,MAIN ROAD LASHARI THOOF CHOUSAL - - -,LARKANA,Retailer
23,HDD-HS-426@SELLER,LUCKY GENERAL STORE,Near Tayyaba Masjid Block No- B2Latifabad Unit No- 8 - - -,HYDERABAD,Retailer
24,SLT-CT-0706@SELLER,KHOKHAR BOOK AND GENERAL STORE,VILLAGE AND PO DALOWALI SIALKOT - - -,SIALKOT,Retailer
25,BDN-BN-0019@SELLER,MASHALLAH COMMUNICATIONS,Main Chowk Kaghan Road Badin - - -,BADIN,Retailer
26,BHL-MU-0067@SELLER,SIALVI COLD DRINK,SARDAR ALAM COLONY DAKHANA ALAM ABAD NAZD PHALIA GAT,PHULARWAN,Retailer
27,SSKZ1202-0673@SELLER,LUCKY MOBILE CHAK,CHAK DIST SHIKARPUR -- - -,Shikarpur,Retailer
28,FSD-TP-3076@SELLER,JUNAID MAJID ELECTRIC STORE,P 267 SANTSINGH ROAD AHMAD ABAD NEAR CRESCENT BREAD,FAISALABAD,Retailer
29,CSWL-YR-8313@SELLER,AL MADINA GENERAL STORE,NEAR JAMIA MASJID CHAK NO 97/6R SAHIWAL,SAHIWAL,Retailer
30,FBKR-RR-175@SELLER,AL RAFI MOBILE,GHARBI BAZAR BHAKKAR - - -,Bhakkar,Blocked Retailer
31,LHR-SA-5173@SELLER,PRINCE MOBILE,SHOP  5 SUI GAS CHOWK SHAHDARA LAHORE,LAHORE,Retailer
32,ISB-BKU-1717@SELLER,Jani Mobie,MAIN ZIA MASJID ISLAMABAD - - -,ISLAMABAD,Retailer
33,FJNG4206-024@SELLER,CHISHTY MOBILE 1,AWAIS CHOKE NEAR GOOL MASJID OPPOSED GIRLS COLLEGE S-TOWN JHANG,JHANG,Retailer
34,FJAN1201-4865@SELLER,Friends Mobiles,chak no 102/10.R jahanian,jahanian,Retailer
35,FFSD1204-0492@SELLER,ADEEL BOOK DEEPOT,ADEEL BOOK DEEPOT MAIN JHANG RD CHAK 275 ADDA PANSRA FAIOSALBAD - - -,FAISALABAD,Retailer
36,ISB-TPL-002@SELLER,HIGHWAY FUEL FILLING STATION,PLOT NO 1  OPPOSITE FAZAIA COLONY NEAR KHANA EAST ISLAMABAD EXPRESSWAY,ISLAMABAD,Fuel Retailer
37,OHT-HR-0276@SELLER,OSAMA MOBILES,Main Bazar Seni Gumbat Near Ubl Bankseni Gumbat,KOHAT,Retailer
38,RWP-KP-104@SELLER,Halla Fresh Milk Centre,Shop  13 Aziz Market Near Mangal Bazar I9 Islamabad. - - -,Islamabad,Blocked Retailer
39,RMS-001-000355@SELLER,AFAN STATIONERS,SHOP NO 2 MUBARIK MARKET NEAR BEGUM JAAN HOSPITAL MAIN LEHTHRAR ROAD NEW ABADI ALI PUR,ISLAMABAD,RM Retailer
40,CSRQ1201-0180@SELLER,NOSHAHI MOBILE CENTER,OUT SIDE MALKANA GATE SHAREQ PUR - - -,SHARAQPUR,Retailer
41,SKHI1241-0270@SELLER,Suban Communication,shop no3 sheet no2 meer residency gizri karachi,karachi,Covid19 Retailer
42,NBTK1201-2666@SELLER,IRFAN SUPER STORE,MOH CHINAR KOTO BATKHELA TEHSIL BATKHELA DISTRICT MALAKAND,BATKHELA,Retailer
43,SELF-HYD-088@SELLER,HAMZA COMMUNICATION,SHOP NO 03 NEAR PATHAN COLONY HYDERABAD,HYDERABAD,VIZPRO Retailer
44,RWP-KP-0890@SELLER,MASTER MOBILE AND COMPUTER SHOP,SHOP NO L-G1 JINNAH PLAZA MAIN DOUBLE ROAD MAIN PWD ISLAMABAD,Islamabad,Retailer
45,FCCW-0044@SELLER,PRINCE MOBILE CENTER,HAK NO 1197DR CHICHAWATNI - - -,CHICHA WATNI,Retailer
46,COKR1203-0495@SELLER,PAKISTAN MOBILE AND COMPUTERS,MAIN G.T.ROAD LARI ADDA OKARA,Okara,Retailer
47,PC-CGUJ-578@SELLER,KHALID ELECTRIC STORE,RACE CORSE ROAD WAHADAT COLONY GUJRANWALA - - -,GUJRANWALA,Retailer
48,SKHI1219-4174@SELLER,Bughio communication 2,shop no 1 police chowki lasi goth karachi,Karachi,Retailer
49,RNP-MH-251@SELLER,PAKISTAN COMMUNICATION,Village Sami Near Govt. Hospital Khairpur Mirs - - -,KHAIR PUR MIRS,Retailer
50,RKH-1323@SELLER,MIAN COOLING CENTER,SHOP07MAIN BAZARDARBAR BABA UMRA SHAHMOPALKY,RENALA,Retailer
51,DMSS-KKA-019@SELLER,ALNOOR MEGA MART,ALNOOR MEGA MART KALAM ROAD NEAR FOREST CHECKPOST BAGH DHERAI SWAT,SWAT,Covid19 Retailer
52,COKR1202-40025@SELLER,WASEEM MOBILE,ADDA AHMADABAD TEH DEPALPUR DISSTT OKARA,OKARA,Retailer
53,AGC-001-151392@SELLER,HAJI GENERAL STORE,HAJI GENERAL STORE UNIVERSITY STREET SIKENDARABAD COLONY KOTRI,KOTRI,AGC Retailer
54,NSWB1101-BD-090@SELLER,BILAL STATIONERS GOHATI,AFTAB MARKET SHOP NONO 03 GOHATI PUL TEHSIL AND DISTT SWABI,SWABI,Retailer
55,NABT1203-7457@SELLER,BISMILLAH MOBIE,COLLEGE ROAD MANDIA TEHSIL and DISTRICT ABBOTTABAD,ABBOTTABAD,Retailer
56,NRWP1206-0821@SELLER,Al shoaib Mobile,Gujrat electric store mehrban market dispencry grount tench bhtta rawa,Rawalpindi,Retailer
57,SPR-ST-3027@SELLER,MADINA MOBILE AND GENERAL STORE,MADINA MOBILE AND GENERAL STORE PULL NAHAR JHAWRIAN TEH SHAHPUR DISTT - - -,SHAHPUR,Retailer
58,SLAR1201-0948@SELLER,NK COMMINUCATION,SADAR KALAR CHOWKSHOP NO3 NAUDERO,Ratodero,Retailer
59,SKHI1219-3890@SELLER,Bismillah communication,shop no 1 bahria town near usmania restaurant karachi,karachi,Retailer
60,CKMK1201-3105@SELLER,ALI RAZA MOBILE CENTER,MAIN CHOCK GUMMANWALA P/O KHAS TEHSILE NOSHERA VIRKAN DISTRICT GUJRANWALA,NOSHERA VIRKAN,Retailer
61,CHN-GR-4044@SELLER,ALI UMAR MOBILE SHOP,FAISLABAD ROAD NEAR RASOOL NAGAR OPPOSITE JAMIA MASJID CHINIOT,CHINIOT,Retailer
62,AGC-001-45523@SELLER,ABU TEHAMI EASY PAISA SHOP,SHOP NO 2 SHARBAT ALI MARKET BARRY GHARA TARNAB FARM PESHAWAR,PESHAWAR,AGC Retailer
63,BHL-MU-3102@SELLER,HAMAD FRANCHISE,SULEMAN PURA ROAD.BHALWAL - - -,BHALWAL,Retailer
64,SRIB5201-0156@SELLER,JAN CUSTOMER,MUSA CALONY SARYAB ROAD QUETTA,QUETTA,Retailer
65,FSD-BC-0661@SELLER,BHATTI MOBILES,Chak No 24/Jb Tahseel Jumrah Zila Faislabad - - -,FAISALABAD,Retailer
66,NDIR1101-9935@SELLER,NADEEM MOBILE ZONE,SHOP NO 1 WAZIR MARKET NEAR BANK OF PUNJAB UPPER DIR,Upper Dir,Retailer
67,CGUJ-MT-0110@SELLER,HUSSAIN MOBILE AND DVD,HUSSAIN MOBILE KASHMIR ROAD GUJJAR MARKET - - -,GUJRANWALA,Retailer
68,LHR-SLR-34419@SELLER,IRFAN GENERAL STORE,STREET NO 2 NAJAM PARK SHADI PURA LAHORE,Lahore,Retailer
69,KHN-CR-0963@SELLER,BUTT KARYANA STORE,BISMILLAH CHOWK GT ROAD KHARIAN - - -,KHARIAN,Retailer
70,SSNG-HS-0286@SELLER,Qureshi Fertilizer Agency,VILLAGE NORR MUHAMMAD BHUNWRO - - -,SANGHAR,Retailer
71,FHSP1201-0254@SELLER,NEW AL MADINA COMMUNICATION,ADA JAMAL PUR - - -,HASILPUR,Retailer
72,SRIB1201-0247@SELLER,atif shah pco,saraib road near Baluchistan university,quetta,Covid19 Retailer
73,FFSD1113-439@SELLER,IRFAN G MOBILE,CHAK NUMBER 209 RB TARIWALA CHOWK NEAR FAISAL CENTER FAISALABAD,FAISALABAD,Covid19 Retailer
74,SGD-MI-4040@SELLER,ASIF G/S,MUGHAL MARKET ZAFAR COLONY MAIN ROAD BLOCK-H - - -,SARGODHA,Retailer
75,NDGI1101-0116@SELLER,JAMSHID MOBILE CENTER,SHOP NO 1 KOPER TEHSIL DARGAI DISTRICT MALAKAND,MALAKAND,Retailer
76,TMG-BV-1003@SELLER,WARIS MOBILE CENTER,MAIN BAZAR SHAMSHE KHAN SHOP NO 8 DISTRICT LOWER DIR,TIMERGARA,Retailer
77,FDNY1201-0241@SELLER,ABID BHAI MOBILE SHOP,SHOP NO 2 PULL CHORWAH TEHSIL KEHROR PAKKA,KEHROR PAKKA,Retailer
78,CNWL1202-7495@SELLER,COLLAR WORLD  PHOTO,COLLEGE ROAD NEAR UNIVERSITY OF NAROWAL TEHDISTT NAROWAL,NAROWAL,Retailer
79,NDIK1203-0422@SELLER,FAINI MOBILE,CITY CENTER OPP BYCO PETROL PUMP CIRCULAR ROAD SHOP NO 8,DERA ISMAIL KHAN,Retailer
80,CGUJ5101-0004@SELLER,al madina bakers,mandiyala road ilyas colony Gujranwala,Gujranwala,Retailer
81,FLQT7201-3417@SELLER,ABID AND ASIF KARYANA STORE,CHAK NO 125 NP NEAR GIRLS MIDDLE SCHOOL,LIAQUATPUR,Retailer
82,CSLT1208-0037@SELLER,Ali Mobile Center,Pasrur road near Hbl bank sialkot,sialkot,Retailer
83,JBD-KB-1058@SELLER,REHMAN CLOTH AND PCO,1Nal Daftar Union Council No 18 Khushab - - -,KHUSHAB,Retailer
84,TMG-MB-1058@SELLER,Zia Mobile center,Main bazar timergara near DHQ hospital District lower dir,Tamargara,Retailer
85,SKHI1232-0626@SELLER,ABDUL AHAD COMM,SHOP NO 5 GULSHAN E JAMAL KARACHI,KARACHI,Retailer
86,OGH-9032@SELLER,Al hadi mobile shop,shop number 3 tobbaco compani oghi road bher kund,mansehra,Covid19 Retailer
87,SGD-04-4532@SELLER,HAFIZ KARYANA STORE,FAISALABAD ROAD MADNI TOWN NEAR MADNI MASJID SARGODHA,SARGODHA,Retailer
88,SKNS7201-0417@SELLER,RAJA MEDICAL STORE,MAIN ROAD KNSHAH - - -,KHAIRPUR NATHAN SHAH,Retailer
89,NSWB1201-0679@SELLER,REHMAN FLOWER NURSERY,ZAKORI TOWN DRABAN ROAD---DERA ISMAIL KHAN G.P.O.near draban  road zak - - -,SAWABI,Retailer
90,SELF-SKR-066@SELLER,CHOUHAN COMMUNICATION,CITY POINT BYEPASS BACHAL SHAH MIYAN NEAR ASKARI PARK SHOP NO  05,SUKKUR,Covid19 Retailer
91,TNK-DR-0001@SELLER,AL TAWAKAL MOBILES,MAIN BAZAR - - -,TANK,Retailer
92,COKR1202-JHU-001@SELLER,SIDDIQUE KARYANA STORE,CHAK JHUJIAN HAMOON POST OFFICE MANDI AHMAD ABAD TEHSIL DEPALPURDISTTOKARA,DEPALPUR,Retailer
93,NABT1203-1929@SELLER,MOBILE SPOT,FOWARA CHOWK ABBOTABAD - - -,ABBOTABAD,Retailer
94,SKOT1103@SELLER,NAQEEBIA COMMUNICATION,SHOP NO 4  AMEER COMPLEX NEAR TELENOR MICRO FINANCE BANK ALLAH WALA CHOWK KOTRI,KOTRI,Franchise
95,ORO-SB-0139@SELLER,RUZWAN GENERAL STORE,RUZWAN GENERAL STORE AND MOBILE COMMUNICATION Alnoor Sugar Mill Area - - -,MORO,Retailer
96,NTOP1101-BD-204@SELLER,BISMILALLAH BOOK CENTER,BISMILALLAH BOOK CENTER MAIN BAZAR TOPI TEH TOPI DISTRICT SWABI,TOPI,Retailer
97,NSWB1201-2129@SELLER,SAAD GENeRAL STORE,SAAD GENRAL STORE JANAK BANDA SALEEM KHAN - - -,Swabi,Retailer
98,NABT5201-BD-020@SELLER,fahad mobile shop,NEAR GGHS DHAMTOUR ABBOTTABAD,abbottabad,Retailer
99,NATT1202-1930@SELLER,MUZAMIL GENERAL STORE,VILLAGE MIRZA ATTOCK - - -,Attock,Blocked Retailer
100,LAR-VR-1033@SELLER,ABDUL GHAFAR COMMUNICATION,MAIN ROAD LASHARI THOOF CHOUSAL - - -,LARKANA,Retailer
101,HDD-HS-426@SELLER,LUCKY GENERAL STORE,Near Tayyaba Masjid Block No- B2Latifabad Unit No- 8 - - -,HYDERABAD,Retailer
102,SLT-CT-0706@SELLER,KHOKHAR BOOK AND GENERAL STORE,VILLAGE AND PO DALOWALI SIALKOT - - -,SIALKOT,Retailer
103,BDN-BN-0019@SELLER,MASHALLAH COMMUNICATIONS,Main Chowk Kaghan Road Badin - - -,BADIN,Retailer
104,BHL-MU-0067@SELLER,SIALVI COLD DRINK,SARDAR ALAM COLONY DAKHANA ALAM ABAD NAZD PHALIA GAT,PHULARWAN,Retailer
105,SSKZ1202-0673@SELLER,LUCKY MOBILE CHAK,CHAK DIST SHIKARPUR -- - -,Shikarpur,Retailer
106,FSD-TP-3076@SELLER,JUNAID MAJID ELECTRIC STORE,P 267 SANTSINGH ROAD AHMAD ABAD NEAR CRESCENT BREAD,FAISALABAD,Retailer
107,CSWL-YR-8313@SELLER,AL MADINA GENERAL STORE,NEAR JAMIA MASJID CHAK NO 97/6R SAHIWAL,SAHIWAL,Retailer
108,FBKR-RR-175@SELLER,AL RAFI MOBILE,GHARBI BAZAR BHAKKAR - - -,Bhakkar,Blocked Retailer
109,LHR-SA-5173@SELLER,PRINCE MOBILE,SHOP  5 SUI GAS CHOWK SHAHDARA LAHORE,LAHORE,Retailer
110,ISB-BKU-1717@SELLER,Jani Mobie,MAIN ZIA MASJID ISLAMABAD - - -,ISLAMABAD,Retailer
111,FJNG4206-024@SELLER,CHISHTY MOBILE 1,AWAIS CHOKE NEAR GOOL MASJID OPPOSED GIRLS COLLEGE S-TOWN JHANG,JHANG,Retailer
112,FJAN1201-4865@SELLER,Friends Mobiles,chak no 102/10.R jahanian,jahanian,Retailer
113,FFSD1204-0492@SELLER,ADEEL BOOK DEEPOT,ADEEL BOOK DEEPOT MAIN JHANG RD CHAK 275 ADDA PANSRA FAIOSALBAD - - -,FAISALABAD,Retailer
114,ISB-TPL-002@SELLER,HIGHWAY FUEL FILLING STATION,PLOT NO 1  OPPOSITE FAZAIA COLONY NEAR KHANA EAST ISLAMABAD EXPRESSWAY,ISLAMABAD,Fuel Retailer
115,OHT-HR-0276@SELLER,OSAMA MOBILES,Main Bazar Seni Gumbat Near Ubl Bankseni Gumbat,KOHAT,Retailer
116,RWP-KP-104@SELLER,Halla Fresh Milk Centre,Shop  13 Aziz Market Near Mangal Bazar I9 Islamabad. - - -,Islamabad,Blocked Retailer
117,RMS-001-000355@SELLER,AFAN STATIONERS,SHOP NO 2 MUBARIK MARKET NEAR BEGUM JAAN HOSPITAL MAIN LEHTHRAR ROAD NEW ABADI ALI PUR,ISLAMABAD,RM Retailer
118,CSRQ1201-0180@SELLER,NOSHAHI MOBILE CENTER,OUT SIDE MALKANA GATE SHAREQ PUR - - -,SHARAQPUR,Retailer
119,SKHI1241-0270@SELLER,Suban Communication,shop no3 sheet no2 meer residency gizri karachi,karachi,Covid19 Retailer
120,NBTK1201-2666@SELLER,IRFAN SUPER STORE,MOH CHINAR KOTO BATKHELA TEHSIL BATKHELA DISTRICT MALAKAND,BATKHELA,Retailer
121,SELF-HYD-088@SELLER,HAMZA COMMUNICATION,SHOP NO 03 NEAR PATHAN COLONY HYDERABAD,HYDERABAD,VIZPRO Retailer
122,RWP-KP-0890@SELLER,MASTER MOBILE AND COMPUTER SHOP,SHOP NO L-G1 JINNAH PLAZA MAIN DOUBLE ROAD MAIN PWD ISLAMABAD,Islamabad,Retailer
123,FCCW-0044@SELLER,PRINCE MOBILE CENTER,HAK NO 1197DR CHICHAWATNI - - -,CHICHA WATNI,Retailer
124,COKR1203-0495@SELLER,PAKISTAN MOBILE AND COMPUTERS,MAIN G.T.ROAD LARI ADDA OKARA,Okara,Retailer
125,PC-CGUJ-578@SELLER,KHALID ELECTRIC STORE,RACE CORSE ROAD WAHADAT COLONY GUJRANWALA - - -,GUJRANWALA,Retailer
126,SKHI1219-4174@SELLER,Bughio communication 2,shop no 1 police chowki lasi goth karachi,Karachi,Retailer
127,RNP-MH-251@SELLER,PAKISTAN COMMUNICATION,Village Sami Near Govt. Hospital Khairpur Mirs - - -,KHAIR PUR MIRS,Retailer
128,RKH-1323@SELLER,MIAN COOLING CENTER,SHOP07MAIN BAZARDARBAR BABA UMRA SHAHMOPALKY,RENALA,Retailer
129,DMSS-KKA-019@SELLER,ALNOOR MEGA MART,ALNOOR MEGA MART KALAM ROAD NEAR FOREST CHECKPOST BAGH DHERAI SWAT,SWAT,Covid19 Retailer
130,COKR1202-40025@SELLER,WASEEM MOBILE,ADDA AHMADABAD TEH DEPALPUR DISSTT OKARA,OKARA,Retailer
131,AGC-001-151392@SELLER,HAJI GENERAL STORE,HAJI GENERAL STORE UNIVERSITY STREET SIKENDARABAD COLONY KOTRI,KOTRI,AGC Retailer
132,NSWB1101-BD-090@SELLER,BILAL STATIONERS GOHATI,AFTAB MARKET SHOP NONO 03 GOHATI PUL TEHSIL AND DISTT SWABI,SWABI,Retailer
133,NABT1203-7457@SELLER,BISMILLAH MOBIE,COLLEGE ROAD MANDIA TEHSIL and DISTRICT ABBOTTABAD,ABBOTTABAD,Retailer
134,NRWP1206-0821@SELLER,Al shoaib Mobile,Gujrat electric store mehrban market dispencry grount tench bhtta rawa,Rawalpindi,Retailer
135,SPR-ST-3027@SELLER,MADINA MOBILE AND GENERAL STORE,MADINA MOBILE AND GENERAL STORE PULL NAHAR JHAWRIAN TEH SHAHPUR DISTT - - -,SHAHPUR,Retailer
136,SLAR1201-0948@SELLER,NK COMMINUCATION,SADAR KALAR CHOWKSHOP NO3 NAUDERO,Ratodero,Retailer
137,SKHI1219-3890@SELLER,Bismillah communication,shop no 1 bahria town near usmania restaurant karachi,karachi,Retailer
138,CKMK1201-3105@SELLER,ALI RAZA MOBILE CENTER,MAIN CHOCK GUMMANWALA P/O KHAS TEHSILE NOSHERA VIRKAN DISTRICT GUJRANWALA,NOSHERA VIRKAN,Retailer
139,CHN-GR-4044@SELLER,ALI UMAR MOBILE SHOP,FAISLABAD ROAD NEAR RASOOL NAGAR OPPOSITE JAMIA MASJID CHINIOT,CHINIOT,Retailer
140,AGC-001-45523@SELLER,ABU TEHAMI EASY PAISA SHOP,SHOP NO 2 SHARBAT ALI MARKET BARRY GHARA TARNAB FARM PESHAWAR,PESHAWAR,AGC Retailer
141,BHL-MU-3102@SELLER,HAMAD FRANCHISE,SULEMAN PURA ROAD.BHALWAL - - -,BHALWAL,Retailer
142,SRIB5201-0156@SELLER,JAN CUSTOMER,MUSA CALONY SARYAB ROAD QUETTA,QUETTA,Retailer
143,FSD-BC-0661@SELLER,BHATTI MOBILES,Chak No 24/Jb Tahseel Jumrah Zila Faislabad - - -,FAISALABAD,Retailer
144,NDIR1101-9935@SELLER,NADEEM MOBILE ZONE,SHOP NO 1 WAZIR MARKET NEAR BANK OF PUNJAB UPPER DIR,Upper Dir,Retailer
145,CGUJ-MT-0110@SELLER,HUSSAIN MOBILE AND DVD,HUSSAIN MOBILE KASHMIR ROAD GUJJAR MARKET - - -,GUJRANWALA,Retailer
146,LHR-SLR-34419@SELLER,IRFAN GENERAL STORE,STREET NO 2 NAJAM PARK SHADI PURA LAHORE,Lahore,Retailer
147,KHN-CR-0963@SELLER,BUTT KARYANA STORE,BISMILLAH CHOWK GT ROAD KHARIAN - - -,KHARIAN,Retailer
148,SSNG-HS-0286@SELLER,Qureshi Fertilizer Agency,VILLAGE NORR MUHAMMAD BHUNWRO - - -,SANGHAR,Retailer
149,FHSP1201-0254@SELLER,NEW AL MADINA COMMUNICATION,ADA JAMAL PUR - - -,HASILPUR,Retailer
150,SRIB1201-0247@SELLER,atif shah pco,saraib road near Baluchistan university,quetta,Covid19 Retailer
151,FFSD1113-439@SELLER,IRFAN G MOBILE,CHAK NUMBER 209 RB TARIWALA CHOWK NEAR FAISAL CENTER FAISALABAD,FAISALABAD,Covid19 Retailer
152,SGD-MI-4040@SELLER,ASIF G/S,MUGHAL MARKET ZAFAR COLONY MAIN ROAD BLOCK-H - - -,SARGODHA,Retailer
153,NDGI1101-0116@SELLER,JAMSHID MOBILE CENTER,SHOP NO 1 KOPER TEHSIL DARGAI DISTRICT MALAKAND,MALAKAND,Retailer
154,TMG-BV-1003@SELLER,WARIS MOBILE CENTER,MAIN BAZAR SHAMSHE KHAN SHOP NO 8 DISTRICT LOWER DIR,TIMERGARA,Retailer
155,FDNY1201-0241@SELLER,ABID BHAI MOBILE SHOP,SHOP NO 2 PULL CHORWAH TEHSIL KEHROR PAKKA,KEHROR PAKKA,Retailer

@mudssrali
Copy link
Author

To run the script, install following packages

pandas
tabula-py

Then, run

python pdf-to-csv.py

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment