Construct a customer database from PDF bank statements using Python programming and Microsoft SQL
This thesis is submitted in partial fulfillment of the requirements for the degree of Bachelor of Science in Computer Science and Engineering, 2021.
| 主要作者: | |
|---|---|
| 其他作者: | |
| 格式: | Thesis |
| 语言: | English |
| 出版: |
Brac University
2021
|
| 主题: | |
| 在线阅读: | http://hdl.handle.net/10361/15617 |
| id |
10361-15617 |
|---|---|
| record_format |
dspace |
| spelling |
10361-156172022-01-26T10:18:19Z Construct a customer database from PDF bank statements using Python programming and Microsoft SQL Nandi, Bikash Kumar Uddin, Jia Department of Computer Science and Engineering, Brac University Bank account statement Customer database Microsoft SQL Financial sector Credit approval Python pdftotext SQL (Computer program language) Relational databases Python (Computer program language) Computer programming This thesis is submitted in partial fulfillment of the requirements for the degree of Bachelor of Science in Computer Science and Engineering, 2021. Cataloged from PDF version of thesis. Includes bibliographical references (pages 19-20). This report proposes a model of extracting customers' transactions information from pdf Bank Account Statement and stores result-set into a customer Microsoft SQL (MsSQL) database for further automated analysis. In nancial sector, it is very important to analysis bank account statement properly to measure the creditwor- thiness for credit approval. To achieve this target, a credit analyst needs to spend a signi cant time for manual analysis which leads to delay credit approval and some- times inaccurate analysis diverts to take wrong approval. So, at present, automated bank account statement analysis is a big demand in the nancial sector. This model will overcome the aforementioned limitations and serve the current market demand. For targeting to achieve this desired goal, the whole process has been divided into 4 basic segments. The rst segment entails converting pdf to text by using a python library (pdftotext), the second one emphasis on correction raw text le (.txt) data by removing unnecessary characters and spaces and do formatting as per need, the third segment consists of parsing formatted text (.txt) and retrieving desired trans- actional information, and nally the fourth segment stores the desired information into a customer database. Bikash Kumar Nandi B. Computer Science 2021-11-17T05:27:00Z 2021-11-17T05:27:00Z 2021 2021-06 Thesis ID 17366002 http://hdl.handle.net/10361/15617 en Brac University theses are protected by copyright. They may be viewed from this source for any purpose, but reproduction or distribution in any format is prohibited without written permission. 20 pages application/pdf Brac University |
| institution |
Brac University |
| collection |
Institutional Repository |
| language |
English |
| topic |
Bank account statement Customer database Microsoft SQL Financial sector Credit approval Python pdftotext SQL (Computer program language) Relational databases Python (Computer program language) Computer programming |
| spellingShingle |
Bank account statement Customer database Microsoft SQL Financial sector Credit approval Python pdftotext SQL (Computer program language) Relational databases Python (Computer program language) Computer programming Nandi, Bikash Kumar Construct a customer database from PDF bank statements using Python programming and Microsoft SQL |
| description |
This thesis is submitted in partial fulfillment of the requirements for the degree of Bachelor of Science in Computer Science and Engineering, 2021. |
| author2 |
Uddin, Jia |
| author_facet |
Uddin, Jia Nandi, Bikash Kumar |
| format |
Thesis |
| author |
Nandi, Bikash Kumar |
| author_sort |
Nandi, Bikash Kumar |
| title |
Construct a customer database from PDF bank statements using Python programming and Microsoft SQL |
| title_short |
Construct a customer database from PDF bank statements using Python programming and Microsoft SQL |
| title_full |
Construct a customer database from PDF bank statements using Python programming and Microsoft SQL |
| title_fullStr |
Construct a customer database from PDF bank statements using Python programming and Microsoft SQL |
| title_full_unstemmed |
Construct a customer database from PDF bank statements using Python programming and Microsoft SQL |
| title_sort |
construct a customer database from pdf bank statements using python programming and microsoft sql |
| publisher |
Brac University |
| publishDate |
2021 |
| url |
http://hdl.handle.net/10361/15617 |
| work_keys_str_mv |
AT nandibikashkumar constructacustomerdatabasefrompdfbankstatementsusingpythonprogrammingandmicrosoftsql |
| _version_ |
1814308755083362304 |