Main Code.ipynb

{"cells":[{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["# install the packege needed\n","!pip install tabula-py\n","!pip install pandas"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["# Import the required Module\n","import tabula\n","import pandas as pd"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["# Read a PDF File\n","data = tabula.read_pdf(\"/content/EXTRATO GLOBAL 02-2023.pdf\", pages='2')[0] # \"all\" untuk semua data, pages diisi nomor halaman\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["# convert PDF into CSV\n","tabula.convert_into(\"/content/EXTRATO GLOBAL 02-2023.pdf\", \"Extrato 02-2023.csv\", output_format=\"csv\", pages='1') #\"all\" untuk semua data, pages diisi no halaman\"\n","\n","print(data)\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["# to convert to excell file\n","data1 = pd.read_csv(\"/content/EXTRATO GLOBAL 02-2023.pdf\")\n","data1.dtypes\n","\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["#now save to xlsx\n","data.to_excel('Extrato_02-2023.xlsx', index=False)"]}],"metadata":{"language_info":{"name":"python"}},"nbformat":4,"nbformat_minor":2}