Toolbox - Output table to Dataframe or CSV

Export tables from a processed document (or document shards) to a Pandas Dataframe or a CSV file.

Explore further

For detailed documentation that includes this code sample, see the following:

Code sample

Python

For more information, see the Document AI Python API reference documentation .

To authenticate to Document AI, set up Application Default Credentials. For more information, see Set up authentication for a local development environment .

  from 
  
 google.cloud.documentai_toolbox 
  
 import 
 document 
 # TODO(developer): Uncomment these variables before running the sample. 
 # Given a local document.proto or sharded document.proto in path 
 # document_path = "path/to/local/document.json" 
 # output_file_prefix = "output/table" 
 def 
  
 table_sample 
 ( 
 document_path 
 : 
 str 
 , 
 output_file_prefix 
 : 
 str 
 ) 
 - 
> None 
 : 
 wrapped_document 
 = 
 document 
 . 
 Document 
 . 
 from_document_path 
 ( 
 document_path 
 = 
 document_path 
 ) 
 print 
 ( 
 "Tables in Document" 
 ) 
 for 
 page 
 in 
 wrapped_document 
 . 
 pages 
 : 
 for 
 table_index 
 , 
 table 
 in 
 enumerate 
 ( 
 page 
 . 
 tables 
 ): 
 # Convert table to Pandas Dataframe 
 # Refer to https://pandas.pydata.org/docs/reference/frame.html for all supported methods 
 df 
 = 
 table 
 . 
 to_dataframe 
 () 
 print 
 ( 
 df 
 ) 
 output_filename 
 = 
 f 
 " 
 { 
 output_file_prefix 
 } 
 - 
 { 
 page 
 . 
 page_number 
 } 
 - 
 { 
 table_index 
 } 
 " 
 # Write Dataframe to CSV file 
 df 
 . 
 to_csv 
 ( 
 f 
 " 
 { 
 output_filename 
 } 
 .csv" 
 , 
 index 
 = 
 False 
 ) 
 # Write Dataframe to HTML file 
 df 
 . 
 to_html 
 ( 
 f 
 " 
 { 
 output_filename 
 } 
 .html" 
 , 
 index 
 = 
 False 
 ) 
 # Write Dataframe to Markdown file 
 df 
 . 
 to_markdown 
 ( 
 f 
 " 
 { 
 output_filename 
 } 
 .md" 
 , 
 index 
 = 
 False 
 ) 
 

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser .

Create a Mobile Website
View Site in Mobile | Classic
Share by: