Python Forum
Census geocoding services API. How do I import output into dataframe?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Census geocoding services API. How do I import output into dataframe?
#4
This was answered in Stack Overflow. The full code working code can be found below.

import requests
import pandas as pd
import io
import csv
url = 'https://geocoding.geo.census.gov/geocoder/geographies/addressbatch'
payload = {'benchmark':'Public_AR_Current','vintage':'Current_Current'}
files = {'addressFile': ('C:\PYTHON_CLASS\CSV\ADDRESS_SAMPLE.csv', open('C:\PYTHON_CLASS\CSV\ADDRESS_SAMPLE.csv', 'rb'), 'text/csv')}
s = requests.post(url, files=files, data = payload)
df = pd.read_csv(io.StringIO(s.text), sep=',', header=None, quoting=csv.QUOTE_ALL)
with pd.option_context(
    'display.width', None, 
    'display.max_columns', None,
    'display.max_colwidth', -1,
    'display.colheader_justify', 'left'):
    print(df)
Reply


Messages In This Thread
RE: Census geocoding services API. How do I import output into dataframe? - by SAS2PYTHON - Nov-10-2020, 11:10 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Import output from python script to another varietyjones 1 1,920 Oct-12-2020, 09:07 PM
Last Post: bowlofred
  Import Text, output curve geometry Alyner 0 1,993 Feb-03-2020, 03:05 AM
Last Post: Alyner
  Suggestions Needed For Free Hosting Services for my non-Django App Loophole16 2 6,438 Oct-05-2016, 06:04 PM
Last Post: Loophole16

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020