Sure, you can use tools such as Adobe Acrobat to convert PDF statements to csv\/xls files. This is a simple approach that you might be able to use when you do not have access to any such tools.<\/p>\n
How can this help? If you were trying to calculate based on the transactions. One application can be calculating your business or personal expenses. Also, if you are writing a tax or financial software, similar can be useful. For sure, tools and programming languages are available to read PDF files directly than the approach I mentioned here.<\/p>\n
Steps:<\/strong><\/p>\n Download the statement. Sample Transaction Data<\/strong> Note:<\/strong> DEC 21 DEC 24 PAYMENT – THANK YOU \/ PAIEMENT – MERCI The Code:<\/strong> # In[5]:<\/p>\n file = open(‘dec2018-jan2019.txt’,’r’);<\/p>\n import os.path # open the file for reading # In[6]:<\/p>\n fileContent = file.read() # In[ ]:<\/p>\n #f = open("dec2018-jan2019.out.txt", "a"); # In[3]:<\/p>\n one_line = ”; if (count % 3 == 1): if (count % 3 == 2): if (count % 3 == 0): #print(count); if (count % 3 == 0): #print(‘–‘);<\/p>\n f.close();<\/p>\n # In[ ]:<\/p>\n *** ***. *** *** . *** *** . *** . *** . *** Blog<\/strong>: http:\/\/Bangla.SaLearningSchool.com<\/a>, http:\/\/SitesTree.com<\/a><\/em> Facebook Groups\/Forums to discuss (Q & A): <\/strong><\/em> Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. <\/em>http:\/\/sitestree.com\/training\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" Sure, you can use tools such as Adobe Acrobat to convert PDF statements to csv\/xls files. This is a simple approach that you might be able to use when you do not have access to any such tools. How can this help? If you were trying to calculate based on the transactions. One application can … <\/p>\n
\nCopy the text (only the transactions) into a text file
\nThe use the code provided here or similar to read the text file and create a CSV file
\nYou can write another Python code to merge multiple csv files
\nUsing the combined CSV file, you can calculate your yearly categorized expenses or similar : for example<\/p>\n
\n‘DEC 21 DEC 24 PAYMENT – THANK YOU \/ PAIEMENT – MERCI\\n75105398358619984366202\\n-$60.00\\nJAN 10 JAN 10 PAYMENT – THANK YOU \/ PAIEMENT – MERCI\\n75105399010619980541202\\n-$21.82\\nJAN 10 JAN 10 PURCHASE INTEREST 19.99% \\n12312312312\\n-$0.82\\n\\n\\nDEC 10 DEC 12 PRESTO VIC PARK RELOAD EAST YORK ON\\n55134428345800179063337\\n$10.25\\nDEC 13 DEC 14 TIM HORTONS 0670 QTH TORONTO ON\\n55419218347200311042837\\n$1.80\\n<\/p>\n
\nAssume that each transaction spans into three lines when you copy from a pdf file to a text file. The lines with interest charges might span into only one line. You can convert that into 3 lines before executing the code on it.<\/p>\n
\n75105398358619984366202
\n-$60.00
\nJAN 10 JAN 10 PAYMENT – THANK YOU \/ PAIEMENT – MERCI
\n75105399010619980541202
\n-$21.82
\nJAN 10 JAN 10 PURCHASE INTEREST 19.99%
\n12312312312
\n-$0.82<\/p>\n
\n#!\/usr\/bin\/env python
\n# coding: utf-8<\/p>\n
\nimport re<\/p>\n
\npath = ‘dec2018-jan2019.txt’
\nif os.path.exists(path):
\n# print(‘debug: exists’)
\nfile = open(‘dec2018-jan2019.txt’,’r’)
\nelse:
\nprint(‘Fatal error: file does not exist’)
\nexit(1)<\/p>\n
\nfileContent<\/p>\n
\n#f.write("Now the file has more content!")
\n#f.close()<\/p>\n
\ncount = 0;
\nf = open("dec2018-jan2019.out.txt.csv", "a");
\nfile = open(‘dec2018-jan2019.txt’,’r’)
\nfor line in file:
\n#print(line);
\nline = line.rstrip("\\n");
\nif line !=”:
\ncount = count + 1;<\/p>\n
\nline = line[0:6] + "," + line[6:13] + "," + line[13:];<\/p>\n
\nline = line + "," ;<\/p>\n
\n#print(line[0]);
\nif line[0] == ‘-‘:
\nline = line[1:];
\nif (line[0] != ‘$’ ):
\nprint(‘Warning possible mistake’)<\/p>\n
\none_line = one_line + line;<\/p>\n
\none_line = one_line + "\\r\\n";
\nprint(one_line);
\nf.write(one_line);
\none_line = ”;<\/p>\n
\nNote: Older short-notes from this site are posted on Medium: <\/strong><\/em>https:\/\/medium.com\/@SayedAhmedCanada<\/a><\/p>\n
\nSayed Ahmed<\/strong>
\n<\/em>
\nBSc. Eng. in Comp. Sc. & Eng. (BUET)<\/strong><\/em>
\nMSc. in Comp. Sc. (U of Manitoba, Canada)<\/strong><\/em>
\nMSc. in Data Science and Analytics (Ryerson University, Canada)<\/strong><\/em>
\nLinkedin<\/strong>: https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/a>
\n<\/em><\/p>\n
\nTraining Courses: <\/strong>http:\/\/Training.SitesTree.com<\/a> <\/em><\/p>\n
\nhttps:\/\/www.facebook.com\/banglasalearningschool<\/a>
\nhttps:\/\/www.facebook.com\/justetcsocial<\/a><\/p>\n