0xpetersatoshi

with q as (
  select
    datetime,
    avg(price) as avg_price,
    avg(price/sqft) as avg_price_per_sqft,
    count(distinct link) as unique_listings
  from "craigslist"."pq_craigslist_rental_data_parquet"
  -- filter out extreme values
  where price <= (select avg(price) * 3 from "craigslist"."pq_craigslist_rental_data_parquet")
  group by 1

0xpetersatoshi

import re
import os
import json
import requests
import boto3
import numpy as np
from bs4 import BeautifulSoup
from datetime import datetime

# Create date

0xpetersatoshi

import boto3

# Set up S3 resource
s3 = boto3.resource("s3")

# Gets list of neighborhoods from s3
def build_neighborhood_list():
    """Pulls file from s3 containing the names of neighborhoods to be scraped.

    Returns:

0xpetersatoshi

Keybase proof

I hereby claim:

• I am pbegle on github.
• I am pbegle (https://keybase.io/pbegle) on keybase.
• I have a public key ASCRoXCYMAi9SrcigSFKLQ-KYE5HkPPz8KKBz8TUSUuWeQo

To claim this, I am signing this object: