Skip to content
TheChatArchiveThe Chat Archive
gpt-4o-2024-08-06· OpenAIAi2 WildChat-4.8M (AI2)

can you write a code which exract shipping address from the pdf and then export to excel…

  1. User

    can you write a code which exract shipping address from the pdf and then export to excel file in such a format that first column contain the Name,second column contain phone number, third column contain the address and fourth column contain city . make sure all the shipping addressess in the pdf should export to excel complete and correct

  2. Assistant

    To extract shipping addresses from a PDF and export them to an Excel file, you will need to use a combination of Python libraries such as PyPDF2 for PDF processing, re for regular expressions, and pandas for Excel file generation. Before proceeding, make sure these libraries are installed:

    pip install PyPDF2 pandas openpyxl
    

    Here is a Python script that reads a PDF, extracts shipping addresses, and writes them into an Excel file:

    import re
    import PyPDF2
    import pandas as pd
    
    def extract_shipping_addresses(pdf_path):
        # Open the PDF file
        with open(pdf_path, 'rb') as file:
            pdf_reader = PyPDF2.PdfReader(file)
            
            all_text = ""
            # Iterate through all the pages in the PDF
            for page in pdf_reader.pages:
                all_text += page.extract_text()
    
        # Define a regular expression pattern to extract name, phone, address, and city
        # You will need to adjust this pattern based on the actual format of the addresses in your PDFs
        pattern = re.compile(r'Name: (.+?)\nPhone: (\d+)\nAddress: (.+?)\nCity: (.+?)\n', re.DOTALL)
    
        # Find all matches in the extracted text
        matches = pattern.findall(all_text)
        return matches
    
    def export_to_excel(addresses, excel_path):
        # Create a Pandas DataFrame from the list of addresses
        df = pd.DataFrame(addresses, columns=['Name', 'Phone', 'Address', 'City'])
        
        # Export the DataFrame to an Excel file
        df.to_excel(excel_path, index=False)
    
    def main():
        pdf_path = 'shipping_addresses.pdf'  # Path to your PDF file
        excel_path = 'shipping_addresses.xlsx'  # Path where Excel file will be saved
        
        addresses = extract_shipping_addresses(pdf_path)
        export_to_excel(addresses, excel_path)
    
    if __name__ == '__main__':
        main()
    

    Notes:

    1. Regular Expression Pattern: The pattern variable in the script is a regular expression crafted to match text in the format of "Name", "Phone", "Address", and "City". You need to adjust this pattern based on how the data is structured in your PDF files. If your data format differs, the regex needs to be updated accordingly.

    2. Quality of PDF Text Extraction: The success of text extraction from a PDF depends on how the PDF is structured. PDFs generated from scanned images may need OCR processing using libraries like pytesseract.

    3. Accuracy: Validate extracted data to ensure completeness and correctness by debugging or testing with different address formats.

    4. Environment: Ensure you have a Python environment set up with the necessary libraries. Adjust file paths as necessary to match your directory structure.