Skip to content
example code and source files for ficpa.org article "Programming for Efficiency"
Python
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
excel
images image update Aug 22, 2017
pdf use fake names Aug 28, 2017
README.md
example_1_tb.py
example_2_ficpa_testimonials.py example 3 Aug 22, 2017
example_3_pdf_scrape.py example 3 Aug 22, 2017

README.md

Programming for Efficiency

This repository includes example Python code from an article written for FICPA called Programming for Efficiency.

The examples were written in Python 3.6, and require the following libraries to be installed:

  • requests
  • beautiful soup
  • openpyxl
  • pandas
  • pdfplumber

Example 1: Using Excel to prep a PBC TB for import

There are several Python libraries designed to work with Excel data, including openpyxl and pandas . While both are very powerful and useful, openpyxl is easier to perform simple Excel tasks such as reading in, editing, and saving back to Excel.

This example shows the use of openpyxl to read in the PBC trial balance, clean it up to be import-ready in a new tab, and save as a new file.

Take an example of a trial balance formatted like this:

pbc tb

After running example_1_tb.py, the output file includes a new tab with this data:

import tb

Example 2: Scraping the web

This simple code pulls down the authors and excerpt of their testimonial from the first three testimonials on FICPA's testimonials page.

This uses the requests and beautifulsoup Python libraries, which are two very powerful libraries for interacting with websites.

import requests
from bs4 import BeautifulSoup

r = requests.get('http://www.ficpa.org/Content/Members/Member-Testimonials.aspx')

soup = BeautifulSoup(r.text, 'lxml')

testimonials = soup.find_all('div', class_='testimonial-wrapper')

for testimonial in testimonials[:3]:
    author = testimonial.find(class_='testimonial-author').get_text()
    excerpt = testimonial.get_text().lstrip()
    print('Author: {}'.format(author))
    print('Exerpt: {}'.format(excerpt[:60]))
    print('-------------------------------------------------------------------')

An example of resulting output is:
Author: John Smith, CPA — Smith & Smith, LLC
Excerpt: Joining the FICPA and having the chance to participate in th
-------------------------------------------------------------------
Author: Jamie J. Johnson — J. J. Johnson & Associates, PA, CPA
Excerpt: I will always feel honored to be able to contribute – and be
-------------------------------------------------------------------
Author: Bobby L. O’Charley — Longfellow Consulting Group
Excerpt: I recently attended the 2014 University of South Florida Acc
-------------------------------------------------------------------

Example 3: Extracting tables from PDFs

This is one of my new favorite tools. pdfplumber can extract text, and even identify tables, from PDF files. This example uses the PDF file from https://www.opm.gov/policy-data-oversight/data-analysis-documentation/federal-employment-reports/reports-publications/salary-information-for-the-executive-branch.pdf

Let's say you wanted to extract the data from this table on pg 2:

pdf table

Using the Python code in example 3, the output looks like this: pdf table output

You can’t perform that action at this time.