PDF Data Extraction using Langchain.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "7f806676",
   "metadata": {},
   "outputs": [],
   "source": [
    "from langchain_community.document_loaders import PyPDFLoader, PyPDFDirectoryLoader\n",
    "from getpass import getpass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "dc4babc5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "········\n"
     ]
    }
   ],
   "source": [
    "HUGGINGFACEHUB_API_TOKEN = getpass()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "346a0e05",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<langchain_community.document_loaders.pdf.PyPDFLoader at 0x2caf0f57410>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "loader = PyPDFLoader(file_path='SQL Practical Assignment.pdf')\n",
    "loader"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "126f49a7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[Document(page_content='SQL Practical Assignment  \\nTask 1: Table Creation:  \\nQuery:  \\nCREATE TABLE ProductStateSales  ( \\n   PRODUCTLINE VARCHAR(100), \\n  STATE VARCHAR(50), \\n  SALES FLOAT \\n); \\nOutput Screenshot:  \\n \\n             Task 2: Data Aggregation and Insertion:  \\n              Query:  \\n              INSERT INTO ProductStateSales  (PRODUCTLINE , STATE, SALES) \\nSELECT PRODUCTLINE , STATE, SUM(Sales) as TOTAL_SALES FROM Orders \\n       GROUP BY PRODUCTLINE , STATE; \\n              Output Screenshot:', metadata={'source': 'SQL Practical Assignment.pdf', 'page': 0}),\n",
       " Document(page_content=\"Task 3: Record Deletion:  \\nQuery:  \\nDELETE FROM ProductStateSales  \\nWHERE STATE='CA' AND PRODUCTLINE ='Classic Cars' ; \\nOutput Screenshot:  \\n \\nTask 4: Cartesian Product:\", metadata={'source': 'SQL Practical Assignment.pdf', 'page': 1}),\n",
       " Document(page_content='Query:  \\nSELECT * FROM Orders, ProductStateSales ; \\nOutput Screenshot:  \\n \\nTask 5: Equality Join Using WHERE Clause:  \\nQuery:  \\nSELECT * FROM Orders as o, ProductStateSales as p \\nWHERE o.PRODUCTLINE = p.PRODUCTLINE AND o.STATE = p.STATE; \\nOutput Screenshot:', metadata={'source': 'SQL Practical Assignment.pdf', 'page': 2}),\n",
       " Document(page_content='Task 6: Equality Join Using JOIN Keyword:  \\nQuery:  \\nSELECT * FROM Orders as o JOIN ProductStateSales as p \\nON o.PRODUCTLINE = p.PRODUCTLINE  AND o.STATE = p.STATE; \\nOutput Screenshot:  \\n \\nTask 7: Outer Join:  \\nQuery:  \\nSELECT * FROM Orders as o LEFT JOIN ProductStateSales as p \\nON o.PRODUCTLINE = p.PRODUCTLINE AND o.STATE = p.STATE; \\nOutput Screenshot s:', metadata={'source': 'SQL Practical Assignment.pdf', 'page': 3})]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pages = loader.load_and_split()\n",
    "pages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "cb2c9f5e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(pages)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "fb97b4ef",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SQL Practical Assignment  \n",
      "Task 1: Table Creation:  \n",
      "Query:  \n",
      "CREATE TABLE ProductStateSales  ( \n",
      "   PRODUCTLINE VARCHAR(100), \n",
      "  STATE VARCHAR(50), \n",
      "  SALES FLOAT \n",
      "); \n",
      "Output Screenshot:  \n",
      " \n",
      "             Task 2: Data Aggregation and Insertion:  \n",
      "              Query:  \n",
      "              INSERT INTO ProductStateSales  (PRODUCTLINE , STATE, SALES) \n",
      "SELECT PRODUCTLINE , STATE, SUM(Sales) as TOTAL_SALES FROM Orders \n",
      "       GROUP BY PRODUCTLINE , STATE; \n",
      "              Output Screenshot:\n",
      "------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n",
      "Task 3: Record Deletion:  \n",
      "Query:  \n",
      "DELETE FROM ProductStateSales  \n",
      "WHERE STATE='CA' AND PRODUCTLINE ='Classic Cars' ; \n",
      "Output Screenshot:  \n",
      " \n",
      "Task 4: Cartesian Product:\n",
      "------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n",
      "Query:  \n",
      "SELECT * FROM Orders, ProductStateSales ; \n",
      "Output Screenshot:  \n",
      " \n",
      "Task 5: Equality Join Using WHERE Clause:  \n",
      "Query:  \n",
      "SELECT * FROM Orders as o, ProductStateSales as p \n",
      "WHERE o.PRODUCTLINE = p.PRODUCTLINE AND o.STATE = p.STATE; \n",
      "Output Screenshot:\n",
      "------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n",
      "Task 6: Equality Join Using JOIN Keyword:  \n",
      "Query:  \n",
      "SELECT * FROM Orders as o JOIN ProductStateSales as p \n",
      "ON o.PRODUCTLINE = p.PRODUCTLINE  AND o.STATE = p.STATE; \n",
      "Output Screenshot:  \n",
      " \n",
      "Task 7: Outer Join:  \n",
      "Query:  \n",
      "SELECT * FROM Orders as o LEFT JOIN ProductStateSales as p \n",
      "ON o.PRODUCTLINE = p.PRODUCTLINE AND o.STATE = p.STATE; \n",
      "Output Screenshot s:\n",
      "------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n"
     ]
    }
   ],
   "source": [
    "for page in pages:\n",
    "    print(page.page_content)\n",
    "    print(\"------\"*30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "cda5d45e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<langchain_community.document_loaders.pdf.PyPDFDirectoryLoader at 0x2cae2497a10>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "loader = PyPDFDirectoryLoader(path=\"pdf_files/\",glob=\"**/*.pdf\")\n",
    "loader"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "b8106f2f",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Ignoring wrong pointing object 6 0 (offset 0)\n",
      "Ignoring wrong pointing object 9 0 (offset 0)\n",
      "Ignoring wrong pointing object 11 0 (offset 0)\n",
      "Ignoring wrong pointing object 13 0 (offset 0)\n",
      "Ignoring wrong pointing object 6 0 (offset 0)\n",
      "Ignoring wrong pointing object 8 0 (offset 0)\n",
      "Ignoring wrong pointing object 10 0 (offset 0)\n",
      "Ignoring wrong pointing object 12 0 (offset 0)\n",
      "Ignoring wrong pointing object 14 0 (offset 0)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[Document(page_content='3 Courses\\nUnderstanding and\\nVisualizing Data with Python\\nInferential Statistical\\nAnalysis with Python\\nFitting Statistical Models to\\nData with Python\\nBrenda Gunderson,\\nPh.D., Lecturer IV \\n \\nKerby Shedden, Ph.D.,\\nProfessor \\n \\nBrady T. West, Ph.D.,\\nResearch Associate\\nProfessor\\nOct 13, 2021\\nSayam Kumar\\nhas successfully completed the online, non-credit S pecialization\\nStatistics with Python\\nThis specialization is designed to teach learners b eginning and\\nintermediate concepts of statistical analysis, and use of the Python\\nprogramming language to conduct data analyses. Lear ners will learn\\nwhere data come from, what types of data can be col lected, how to\\neﬀectively summarize and visualize data, how to uti lize data for\\nestimation and assessing theories, proper interpret ations of inferential\\nresults, and how to apply more advanced statistical  modeling\\nprocedures.\\nThe online specialization named in this certiﬁcate may draw on material from courses taught on-campus,  but the included\\ncourses are not equivalent to on-campus courses. Pa rticipation in this online specialization does not constitute enrollment\\nat this university. This certiﬁcate does not confer  a University grade, course credit or degree, and i t does not verify the\\nidentity of the learner.\\nVerify this certiﬁcate at: \\nhttps://coursera.org/verify/specializat\\nion/PNJRWR4LY6HM', metadata={'source': 'pdf_files\\\\Certifications.pdf', 'page': 0}),\n",
       " Document(page_content='9 Courses\\nIntroduction to Data\\nAnalytics\\nExcel Basics for Data\\nAnalysis\\nData Visualization and\\nDashboards with Excel and\\nCognos\\nPython for Data Science, AI\\n& Development\\nPython Project for Data\\nScience\\nDatabases and SQL for Data\\nScience with Python\\nData Analysis with Python\\nData Visualization with\\nPython\\nIBM Data Analyst Capstone\\nProject\\nRav Ahuja, Program\\nDirector, IBM Skills\\nNetwork\\nNov 25, 2021\\nSayam Kumar\\nhas successfully completed the online, non-credit P rofessional\\nCertiﬁcate\\nIBM Data Analyst\\nThis IBM Professional Certiﬁcate is earned after su ccessfully\\ncompleting 9 courses on various topics in Data Anal ytics. The learner\\nunderstands the core principles of data analysis an d has worked\\nhands-on with a variety of data sources, project sc enarios, and data\\nanalysis tools, including Excel, SQL, Relational Da tabases, Python,\\nJupyter Notebooks, and Cognos Analytics, gaining pr actical experience\\nwith data manipulation, data analysis, and data vis ualization. The\\nearner of this Certiﬁcate has demonstrated proﬁcien cy in applying\\ndiﬀerent analytical techniques by analyzing real-wo rld datasets,\\ncreating visualizations & interactive dashboards, a nd presenting\\nreports to share ﬁndings of data analysis, and is n ow equipped with\\nskills for an entry-level role in data analytics.\\nThe online specialization named in this certiﬁcate may draw on material from courses taught on-campus,  but the included\\ncourses are not equivalent to on-campus courses. Pa rticipation in this online specialization does not constitute enrollment\\nat this university. This certiﬁcate does not confer  a University grade, course credit or degree, and i t does not verify the\\nidentity of the learner.\\nVerify this certiﬁcate at: \\nhttps://coursera.org/verify/profession\\nal-cert/7RU3A97BZEKH', metadata={'source': 'pdf_files\\\\Certifications.pdf', 'page': 1}),\n",
       " Document(page_content='10 Courses\\nRav Ahuja \\nAI & Data Science\\nProgram Director \\nIBM Skills Network\\nWhat is Data Science?\\nTools for Data Science\\nData Science Methodology\\nPython for Data Science, AI &\\nDevelopment\\nPython Project for Data Science\\nDatabases and SQL for Data Science\\nwith Python\\nData Analysis with Python\\nData Visualization with Python\\nMachine Learning with Python\\nApplied Data Science CapstoneJul 19, 2022\\nSayam Kumar\\nhas successfully completed the online, non-credit P rofessional\\nCertiﬁcate\\nIBM Data Science\\nIn this Professional Certiﬁcate, learners developed  and honed hands-\\non skills in Data Science and Machine Learning. Lea rners started with\\nan orientation of Data Science and its Methodology,  became familiar\\nand used a variety of data science tools, learned P ython and SQL,\\nperformed Data Visualization and Analysis, and crea ted Machine\\nLearning models. In the process they completed seve ral labs and\\nassignments on the cloud including a Capstone Proje ct at the end to\\napply and demonstrate their knowledge and skills.\\nThe online specialization named in this certiﬁcate may draw on material from courses taught on-campus,  but the included\\ncourses are not equivalent to on-campus courses. Pa rticipation in this online specialization does not constitute enrollment\\nat this university. This certiﬁcate does not confer  a University grade, course credit or degree, and i t does not verify the\\nidentity of the learner.\\nVerify this certiﬁcate at: \\nhttps://coursera.org/verify/profession\\nal-cert/4UVFLGUEDBCU', metadata={'source': 'pdf_files\\\\Certifications.pdf', 'page': 2}),\n",
       " Document(page_content='5 Courses\\nPython for Data Science, AI\\n& Development\\nPython Project for Data\\nScience\\nData Analysis with Python\\nData Visualization with\\nPython\\nApplied Data Science\\nCapstone\\nYan Luo \\nPh.D., Data Scientist\\nand DeveloperSaishruthi Swaminathan \\nData Scientist \\nIBM CODAIT\\nAzim Hirjani \\nCognitive Data ScientistDr. Pooja \\nInstructor and Subject\\nMatter Expert \\nSkill-Up Technologies\\nJoseph Santarcangelo  \\nSenior Data Scientist \\nIBM\\nOct 11, 2023\\nSayam Kumar\\nhas successfully completed the online, non-credit S pecialization\\nApplied Data Science\\nIn this specialization learners developed and honed  skills for practical\\ndata science and machine learning problems. The spe cialization\\nincluded learning Python, as well as performing dat a analysis, and\\ncreating data visualizations using Python. Learners  also completed a\\nCapstone project to apply and demonstrate their new ly acquired\\nknowledge and skills.\\nThe online specialization named in this certiﬁcate may draw on material from courses taught on-campus,  but the included\\ncourses are not equivalent to on-campus courses. Pa rticipation in this online specialization does not constitute enrollment\\nat this university. This certiﬁcate does not confer  a University grade, course credit or degree, and i t does not verify the\\nidentity of the learner.\\nVerify this certiﬁcate at: \\nhttps://coursera.org/verify/specializat\\nion/HVVS6YSZCMJC', metadata={'source': 'pdf_files\\\\Certifications.pdf', 'page': 3}),\n",
       " Document(page_content='In this assignment, you have to create and ER Diagram and list out the relationships between the three tables containing sample data shown below based on a few business rules. Here are the business rules: • The Patients table stores data for individual patients. Each row represents a unique patient.  • The Health_conditions table stores data for a unique disease/health condition. Each row is unique and condition cannot be repeated in this table. However, multiple patients can have same health conditions.  • The Patient_Address table stores the address for each patient. Each address can belong to multiple patients e.g. People from a family will have the same address. Based on the above business rules, create appropriate relationships between the tables shown below. You can create new tables (to break any many to many relationships that may arise due to business rules) or add new columns to the existing tables to establish the relationships. Please ensure that each table has a unique primary key that is not repeating and relationships are established by creating a Primary Key - Foreign key relationship.  Patients    Patient_Id Patient_Last_Name Patient_First_Name  1 Smith John  2 Smith Jane  3 Vandelay Art  4 Dover Ben         Health_Conditions    Condition_Id Condition   1 Right Leg fracture   2  COPD   3 Aneurysm   4 Vein Thrombosis   5 Upper Respiratory Infections   6 Headache   7 Confusion        Patient_Address', metadata={'source': 'pdf_files\\\\ER Diagaram Assignment .pdf', 'page': 0}),\n",
       " Document(page_content='Address_Id Street_Address City Province 1 2449  Algoma St Thunder Bay ONTARIO 2 327 Avenue Rd North york ONTARIO 3 222 Hardwood Road  Etobicoke ONTARIO 4 11 Maven Avenue Toronto ONTARIO', metadata={'source': 'pdf_files\\\\ER Diagaram Assignment .pdf', 'page': 1}),\n",
       " Document(page_content='BIA5001  Introduction to Statistical \\nSoftware Languages   \\nDr. Nihad Al -Juboori  Lab 3  \\nStudent ID:  Student Name:  \\nA – Single Dimension al list questions: Q1 and Q2  \\nQ1: \\nWrite a function  that returns the index of the smallest and the biggest element in an array of \\nintegers. If there  are more than one  number  having the same value (smallest or biggest) , return \\nthe smallest always.  \\nWrite test program that prompts the user to enter 10 numbers, invokes this function  to return \\nthe index of the smallest and the biggest element s, and display the indices. \\n \\nPart 1:  Requirements Specification  \\n \\nThe program must satisfy the following requirements:  \\n• It must ask the user to enter 10 numbers . \\n• Call a function  named “ indexOfElement s” that finds  the index of the smallest and \\nbiggest numbers.  \\n \\nExample:  \\nInput numbers:  3 2 0 3 5 7 8 1 0 8  \\nThe smallest number is 0 and its index is 2 \\nThe biggest number is 8 and its index is 6 \\n \\nPart 2: Coding  \\n \\nSubmit the following items:  \\n1. Complete this Microsoft Word file and submit it on  BB.  \\n2. Send the source code and snip from your run. \\nNote:  you must submit the assignment  regardless of  whether it is complete  or incomplete, \\ncorrect or incorrect.', metadata={'source': 'pdf_files\\\\Lab 33.pdf', 'page': 0}),\n",
       " Document(page_content='Q2: \\nWrite a program  that reads integers between 1 and 100 and counts the occurrence of each. \\nAssume the inputs ends with 0  \\nHere is a sample run:  \\n1 occurs 2 times  \\n2 occurs 3 times  \\n3 occurs 2 times  \\n4 occurs 6 times  \\n40 occurs 1 time  \\n \\nPart 1:  Requirements Specification  \\n \\nThe program must satisfy the following requirements:  \\n• In the main function , ask the user to enter integer numbers between 1 and 100.  \\n• If the user inputs  0 then the program will stop taking new numbers and start running . \\n \\n \\nPart 2: Coding  \\n \\nSubmit the following items:  \\n1. Complete this Microsoft Word file and submit it on BB.  \\n2. Send the source code and snip from your run. \\nNote:  you must submit the assignment regardless of  whether it complete or incomplete, \\ncorrect or incorrect.', metadata={'source': 'pdf_files\\\\Lab 33.pdf', 'page': 1}),\n",
       " Document(page_content='B – Two -Dimensional list questions: Q3 and Q4  \\nQ3: \\nWrite a program that will initialize a list of two dimensions and perform the following actions:  \\n1- sum the elements of the columns.  \\n2- Sum the elements of the rows  \\n3- Find the largest value of the summations for the rows and columns.  \\n4- Print the list and print the maximum value in rows and the index of the row and the \\nmaximum value in columns and the index of the column.  \\nPart 1:  Requirements Specification  \\n \\nThe program must satisfy the following requirements:  \\n• It must ask the user to enter elements of the array . \\n• Call a function to find the summation of the rows and columns.  \\n• Print the result.   \\n \\nExample:  \\nFor the following 3 X 3 list:  \\n1 2 3 \\n4 5 6 \\n7 8 9 \\n \\nThe program will print:  \\nThe maximum value in rows is 24 in row 2  \\nThe maximum value in columns is 18 in column 2  \\n \\nPart 2: Coding  \\n \\nSubmit the following items:  \\n1. Complete this Microsoft Word file and submit it on BB.  \\n2. Send the source code and snip from your run.  \\nNote:  you must submit the assignment regardless of whether it is complete  or incomplete, \\ncorrect,  or incorrect.', metadata={'source': 'pdf_files\\\\Lab 33.pdf', 'page': 2}),\n",
       " Document(page_content='Q2: \\nWrite a program that will add two matrices that the user will input , assume these two matrices \\nare of the same size . \\n \\nPart 1:  Requirements Specification  \\n \\nThe program must satisfy the following requirements:  \\n• In the main method,  ask the user to enter the two matrices.  \\n•  Add the two matrices in a separate function.  \\n \\n**Complete part 2.  \\n \\nNote: You are not required to complete the Analysis and Design sections.  \\n \\nPart 2: Coding  \\n \\nSubmit the following items:  \\n1. Complete this Microsoft Word file and submit it on BB.  \\n2. Send the source code and snip from your run.  \\nNote:  you must submit the assignment regardless of whether it is complete  or incomplete, \\ncorrect,  or incorrect.', metadata={'source': 'pdf_files\\\\Lab 33.pdf', 'page': 3}),\n",
       " Document(page_content='Letter of Recommendation  \\nIt is to certify that Mr. Sayam Kumar Ref no.PS21 DA0964  S/O Mr.  Rajeev \\nKumar resident at 3/57, Street No. 3, Nirankari Colony, Delhi  has been \\nserving in the organization since 15thSeptember  to 15thNovember  2021 as \\nData Analyst . \\nDuring this tenure  Mr. Sayam Kumar remained involved in his  work like \\ndata scrapping, problem solving of new interns. We found he is pretty \\nactive in whatever task we have given to  him. He is a confident person. H e \\nis professionally sound, har d-working and a devoted staff. H e has the \\nmotivation to take initiative in tasks and we are gratified that he has been \\nhelpful in the advancement of our organization.', metadata={'source': 'pdf_files\\\\LORs.pdf', 'page': 0}),\n",
       " Document(page_content='ChefAtHome FoodTech LLP  \\nPage | 1  \\nRegistered Address : 10, P.L.S. NAGAR, EXT - 2, CHINNIYAMPALAYAM, CBE, 13/G/0215375, COIMBATORE, TAMILNADU - 641046.  \\nEmail: chef.at.home.llp@gmail.com , Website : http://thechefathome.in/   \\n  \\n \\nSubject: Mr. Sayam  Kumar  Applicant Reference  \\nTo Whom it May Concern  \\n \\n \\nI highly recommend M r. Sayam  Kumar as a candidate for employment. Mr. Sayam  \\nKumar was employed by ChefAtHome Foodtech LLP as  Data Analyst Intern from 18th \\nOctober  2021, to 18th December 2021. Mr. Sayam  Kumar was responsible for data \\nexploration, data extraction of 4 regional cuisines in Chennai, analyzing  extracted data \\nand reporting the data to product team.  \\n \\nMr. Sayam  Kumar  has excellent communication ski lls. In addition,  He is extremely \\norganized,  and reliable.  Mr. Sayam  Kumar can work  independently  and is able to follow \\nthrough  to ensure  that the job gets done.  He is flexible  and willing  to work  on any project \\nthat is assigned to  him. \\n \\nMr. Sayam Kumar would be a tremendous asset to your company and has my highest \\nrecommendation. If you have any further questions with regard to his background or \\nqualifications, please do not hesitate to call me.  \\n \\n \\nRegards,  \\n \\n \\n \\n \\n \\nSharuq N A  \\nCEO  \\nChefAtHome FoodTech LLP \\nsharuq.kehtech@gmail.com  \\nhttp://thechefathome.in/', metadata={'source': 'pdf_files\\\\LORs.pdf', 'page': 1}),\n",
       " Document(page_content=\"Letter of Recommendation   \\n \\nIt gives me immense pleasure to write a letter of recommendation for Sayam Kumar. I instructed  \\nhim the subject of Operating Systems during  his third year (2021 -22). My interaction with him has \\ngiven me ample scope to evaluate his academic and personal capabilities.  \\nSayam is a since re and hardworking student. He takes his studies very seriously and is passionate \\nabout his performance. During the class discussions, he never failed to impress me with his active \\nparticipation. His assignments were really neat, clean , and precise and he always meets the \\ndeadlines. His marks in-sessional  exams depicted how hard he worked on a consistent  basis. His \\neagerness  to learn and his impeccable dedication to his studies is extremely  meritorious . He was \\nconsistent  in attending classes and had an outstanding demeanor . In labs, he completely outshine d \\nhis peers with his critical and logical thinking. In the  prac tical examinations, he astonished the \\nexaminers with his thorough and intelligible  responses . He handled his coursework with utmost \\nsincerity and worked tirelessly on the concepts discussed in the class.  \\nPersonally, he is a very disciplined student with a  pleasant demeanor . He has excellent \\ncommunication and interpersonal skills and is well -liked by all. He is meticulous with his notions and \\nis always willing to assist others.  \\nSayam's curiosity and will to learn set him apart from his colleagues. I appreci ate his willingness to \\nlisten and correct his flaws not only academically but also personally. He is a very inquisitive person \\nwho has a keen interest in learning about current events. He always responds positively to other \\npeople's suggestions. He works h ard to improve his performance levels and demonstrates \\nexceptional leadership abilities, which enable him to reach greater heights. Furthermore, he \\npossesses a unique ability to adapt to difficult situations.  \\nAside from his academic excellence, he was an I EEE member throughout the 2019 -20 academic year \\nand actively participated in the majority of the college's events and competitions. He was truly \\nactive, lively, and steadfast when engaging in both cultural and technical events. He led several \\nworkshops for  the IEEE society and attended numerous seminars organised by the Computer Science \\nDepartment. difficult situations  \\nSayam would certainly be a prodigious  addition to your university as he has the right mindset and \\nintelligence  to perform well in Graduate Studies. I am surely  optimistic  that if provided  an \\nopportunity, he is unquestionably going to be a significant  contributor as a graduate student and will \\ndefinitely prove to be an exemplary  candidate for your acclaimed univers ity. Honestly speaking, I am \\nimmensely ecstatic to offer him my sturdiest commendation.  \\n \\nMs. Pinki Yadav  \\nAssistant Professor  \\nDepartment of Computer Science & Engineering  \\nMobile: 9650272703  \\nEmail: pinky.yadav@adgitmdelhi.ac.in\", metadata={'source': 'pdf_files\\\\LORs.pdf', 'page': 2}),\n",
       " Document(page_content='Letter of Recommendation  \\n \\nSayam Kumar is a student of Computer Science Engineering in Dr. Akhilesh Das Gupta Institute of \\nTechnology and Management, Delhi. I have taught him Web Technology in his third year (2021 -22). \\nFrom what I have observed, he is diligent, sincere and really hardworking. He possesses exceptional \\nacademic potential and ambition that is way beyond the level at which most of the undergraduate \\nstudents perform.  \\nI must say that Sayam demonstrates an excellent interest in all his scholas tic pursuits and he is \\nextremely  committed and serious about his career. From the very first day of class, he impressed me \\nwith his vast knowledge about a variety of concepts. He was really attentive and focused on the \\nminutest things that were being taugh t and consistently asked several doubts regarding the topics. \\nHis willingness to learn and his immaculate dedication towards his studies is highly commendable. \\nHis assignments were always submitted timely and his work was precise and interesting to read. He \\nwas regular in attending classes and had a well -disciplined behaviour. Moreover, his performance in \\nthe class and sessional exams was incredible. During practical examinations, he astounded the \\nexaminers with his brief responses.  \\nAt a personal level, he has a pleasing personality as he exhibits excellent communication skills and \\nhis ability to connect with his peers and help them out with their doubts is completely unparalleled. \\nHe possesses great perseverance and never hesitates in adopting an initiative . He has an outstanding \\nability to adapt himself to a new and challenging environment. Furthermore, he possesses \\nmagnificent communication and interpersonal skills and is adored by all his batchmates.  \\nIn addition to his academic excellence, he was an IEEE  member in 2019 -20, where he actively \\nparticipated in all the events that were organised in the college. As an individual, he is active and \\nperseverant in both technical and cultural events. He has taken part in conducting several \\nworkshops and has attende d many seminars organised by the Department.  \\nSayam is an inquisitive and a special student who displays keen interest in gaining knowledge about \\nlatest advancements. He would be a tremendous addition to your university as he has the right \\nattitude and inte llect to excel and succeed in Graduate education . I feel very confident that if given \\nan opportunity, he will excel in his graduate studies and will prove to be an ideal candidate for your \\nesteemed university.  \\nI give him my strongest recommendation.  \\n \\nDr. Archana Kumar  \\nProfessor  \\nDepartment of Computer Science & Engineering  \\nMobile: 9810766992  \\nEmail: archna.kumar@adgitmdelhi.ac.in', metadata={'source': 'pdf_files\\\\LORs.pdf', 'page': 3}),\n",
       " Document(page_content=\"1 | Page  \\n  \\nDate: 29 February 2024 \\nSubject: Reference Letter \\nTo whom it may concern \\n \\nI am writing this letter to highly recommend Mr. Sayam Kumar (Mechademy employee code: \\nINT018) for any future endeavors in the field of Data Science. Sayam was an invaluable member \\nof our team at Mechademy Engineering Solutions during his 5-month internship, where he \\ndemonstrated exceptional skills and dedication in the area of data science. \\n \\nDuring his internship at Mechademy, Sayam showcased his proficiency in creating regression-\\nbased machine learning models for tabular data. His analytical skills and attention to detail were \\nevident in the accuracy and effectiveness of the models he developed. Sayam's ability to grasp \\ncomplex concepts and apply them to real-world problems made a significant impact on the success \\nof our projects. \\n \\nOne of the key contributions made by Sayam was the development of a data cleaning script for \\nraw data received from clients. His script not only enhanced the efficiency of our data \\npreprocessing pipeline but also improved the overall quality and reliability of the data we worked \\nwith. Sayam's commitment to producing high-quality results was evident in the meticulous \\napproach he took towards data cleaning. \\n \\nIn addition to his technical skills, Sayam took the initiative to work on a stats module aimed at \\nfacilitating Automatic Exploratory Data Analysis (EDA). This module proved to be a valuable \\nasset in streamlining the initial phases of our projects, allowing for a more comprehensive \\nunderstanding of the data received. \\n \\nBeyond his technical capabilities, Sayam exhibited excellent communication and teamwork skills. \\nHe was proactive in seeking feedback and collaborated effectively with team members, \\ncontributing to a positive and collaborative work environment. \\n \\nIn conclusion, I am confident that Sayam's skills, work ethic, and passion for data science will \\nmake him a valuable asset to any team or project. I wholeheartedly recommend him for any \\nopportunities in the field of Data Science and am certain that he will continue to excel in his future \\nendeavors. \\n \\nPlease feel free to contact me if you require any further information. \\n \\nSincerely, \\n \\n \\nAkshay Bhardwaj \\nLead Data Scientist \\nMechademy Engineering Solutions Pvt Ltd Mechademy Engineering Solutions Pvt. Ltd.  \\nS-120 Greater Kailash Part 2, New Delhi – 110048, India  \\ninfo@mechademy.com  \\nwww. mechademy.com\", metadata={'source': 'pdf_files\\\\LORs.pdf', 'page': 4}),\n",
       " Document(page_content=\"1 | Page  \\n  \\nDate: 29 February 2024 \\nSubject: Reference Letter \\nTo whom it may concern \\n \\nI am writing this letter to highly recommend Mr. Sayam Kumar (Mechademy employee code: \\nINT018) for any future endeavors in the field of Data Science. Sayam was an invaluable member \\nof our team at Mechademy Engineering Solutions during his 5-month internship, where he \\ndemonstrated exceptional skills and dedication in the area of data science. \\n \\nDuring his internship at Mechademy, Sayam showcased his proficiency in creating regression-\\nbased machine learning models for tabular data. His analytical skills and attention to detail were \\nevident in the accuracy and effectiveness of the models he developed. Sayam's ability to grasp \\ncomplex concepts and apply them to real-world problems made a significant impact on the success \\nof our projects. \\n \\nOne of the key contributions made by Sayam was the development of a data cleaning script for \\nraw data received from clients. His script not only enhanced the efficiency of our data \\npreprocessing pipeline but also improved the overall quality and reliability of the data we worked \\nwith. Sayam's commitment to producing high-quality results was evident in the meticulous \\napproach he took towards data cleaning. \\n \\nIn addition to his technical skills, Sayam took the initiative to work on a stats module aimed at \\nfacilitating Automatic Exploratory Data Analysis (EDA). This module proved to be a valuable \\nasset in streamlining the initial phases of our projects, allowing for a more comprehensive \\nunderstanding of the data received. \\n \\nBeyond his technical capabilities, Sayam exhibited excellent communication and teamwork skills. \\nHe was proactive in seeking feedback and collaborated effectively with team members, \\ncontributing to a positive and collaborative work environment. \\n \\nIn conclusion, I am confident that Sayam's skills, work ethic, and passion for data science will \\nmake him a valuable asset to any team or project. I wholeheartedly recommend him for any \\nopportunities in the field of Data Science and am certain that he will continue to excel in his future \\nendeavors. \\n \\nPlease feel free to contact me if you require any further information. \\n \\nSincerely, \\n \\n \\nAkshay Bhardwaj \\nLead Data Scientist \\nMechademy Engineering Solutions Pvt Ltd Mechademy Engineering Solutions Pvt. Ltd.  \\nS-120 Greater Kailash Part 2, New Delhi – 110048, India  \\ninfo@mechademy.com  \\nwww. mechademy.com\", metadata={'source': 'pdf_files\\\\Mechademy Data Science Internship LOR.pdf', 'page': 0}),\n",
       " Document(page_content='2023 Personal Tax Information form  \\nwww.Taxes4u.ca  Taxes4u.ca@gmail.com  Contact: +1 647 291 1461   \\n  \\n \\n \\n \\n \\n \\nHi, Taxes4u.ca  \\nEmail: Taxes4u.ca@gmail.com or iti@taxes4u.ca \\nWebsite: www.taxes4u.ca Phone: 6472911461 \\n \\nRe: Information Request for Your 2023 Income Tax and Benefit Return (T1) \\n \\nPart A: All your Income slips, Investments slips and Tuition fees for 2023 \\n \\nIt is the time of the year to gather information and prepare for your personal income tax return for the \\n2023 tax year. In order for us to prepare your 2023 income tax return, please provide the following \\nincome tax slips for the 2023 tax year (if applicable), the corresponding provincial slips, and any other \\nslips that you have received for the year. \\n1. T4: Statement of Remuneration Paid \\n2. T4A: Statement of Pension, Retirement, Annuity, and Other Income \\n3. T4A(OAS ): Statement of Old Age Security (OAS) \\n4. T4A(P): Statement of Canada Pension Plan Benefits \\n5. T4A-RCA: Statement of Distributions from a Retirement Compensation Arrangement (RCA) \\n6. T4E: Statement of Employment Insurance and Other Benefits \\n7. T4PS: Statement of Employee Profit-Sharing Plan Allocations and Payments \\n8. T4RIF: Statement of Income From a Registered Retirement Income Fund \\n9. T4RSP: Statement of RRSP Income \\n10. T5: Statement of Investment Income \\n11. T5007: Statement of Benefits \\n12. T5008: Statement of Securities \\n13. Transactions T5013: Statement of Partnership Income \\n14. RC210: Canada Workers Benefit Advance Payments Statement \\n15. RRSP: Registered Retirement Savings Plan (RRSP) contributions made between March and \\nDecember of 2023, or during the first 60 days of 2023+1 \\n16. T2202: Tuition and Enrolment Certificate \\n17. TL11A/C/D : Tuition and Enrolment Certificate - University Outside Canada / Commuter to \\nthe United States / Educational Institutions Outside Canada for a Deemed Resident of Canada \\n(if applicable) \\n \\nPart B: All your business activities, Foreign Incomes and Other expenses \\nIn addition, please provide us with the following information for the 2023 tax year (if applicable): \\n1. Notice of (Re)Assessment (s) (NOA) for the previous tax year \\n2. Statements for your investmen ts (shares, mutual funds, bonds, debentures, promissory \\nnotes, etc.) for any dispositions in the year \\n3. Information for any other dispositions (real estate, depreciable properties, qualified farm or \\nfishing properties, qualified small business corporation shares, etc.) \\n4. Income and expenses from business or professional activities \\n5. Income and expenses from rental activities \\n6. Foreign income (employment, investment, pension, etc.), capital gains or losses, foreign \\ntaxes paid, etc. Employment expenses', metadata={'source': 'pdf_files\\\\Tax Information checklist.pdf', 'page': 0}),\n",
       " Document(page_content='2023 Personal Tax Information form  \\nwww.Taxes4u.ca  Taxes4u.ca@gmail.com  Contact: +1 647 291 1461   \\n \\nIti Patel CPA, CA, MBA  \\nPart C: Other expenses \\n \\n1. Medical expenses for yourself, and your spouse or common-law partner (if applicable) \\nMedical expenses for dependents \\n2. Official tax receipts for donations made by yourself, and your spouse Receipts for political \\ncontributions made in the year (if applicable) \\n3. Receipts and/or statements for the amounts paid regarding rent or property tax Federal \\nand/or provincial tax instalments made \\n4. Employment expenses, if you are commissioned employee or contractor or work from home.  \\n5. Annual union, professional, or like dues \\n6. Carrying charges and interest expenses \\n7. Seniors home safety: If you spent money to make home safe and you are a above 65 \\nyears or older, please provide that amount . \\n8. Covid 19: Benefits Repayment please provide repayments amount. \\nPart D: General Information \\n \\nAre you are filing tax with us for the first time? Please provide below information  \\n1. Your Full Name \\n2. SIN No. \\n3. Address \\n4. Marital status \\n5. Date of Birth \\n6. Dependents (e.g. new child, parents or other dependants supported by you) Name, Relation, \\nDate of Birth and relation \\n7. Residency status (if changed in 2023/date of landing) \\n8. Direct deposit information (if you want to get refund directly to bank account) \\n \\n \\nWorked with us Before, please provide below information, only if updated from last tax year:  \\nPlease notify us and provide information if any of the following has changed from prior year: \\n \\n1. Name Change \\n2. SIN No. (changed from temporary to permanent) \\n3. Date of Birth \\n4. Address \\n5. Marital status \\n6. New Dependents information (e.g. new child, parents or other dependants supported by \\nyou) Name, Relation, Date of Birth and relation \\n7. Residency status changed? \\n8. Direct deposit information (if you want to get refund directly to bank account) \\n \\nIf you have any questions about your income tax returns, please contact me at 6472911461 \\nSincerely,', metadata={'source': 'pdf_files\\\\Tax Information checklist.pdf', 'page': 1})]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pdfs = loader.load_and_split()\n",
    "pdfs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "aaecefa2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "18"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(pdfs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "f0981025",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Page Source: pdf_files\\Certifications.pdf\n",
      "Page No: 0\n",
      "Content: 3 Courses\n",
      "Understanding and\n",
      "Visualizing Data with Python\n",
      "Inferential Statistical\n",
      "Analysis with Python\n",
      "Fitting Statistical Models to\n",
      "Data with Python\n",
      "Brenda Gunderson,\n",
      "Ph.D., Lecturer IV \n",
      " \n",
      "Kerby Shedden, Ph.D.,\n",
      "Professor \n",
      " \n",
      "Brady T. West, Ph.D.,\n",
      "Research Associate\n",
      "Professor\n",
      "Oct 13, 2021\n",
      "Sayam Kumar\n",
      "has successfully completed the online, non-credit S pecialization\n",
      "Statistics with Python\n",
      "This specialization is designed to teach learners b eginning and\n",
      "intermediate concepts of statistical analysis, and use of the Python\n",
      "programming language to conduct data analyses. Lear ners will learn\n",
      "where data come from, what types of data can be col lected, how to\n",
      "eﬀectively summarize and visualize data, how to uti lize data for\n",
      "estimation and assessing theories, proper interpret ations of inferential\n",
      "results, and how to apply more advanced statistical  modeling\n",
      "procedures.\n",
      "The online specialization named in this certiﬁcate may draw on material from courses taught on-campus,  but the included\n",
      "courses are not equivalent to on-campus courses. Pa rticipation in this online specialization does not constitute enrollment\n",
      "at this university. This certiﬁcate does not confer  a University grade, course credit or degree, and i t does not verify the\n",
      "identity of the learner.\n",
      "Verify this certiﬁcate at: \n",
      "https://coursera.org/verify/specializat\n",
      "ion/PNJRWR4LY6HM\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Certifications.pdf\n",
      "Page No: 1\n",
      "Content: 9 Courses\n",
      "Introduction to Data\n",
      "Analytics\n",
      "Excel Basics for Data\n",
      "Analysis\n",
      "Data Visualization and\n",
      "Dashboards with Excel and\n",
      "Cognos\n",
      "Python for Data Science, AI\n",
      "& Development\n",
      "Python Project for Data\n",
      "Science\n",
      "Databases and SQL for Data\n",
      "Science with Python\n",
      "Data Analysis with Python\n",
      "Data Visualization with\n",
      "Python\n",
      "IBM Data Analyst Capstone\n",
      "Project\n",
      "Rav Ahuja, Program\n",
      "Director, IBM Skills\n",
      "Network\n",
      "Nov 25, 2021\n",
      "Sayam Kumar\n",
      "has successfully completed the online, non-credit P rofessional\n",
      "Certiﬁcate\n",
      "IBM Data Analyst\n",
      "This IBM Professional Certiﬁcate is earned after su ccessfully\n",
      "completing 9 courses on various topics in Data Anal ytics. The learner\n",
      "understands the core principles of data analysis an d has worked\n",
      "hands-on with a variety of data sources, project sc enarios, and data\n",
      "analysis tools, including Excel, SQL, Relational Da tabases, Python,\n",
      "Jupyter Notebooks, and Cognos Analytics, gaining pr actical experience\n",
      "with data manipulation, data analysis, and data vis ualization. The\n",
      "earner of this Certiﬁcate has demonstrated proﬁcien cy in applying\n",
      "diﬀerent analytical techniques by analyzing real-wo rld datasets,\n",
      "creating visualizations & interactive dashboards, a nd presenting\n",
      "reports to share ﬁndings of data analysis, and is n ow equipped with\n",
      "skills for an entry-level role in data analytics.\n",
      "The online specialization named in this certiﬁcate may draw on material from courses taught on-campus,  but the included\n",
      "courses are not equivalent to on-campus courses. Pa rticipation in this online specialization does not constitute enrollment\n",
      "at this university. This certiﬁcate does not confer  a University grade, course credit or degree, and i t does not verify the\n",
      "identity of the learner.\n",
      "Verify this certiﬁcate at: \n",
      "https://coursera.org/verify/profession\n",
      "al-cert/7RU3A97BZEKH\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Certifications.pdf\n",
      "Page No: 2\n",
      "Content: 10 Courses\n",
      "Rav Ahuja \n",
      "AI & Data Science\n",
      "Program Director \n",
      "IBM Skills Network\n",
      "What is Data Science?\n",
      "Tools for Data Science\n",
      "Data Science Methodology\n",
      "Python for Data Science, AI &\n",
      "Development\n",
      "Python Project for Data Science\n",
      "Databases and SQL for Data Science\n",
      "with Python\n",
      "Data Analysis with Python\n",
      "Data Visualization with Python\n",
      "Machine Learning with Python\n",
      "Applied Data Science CapstoneJul 19, 2022\n",
      "Sayam Kumar\n",
      "has successfully completed the online, non-credit P rofessional\n",
      "Certiﬁcate\n",
      "IBM Data Science\n",
      "In this Professional Certiﬁcate, learners developed  and honed hands-\n",
      "on skills in Data Science and Machine Learning. Lea rners started with\n",
      "an orientation of Data Science and its Methodology,  became familiar\n",
      "and used a variety of data science tools, learned P ython and SQL,\n",
      "performed Data Visualization and Analysis, and crea ted Machine\n",
      "Learning models. In the process they completed seve ral labs and\n",
      "assignments on the cloud including a Capstone Proje ct at the end to\n",
      "apply and demonstrate their knowledge and skills.\n",
      "The online specialization named in this certiﬁcate may draw on material from courses taught on-campus,  but the included\n",
      "courses are not equivalent to on-campus courses. Pa rticipation in this online specialization does not constitute enrollment\n",
      "at this university. This certiﬁcate does not confer  a University grade, course credit or degree, and i t does not verify the\n",
      "identity of the learner.\n",
      "Verify this certiﬁcate at: \n",
      "https://coursera.org/verify/profession\n",
      "al-cert/4UVFLGUEDBCU\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Certifications.pdf\n",
      "Page No: 3\n",
      "Content: 5 Courses\n",
      "Python for Data Science, AI\n",
      "& Development\n",
      "Python Project for Data\n",
      "Science\n",
      "Data Analysis with Python\n",
      "Data Visualization with\n",
      "Python\n",
      "Applied Data Science\n",
      "Capstone\n",
      "Yan Luo \n",
      "Ph.D., Data Scientist\n",
      "and DeveloperSaishruthi Swaminathan \n",
      "Data Scientist \n",
      "IBM CODAIT\n",
      "Azim Hirjani \n",
      "Cognitive Data ScientistDr. Pooja \n",
      "Instructor and Subject\n",
      "Matter Expert \n",
      "Skill-Up Technologies\n",
      "Joseph Santarcangelo  \n",
      "Senior Data Scientist \n",
      "IBM\n",
      "Oct 11, 2023\n",
      "Sayam Kumar\n",
      "has successfully completed the online, non-credit S pecialization\n",
      "Applied Data Science\n",
      "In this specialization learners developed and honed  skills for practical\n",
      "data science and machine learning problems. The spe cialization\n",
      "included learning Python, as well as performing dat a analysis, and\n",
      "creating data visualizations using Python. Learners  also completed a\n",
      "Capstone project to apply and demonstrate their new ly acquired\n",
      "knowledge and skills.\n",
      "The online specialization named in this certiﬁcate may draw on material from courses taught on-campus,  but the included\n",
      "courses are not equivalent to on-campus courses. Pa rticipation in this online specialization does not constitute enrollment\n",
      "at this university. This certiﬁcate does not confer  a University grade, course credit or degree, and i t does not verify the\n",
      "identity of the learner.\n",
      "Verify this certiﬁcate at: \n",
      "https://coursera.org/verify/specializat\n",
      "ion/HVVS6YSZCMJC\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\ER Diagaram Assignment .pdf\n",
      "Page No: 0\n",
      "Content: In this assignment, you have to create and ER Diagram and list out the relationships between the three tables containing sample data shown below based on a few business rules. Here are the business rules: • The Patients table stores data for individual patients. Each row represents a unique patient.  • The Health_conditions table stores data for a unique disease/health condition. Each row is unique and condition cannot be repeated in this table. However, multiple patients can have same health conditions.  • The Patient_Address table stores the address for each patient. Each address can belong to multiple patients e.g. People from a family will have the same address. Based on the above business rules, create appropriate relationships between the tables shown below. You can create new tables (to break any many to many relationships that may arise due to business rules) or add new columns to the existing tables to establish the relationships. Please ensure that each table has a unique primary key that is not repeating and relationships are established by creating a Primary Key - Foreign key relationship.  Patients    Patient_Id Patient_Last_Name Patient_First_Name  1 Smith John  2 Smith Jane  3 Vandelay Art  4 Dover Ben         Health_Conditions    Condition_Id Condition   1 Right Leg fracture   2  COPD   3 Aneurysm   4 Vein Thrombosis   5 Upper Respiratory Infections   6 Headache   7 Confusion        Patient_Address\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\ER Diagaram Assignment .pdf\n",
      "Page No: 1\n",
      "Content: Address_Id Street_Address City Province 1 2449  Algoma St Thunder Bay ONTARIO 2 327 Avenue Rd North york ONTARIO 3 222 Hardwood Road  Etobicoke ONTARIO 4 11 Maven Avenue Toronto ONTARIO\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Lab 33.pdf\n",
      "Page No: 0\n",
      "Content: BIA5001  Introduction to Statistical \n",
      "Software Languages   \n",
      "Dr. Nihad Al -Juboori  Lab 3  \n",
      "Student ID:  Student Name:  \n",
      "A – Single Dimension al list questions: Q1 and Q2  \n",
      "Q1: \n",
      "Write a function  that returns the index of the smallest and the biggest element in an array of \n",
      "integers. If there  are more than one  number  having the same value (smallest or biggest) , return \n",
      "the smallest always.  \n",
      "Write test program that prompts the user to enter 10 numbers, invokes this function  to return \n",
      "the index of the smallest and the biggest element s, and display the indices. \n",
      " \n",
      "Part 1:  Requirements Specification  \n",
      " \n",
      "The program must satisfy the following requirements:  \n",
      "• It must ask the user to enter 10 numbers . \n",
      "• Call a function  named “ indexOfElement s” that finds  the index of the smallest and \n",
      "biggest numbers.  \n",
      " \n",
      "Example:  \n",
      "Input numbers:  3 2 0 3 5 7 8 1 0 8  \n",
      "The smallest number is 0 and its index is 2 \n",
      "The biggest number is 8 and its index is 6 \n",
      " \n",
      "Part 2: Coding  \n",
      " \n",
      "Submit the following items:  \n",
      "1. Complete this Microsoft Word file and submit it on  BB.  \n",
      "2. Send the source code and snip from your run. \n",
      "Note:  you must submit the assignment  regardless of  whether it is complete  or incomplete, \n",
      "correct or incorrect.\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Lab 33.pdf\n",
      "Page No: 1\n",
      "Content: Q2: \n",
      "Write a program  that reads integers between 1 and 100 and counts the occurrence of each. \n",
      "Assume the inputs ends with 0  \n",
      "Here is a sample run:  \n",
      "1 occurs 2 times  \n",
      "2 occurs 3 times  \n",
      "3 occurs 2 times  \n",
      "4 occurs 6 times  \n",
      "40 occurs 1 time  \n",
      " \n",
      "Part 1:  Requirements Specification  \n",
      " \n",
      "The program must satisfy the following requirements:  \n",
      "• In the main function , ask the user to enter integer numbers between 1 and 100.  \n",
      "• If the user inputs  0 then the program will stop taking new numbers and start running . \n",
      " \n",
      " \n",
      "Part 2: Coding  \n",
      " \n",
      "Submit the following items:  \n",
      "1. Complete this Microsoft Word file and submit it on BB.  \n",
      "2. Send the source code and snip from your run. \n",
      "Note:  you must submit the assignment regardless of  whether it complete or incomplete, \n",
      "correct or incorrect.\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Lab 33.pdf\n",
      "Page No: 2\n",
      "Content: B – Two -Dimensional list questions: Q3 and Q4  \n",
      "Q3: \n",
      "Write a program that will initialize a list of two dimensions and perform the following actions:  \n",
      "1- sum the elements of the columns.  \n",
      "2- Sum the elements of the rows  \n",
      "3- Find the largest value of the summations for the rows and columns.  \n",
      "4- Print the list and print the maximum value in rows and the index of the row and the \n",
      "maximum value in columns and the index of the column.  \n",
      "Part 1:  Requirements Specification  \n",
      " \n",
      "The program must satisfy the following requirements:  \n",
      "• It must ask the user to enter elements of the array . \n",
      "• Call a function to find the summation of the rows and columns.  \n",
      "• Print the result.   \n",
      " \n",
      "Example:  \n",
      "For the following 3 X 3 list:  \n",
      "1 2 3 \n",
      "4 5 6 \n",
      "7 8 9 \n",
      " \n",
      "The program will print:  \n",
      "The maximum value in rows is 24 in row 2  \n",
      "The maximum value in columns is 18 in column 2  \n",
      " \n",
      "Part 2: Coding  \n",
      " \n",
      "Submit the following items:  \n",
      "1. Complete this Microsoft Word file and submit it on BB.  \n",
      "2. Send the source code and snip from your run.  \n",
      "Note:  you must submit the assignment regardless of whether it is complete  or incomplete, \n",
      "correct,  or incorrect.\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Lab 33.pdf\n",
      "Page No: 3\n",
      "Content: Q2: \n",
      "Write a program that will add two matrices that the user will input , assume these two matrices \n",
      "are of the same size . \n",
      " \n",
      "Part 1:  Requirements Specification  \n",
      " \n",
      "The program must satisfy the following requirements:  \n",
      "• In the main method,  ask the user to enter the two matrices.  \n",
      "•  Add the two matrices in a separate function.  \n",
      " \n",
      "**Complete part 2.  \n",
      " \n",
      "Note: You are not required to complete the Analysis and Design sections.  \n",
      " \n",
      "Part 2: Coding  \n",
      " \n",
      "Submit the following items:  \n",
      "1. Complete this Microsoft Word file and submit it on BB.  \n",
      "2. Send the source code and snip from your run.  \n",
      "Note:  you must submit the assignment regardless of whether it is complete  or incomplete, \n",
      "correct,  or incorrect.\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\LORs.pdf\n",
      "Page No: 0\n",
      "Content: Letter of Recommendation  \n",
      "It is to certify that Mr. Sayam Kumar Ref no.PS21 DA0964  S/O Mr.  Rajeev \n",
      "Kumar resident at 3/57, Street No. 3, Nirankari Colony, Delhi  has been \n",
      "serving in the organization since 15thSeptember  to 15thNovember  2021 as \n",
      "Data Analyst . \n",
      "During this tenure  Mr. Sayam Kumar remained involved in his  work like \n",
      "data scrapping, problem solving of new interns. We found he is pretty \n",
      "active in whatever task we have given to  him. He is a confident person. H e \n",
      "is professionally sound, har d-working and a devoted staff. H e has the \n",
      "motivation to take initiative in tasks and we are gratified that he has been \n",
      "helpful in the advancement of our organization.\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\LORs.pdf\n",
      "Page No: 1\n",
      "Content: ChefAtHome FoodTech LLP  \n",
      "Page | 1  \n",
      "Registered Address : 10, P.L.S. NAGAR, EXT - 2, CHINNIYAMPALAYAM, CBE, 13/G/0215375, COIMBATORE, TAMILNADU - 641046.  \n",
      "Email: chef.at.home.llp@gmail.com , Website : http://thechefathome.in/   \n",
      "  \n",
      " \n",
      "Subject: Mr. Sayam  Kumar  Applicant Reference  \n",
      "To Whom it May Concern  \n",
      " \n",
      " \n",
      "I highly recommend M r. Sayam  Kumar as a candidate for employment. Mr. Sayam  \n",
      "Kumar was employed by ChefAtHome Foodtech LLP as  Data Analyst Intern from 18th \n",
      "October  2021, to 18th December 2021. Mr. Sayam  Kumar was responsible for data \n",
      "exploration, data extraction of 4 regional cuisines in Chennai, analyzing  extracted data \n",
      "and reporting the data to product team.  \n",
      " \n",
      "Mr. Sayam  Kumar  has excellent communication ski lls. In addition,  He is extremely \n",
      "organized,  and reliable.  Mr. Sayam  Kumar can work  independently  and is able to follow \n",
      "through  to ensure  that the job gets done.  He is flexible  and willing  to work  on any project \n",
      "that is assigned to  him. \n",
      " \n",
      "Mr. Sayam Kumar would be a tremendous asset to your company and has my highest \n",
      "recommendation. If you have any further questions with regard to his background or \n",
      "qualifications, please do not hesitate to call me.  \n",
      " \n",
      " \n",
      "Regards,  \n",
      " \n",
      " \n",
      " \n",
      " \n",
      " \n",
      "Sharuq N A  \n",
      "CEO  \n",
      "ChefAtHome FoodTech LLP \n",
      "sharuq.kehtech@gmail.com  \n",
      "http://thechefathome.in/\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\LORs.pdf\n",
      "Page No: 2\n",
      "Content: Letter of Recommendation   \n",
      " \n",
      "It gives me immense pleasure to write a letter of recommendation for Sayam Kumar. I instructed  \n",
      "him the subject of Operating Systems during  his third year (2021 -22). My interaction with him has \n",
      "given me ample scope to evaluate his academic and personal capabilities.  \n",
      "Sayam is a since re and hardworking student. He takes his studies very seriously and is passionate \n",
      "about his performance. During the class discussions, he never failed to impress me with his active \n",
      "participation. His assignments were really neat, clean , and precise and he always meets the \n",
      "deadlines. His marks in-sessional  exams depicted how hard he worked on a consistent  basis. His \n",
      "eagerness  to learn and his impeccable dedication to his studies is extremely  meritorious . He was \n",
      "consistent  in attending classes and had an outstanding demeanor . In labs, he completely outshine d \n",
      "his peers with his critical and logical thinking. In the  prac tical examinations, he astonished the \n",
      "examiners with his thorough and intelligible  responses . He handled his coursework with utmost \n",
      "sincerity and worked tirelessly on the concepts discussed in the class.  \n",
      "Personally, he is a very disciplined student with a  pleasant demeanor . He has excellent \n",
      "communication and interpersonal skills and is well -liked by all. He is meticulous with his notions and \n",
      "is always willing to assist others.  \n",
      "Sayam's curiosity and will to learn set him apart from his colleagues. I appreci ate his willingness to \n",
      "listen and correct his flaws not only academically but also personally. He is a very inquisitive person \n",
      "who has a keen interest in learning about current events. He always responds positively to other \n",
      "people's suggestions. He works h ard to improve his performance levels and demonstrates \n",
      "exceptional leadership abilities, which enable him to reach greater heights. Furthermore, he \n",
      "possesses a unique ability to adapt to difficult situations.  \n",
      "Aside from his academic excellence, he was an I EEE member throughout the 2019 -20 academic year \n",
      "and actively participated in the majority of the college's events and competitions. He was truly \n",
      "active, lively, and steadfast when engaging in both cultural and technical events. He led several \n",
      "workshops for  the IEEE society and attended numerous seminars organised by the Computer Science \n",
      "Department. difficult situations  \n",
      "Sayam would certainly be a prodigious  addition to your university as he has the right mindset and \n",
      "intelligence  to perform well in Graduate Studies. I am surely  optimistic  that if provided  an \n",
      "opportunity, he is unquestionably going to be a significant  contributor as a graduate student and will \n",
      "definitely prove to be an exemplary  candidate for your acclaimed univers ity. Honestly speaking, I am \n",
      "immensely ecstatic to offer him my sturdiest commendation.  \n",
      " \n",
      "Ms. Pinki Yadav  \n",
      "Assistant Professor  \n",
      "Department of Computer Science & Engineering  \n",
      "Mobile: 9650272703  \n",
      "Email: pinky.yadav@adgitmdelhi.ac.in\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\LORs.pdf\n",
      "Page No: 3\n",
      "Content: Letter of Recommendation  \n",
      " \n",
      "Sayam Kumar is a student of Computer Science Engineering in Dr. Akhilesh Das Gupta Institute of \n",
      "Technology and Management, Delhi. I have taught him Web Technology in his third year (2021 -22). \n",
      "From what I have observed, he is diligent, sincere and really hardworking. He possesses exceptional \n",
      "academic potential and ambition that is way beyond the level at which most of the undergraduate \n",
      "students perform.  \n",
      "I must say that Sayam demonstrates an excellent interest in all his scholas tic pursuits and he is \n",
      "extremely  committed and serious about his career. From the very first day of class, he impressed me \n",
      "with his vast knowledge about a variety of concepts. He was really attentive and focused on the \n",
      "minutest things that were being taugh t and consistently asked several doubts regarding the topics. \n",
      "His willingness to learn and his immaculate dedication towards his studies is highly commendable. \n",
      "His assignments were always submitted timely and his work was precise and interesting to read. He \n",
      "was regular in attending classes and had a well -disciplined behaviour. Moreover, his performance in \n",
      "the class and sessional exams was incredible. During practical examinations, he astounded the \n",
      "examiners with his brief responses.  \n",
      "At a personal level, he has a pleasing personality as he exhibits excellent communication skills and \n",
      "his ability to connect with his peers and help them out with their doubts is completely unparalleled. \n",
      "He possesses great perseverance and never hesitates in adopting an initiative . He has an outstanding \n",
      "ability to adapt himself to a new and challenging environment. Furthermore, he possesses \n",
      "magnificent communication and interpersonal skills and is adored by all his batchmates.  \n",
      "In addition to his academic excellence, he was an IEEE  member in 2019 -20, where he actively \n",
      "participated in all the events that were organised in the college. As an individual, he is active and \n",
      "perseverant in both technical and cultural events. He has taken part in conducting several \n",
      "workshops and has attende d many seminars organised by the Department.  \n",
      "Sayam is an inquisitive and a special student who displays keen interest in gaining knowledge about \n",
      "latest advancements. He would be a tremendous addition to your university as he has the right \n",
      "attitude and inte llect to excel and succeed in Graduate education . I feel very confident that if given \n",
      "an opportunity, he will excel in his graduate studies and will prove to be an ideal candidate for your \n",
      "esteemed university.  \n",
      "I give him my strongest recommendation.  \n",
      " \n",
      "Dr. Archana Kumar  \n",
      "Professor  \n",
      "Department of Computer Science & Engineering  \n",
      "Mobile: 9810766992  \n",
      "Email: archna.kumar@adgitmdelhi.ac.in\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\LORs.pdf\n",
      "Page No: 4\n",
      "Content: 1 | Page  \n",
      "  \n",
      "Date: 29 February 2024 \n",
      "Subject: Reference Letter \n",
      "To whom it may concern \n",
      " \n",
      "I am writing this letter to highly recommend Mr. Sayam Kumar (Mechademy employee code: \n",
      "INT018) for any future endeavors in the field of Data Science. Sayam was an invaluable member \n",
      "of our team at Mechademy Engineering Solutions during his 5-month internship, where he \n",
      "demonstrated exceptional skills and dedication in the area of data science. \n",
      " \n",
      "During his internship at Mechademy, Sayam showcased his proficiency in creating regression-\n",
      "based machine learning models for tabular data. His analytical skills and attention to detail were \n",
      "evident in the accuracy and effectiveness of the models he developed. Sayam's ability to grasp \n",
      "complex concepts and apply them to real-world problems made a significant impact on the success \n",
      "of our projects. \n",
      " \n",
      "One of the key contributions made by Sayam was the development of a data cleaning script for \n",
      "raw data received from clients. His script not only enhanced the efficiency of our data \n",
      "preprocessing pipeline but also improved the overall quality and reliability of the data we worked \n",
      "with. Sayam's commitment to producing high-quality results was evident in the meticulous \n",
      "approach he took towards data cleaning. \n",
      " \n",
      "In addition to his technical skills, Sayam took the initiative to work on a stats module aimed at \n",
      "facilitating Automatic Exploratory Data Analysis (EDA). This module proved to be a valuable \n",
      "asset in streamlining the initial phases of our projects, allowing for a more comprehensive \n",
      "understanding of the data received. \n",
      " \n",
      "Beyond his technical capabilities, Sayam exhibited excellent communication and teamwork skills. \n",
      "He was proactive in seeking feedback and collaborated effectively with team members, \n",
      "contributing to a positive and collaborative work environment. \n",
      " \n",
      "In conclusion, I am confident that Sayam's skills, work ethic, and passion for data science will \n",
      "make him a valuable asset to any team or project. I wholeheartedly recommend him for any \n",
      "opportunities in the field of Data Science and am certain that he will continue to excel in his future \n",
      "endeavors. \n",
      " \n",
      "Please feel free to contact me if you require any further information. \n",
      " \n",
      "Sincerely, \n",
      " \n",
      " \n",
      "Akshay Bhardwaj \n",
      "Lead Data Scientist \n",
      "Mechademy Engineering Solutions Pvt Ltd Mechademy Engineering Solutions Pvt. Ltd.  \n",
      "S-120 Greater Kailash Part 2, New Delhi – 110048, India  \n",
      "info@mechademy.com  \n",
      "www. mechademy.com\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Mechademy Data Science Internship LOR.pdf\n",
      "Page No: 0\n",
      "Content: 1 | Page  \n",
      "  \n",
      "Date: 29 February 2024 \n",
      "Subject: Reference Letter \n",
      "To whom it may concern \n",
      " \n",
      "I am writing this letter to highly recommend Mr. Sayam Kumar (Mechademy employee code: \n",
      "INT018) for any future endeavors in the field of Data Science. Sayam was an invaluable member \n",
      "of our team at Mechademy Engineering Solutions during his 5-month internship, where he \n",
      "demonstrated exceptional skills and dedication in the area of data science. \n",
      " \n",
      "During his internship at Mechademy, Sayam showcased his proficiency in creating regression-\n",
      "based machine learning models for tabular data. His analytical skills and attention to detail were \n",
      "evident in the accuracy and effectiveness of the models he developed. Sayam's ability to grasp \n",
      "complex concepts and apply them to real-world problems made a significant impact on the success \n",
      "of our projects. \n",
      " \n",
      "One of the key contributions made by Sayam was the development of a data cleaning script for \n",
      "raw data received from clients. His script not only enhanced the efficiency of our data \n",
      "preprocessing pipeline but also improved the overall quality and reliability of the data we worked \n",
      "with. Sayam's commitment to producing high-quality results was evident in the meticulous \n",
      "approach he took towards data cleaning. \n",
      " \n",
      "In addition to his technical skills, Sayam took the initiative to work on a stats module aimed at \n",
      "facilitating Automatic Exploratory Data Analysis (EDA). This module proved to be a valuable \n",
      "asset in streamlining the initial phases of our projects, allowing for a more comprehensive \n",
      "understanding of the data received. \n",
      " \n",
      "Beyond his technical capabilities, Sayam exhibited excellent communication and teamwork skills. \n",
      "He was proactive in seeking feedback and collaborated effectively with team members, \n",
      "contributing to a positive and collaborative work environment. \n",
      " \n",
      "In conclusion, I am confident that Sayam's skills, work ethic, and passion for data science will \n",
      "make him a valuable asset to any team or project. I wholeheartedly recommend him for any \n",
      "opportunities in the field of Data Science and am certain that he will continue to excel in his future \n",
      "endeavors. \n",
      " \n",
      "Please feel free to contact me if you require any further information. \n",
      " \n",
      "Sincerely, \n",
      " \n",
      " \n",
      "Akshay Bhardwaj \n",
      "Lead Data Scientist \n",
      "Mechademy Engineering Solutions Pvt Ltd Mechademy Engineering Solutions Pvt. Ltd.  \n",
      "S-120 Greater Kailash Part 2, New Delhi – 110048, India  \n",
      "info@mechademy.com  \n",
      "www. mechademy.com\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Tax Information checklist.pdf\n",
      "Page No: 0\n",
      "Content: 2023 Personal Tax Information form  \n",
      "www.Taxes4u.ca  Taxes4u.ca@gmail.com  Contact: +1 647 291 1461   \n",
      "  \n",
      " \n",
      " \n",
      " \n",
      " \n",
      " \n",
      "Hi, Taxes4u.ca  \n",
      "Email: Taxes4u.ca@gmail.com or iti@taxes4u.ca \n",
      "Website: www.taxes4u.ca Phone: 6472911461 \n",
      " \n",
      "Re: Information Request for Your 2023 Income Tax and Benefit Return (T1) \n",
      " \n",
      "Part A: All your Income slips, Investments slips and Tuition fees for 2023 \n",
      " \n",
      "It is the time of the year to gather information and prepare for your personal income tax return for the \n",
      "2023 tax year. In order for us to prepare your 2023 income tax return, please provide the following \n",
      "income tax slips for the 2023 tax year (if applicable), the corresponding provincial slips, and any other \n",
      "slips that you have received for the year. \n",
      "1. T4: Statement of Remuneration Paid \n",
      "2. T4A: Statement of Pension, Retirement, Annuity, and Other Income \n",
      "3. T4A(OAS ): Statement of Old Age Security (OAS) \n",
      "4. T4A(P): Statement of Canada Pension Plan Benefits \n",
      "5. T4A-RCA: Statement of Distributions from a Retirement Compensation Arrangement (RCA) \n",
      "6. T4E: Statement of Employment Insurance and Other Benefits \n",
      "7. T4PS: Statement of Employee Profit-Sharing Plan Allocations and Payments \n",
      "8. T4RIF: Statement of Income From a Registered Retirement Income Fund \n",
      "9. T4RSP: Statement of RRSP Income \n",
      "10. T5: Statement of Investment Income \n",
      "11. T5007: Statement of Benefits \n",
      "12. T5008: Statement of Securities \n",
      "13. Transactions T5013: Statement of Partnership Income \n",
      "14. RC210: Canada Workers Benefit Advance Payments Statement \n",
      "15. RRSP: Registered Retirement Savings Plan (RRSP) contributions made between March and \n",
      "December of 2023, or during the first 60 days of 2023+1 \n",
      "16. T2202: Tuition and Enrolment Certificate \n",
      "17. TL11A/C/D : Tuition and Enrolment Certificate - University Outside Canada / Commuter to \n",
      "the United States / Educational Institutions Outside Canada for a Deemed Resident of Canada \n",
      "(if applicable) \n",
      " \n",
      "Part B: All your business activities, Foreign Incomes and Other expenses \n",
      "In addition, please provide us with the following information for the 2023 tax year (if applicable): \n",
      "1. Notice of (Re)Assessment (s) (NOA) for the previous tax year \n",
      "2. Statements for your investmen ts (shares, mutual funds, bonds, debentures, promissory \n",
      "notes, etc.) for any dispositions in the year \n",
      "3. Information for any other dispositions (real estate, depreciable properties, qualified farm or \n",
      "fishing properties, qualified small business corporation shares, etc.) \n",
      "4. Income and expenses from business or professional activities \n",
      "5. Income and expenses from rental activities \n",
      "6. Foreign income (employment, investment, pension, etc.), capital gains or losses, foreign \n",
      "taxes paid, etc. Employment expenses\n",
      "------------------------------------------------------------------------------------------------------------------------\n",
      "Page Source: pdf_files\\Tax Information checklist.pdf\n",
      "Page No: 1\n",
      "Content: 2023 Personal Tax Information form  \n",
      "www.Taxes4u.ca  Taxes4u.ca@gmail.com  Contact: +1 647 291 1461   \n",
      " \n",
      "Iti Patel CPA, CA, MBA  \n",
      "Part C: Other expenses \n",
      " \n",
      "1. Medical expenses for yourself, and your spouse or common-law partner (if applicable) \n",
      "Medical expenses for dependents \n",
      "2. Official tax receipts for donations made by yourself, and your spouse Receipts for political \n",
      "contributions made in the year (if applicable) \n",
      "3. Receipts and/or statements for the amounts paid regarding rent or property tax Federal \n",
      "and/or provincial tax instalments made \n",
      "4. Employment expenses, if you are commissioned employee or contractor or work from home.  \n",
      "5. Annual union, professional, or like dues \n",
      "6. Carrying charges and interest expenses \n",
      "7. Seniors home safety: If you spent money to make home safe and you are a above 65 \n",
      "years or older, please provide that amount . \n",
      "8. Covid 19: Benefits Repayment please provide repayments amount. \n",
      "Part D: General Information \n",
      " \n",
      "Are you are filing tax with us for the first time? Please provide below information  \n",
      "1. Your Full Name \n",
      "2. SIN No. \n",
      "3. Address \n",
      "4. Marital status \n",
      "5. Date of Birth \n",
      "6. Dependents (e.g. new child, parents or other dependants supported by you) Name, Relation, \n",
      "Date of Birth and relation \n",
      "7. Residency status (if changed in 2023/date of landing) \n",
      "8. Direct deposit information (if you want to get refund directly to bank account) \n",
      " \n",
      " \n",
      "Worked with us Before, please provide below information, only if updated from last tax year:  \n",
      "Please notify us and provide information if any of the following has changed from prior year: \n",
      " \n",
      "1. Name Change \n",
      "2. SIN No. (changed from temporary to permanent) \n",
      "3. Date of Birth \n",
      "4. Address \n",
      "5. Marital status \n",
      "6. New Dependents information (e.g. new child, parents or other dependants supported by \n",
      "you) Name, Relation, Date of Birth and relation \n",
      "7. Residency status changed? \n",
      "8. Direct deposit information (if you want to get refund directly to bank account) \n",
      " \n",
      "If you have any questions about your income tax returns, please contact me at 6472911461 \n",
      "Sincerely,\n",
      "------------------------------------------------------------------------------------------------------------------------\n"
     ]
    }
   ],
   "source": [
    "for x in pdfs:\n",
    "    print(\"Page Source:\",x.metadata['source'])\n",
    "    print(\"Page No:\",x.metadata['page'])\n",
    "    print(\"Content:\",x.page_content)\n",
    "    print('----'*30)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}