import requests

def fetch_traffic_data():

url = "http://traffic.gov/api/flow"

response = requests.get(url)

return response.json()

import sqlite3

conn = sqlite3.connect('traffic_data.db')

cursor = conn.cursor()

cursor.execute('''CREATE TABLE IF NOT EXISTS traffic_flow (id INTEGER PRIMARY KEY AUTOINCREMENT, location TEXT, flow REAL)''')

data = fetch_traffic_data()

for record in data['records']:

cursor.execute("INSERT INTO traffic_flow (location, flow) VALUES (?, ?)", (record['location'], record['flow']))

conn.commit()

conn.close()

import pandas as pd

df = pd.read_sql_query("SELECT * FROM traffic_flow", conn)

daily_avg = df.groupby('location')['flow'].mean()

print(daily_avg)

import matplotlib.pyplot as plt

daily_avg.plot(kind='bar')

plt.title('Daily Average Traffic Flow by Location')

plt.xlabel('Location')

plt.ylabel('Average Flow')

plt.show()