{ "cells": [ { "cell_type": "code", "execution_count": 67, "id": "2d801693", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Populating the interactive namespace from numpy and matplotlib\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "/home/georg/venvs/ml/lib/python3.8/site-packages/IPython/core/magics/pylab.py:159: UserWarning: pylab import has clobbered these variables: ['f']\n", "`%matplotlib` prevents importing * from pylab and numpy\n", " warn(\"pylab import has clobbered these variables: %s\" % clobbered +\n" ] } ], "source": [ "%pylab inline" ] }, { "cell_type": "code", "execution_count": 75, "id": "aee2f26a", "metadata": {}, "outputs": [], "source": [ "import json\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 82, "id": "145312e7", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "fm\n", "11261\n", "11261\n", "am\n", "4690\n", "4690\n", "tv\n", "3688\n", "3688\n" ] } ], "source": [ "with open(\"tmp_data.json\") as f:\n", " data = json.load(f)\n", "\n", "parsed_data = {}\n", "for k, v in data.items():\n", " print(k)\n", " print(len(v))\n", " print(len([True for kk, vv in v.items() if vv[\"status\"] == \"OK\"]))\n", " parsed_data[k] = []\n", " for kk, vv in v.items():\n", " d = vv[\"results\"][\"facility\"]\n", " if \"mainStudioContact\" not in d:\n", " continue\n", " parsed_data[k].append((\n", " d[\"callSign\"], \n", " d[\"communityCity\"], \n", " d[\"communityState\"], \n", " d[\"partyName\"], \n", " d[\"mainStudioContact\"].get(\"contactWebsite\", \"\"),\n", " d[\"mainStudioContact\"].get(\"contactName\", \"\"),\n", " d[\"mainStudioContact\"].get(\"contactEmail\", \"\"),\n", " d[\"mainStudioContact\"].get(\"contactPhone\", \"\"),\n", " ))" ] }, { "cell_type": "code", "execution_count": 70, "id": "6a23dd4d", "metadata": {}, "outputs": [], "source": [ "fm_df = pd.DataFrame(\n", " parsed_data[\"fm\"], \n", " columns=[\n", " \"call_sign\", \"community_city\", \"community_state\", \"party_name\", \n", " \"contact_website\", \"contact_name\", \"contact_email\", \"contact_phone\",\n", " ],\n", ")" ] }, { "cell_type": "code", "execution_count": 71, "id": "d8c614c0", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
call_signcommunity_citycommunity_stateparty_namecontact_websitecontact_namecontact_emailcontact_phone
0KCHA-FMCHARLES CITYIACOLOFF MEDIA, LLChttps://kchanews.comChris Bergchris@coloffmedia.com(641) 228-1000
1KFFFBENNINGTONNEIHM LICENSES, LLCwolfradio933.iheart.comBecca SautterDisabilityAccessContact@iheartmedia.com1(402)561-2000
\n", "
" ], "text/plain": [ " call_sign community_city community_state party_name \\\n", "0 KCHA-FM CHARLES CITY IA COLOFF MEDIA, LLC \n", "1 KFFF BENNINGTON NE IHM LICENSES, LLC \n", "\n", " contact_website contact_name \\\n", "0 https://kchanews.com Chris Berg \n", "1 wolfradio933.iheart.com Becca Sautter \n", "\n", " contact_email contact_phone \n", "0 chris@coloffmedia.com (641) 228-1000 \n", "1 DisabilityAccessContact@iheartmedia.com 1(402)561-2000 " ] }, "execution_count": 71, "metadata": {}, "output_type": "execute_result" } ], "source": [ "fm_df.head(2)" ] }, { "cell_type": "code", "execution_count": 72, "id": "4749d4bc", "metadata": {}, "outputs": [], "source": [ "fm_df.to_csv(\"fm_stations.csv\", index=False)" ] }, { "cell_type": "code", "execution_count": 86, "id": "418aba1b", "metadata": {}, "outputs": [], "source": [ "am_df = pd.DataFrame(\n", " parsed_data[\"am\"], \n", " columns=[\n", " \"call_sign\", \"community_city\", \"community_state\", \"party_name\", \n", " \"contact_website\", \"contact_name\", \"contact_email\", \"contact_phone\",\n", " ],\n", ")" ] }, { "cell_type": "code", "execution_count": 87, "id": "de396e94", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
call_signcommunity_citycommunity_stateparty_namecontact_websitecontact_namecontact_emailcontact_phone
0WEPMMARTINSBURGWVWEST VIRGINIA RADIO CORPORATION OF THE ALLEGHE...
1WRAYPRINCETONINPRINCETON BROADCASTING CO., INC.
2KBSRLAURELMTSUN MOUNTAIN, INC.
3KPROMARSHALLTXRCA BROADCASTING LLCScottie Ricekyxydj@yahoo.com8582127968
4KTKKSANDYUTUNITED BROADCASTING COMPANY, INC
\n", "
" ], "text/plain": [ " call_sign community_city community_state \\\n", "0 WEPM MARTINSBURG WV \n", "1 WRAY PRINCETON IN \n", "2 KBSR LAUREL MT \n", "3 KPRO MARSHALL TX \n", "4 KTKK SANDY UT \n", "\n", " party_name contact_website \\\n", "0 WEST VIRGINIA RADIO CORPORATION OF THE ALLEGHE... \n", "1 PRINCETON BROADCASTING CO., INC. \n", "2 SUN MOUNTAIN, INC. \n", "3 RCA BROADCASTING LLC \n", "4 UNITED BROADCASTING COMPANY, INC \n", "\n", " contact_name contact_email contact_phone \n", "0 \n", "1 \n", "2 \n", "3 Scottie Rice kyxydj@yahoo.com 8582127968 \n", "4 " ] }, "execution_count": 87, "metadata": {}, "output_type": "execute_result" } ], "source": [ "am_df.head()" ] }, { "cell_type": "code", "execution_count": 88, "id": "78d4e05d", "metadata": {}, "outputs": [], "source": [ "am_df.to_csv(\"us_am_stations.csv\", index=False)" ] }, { "cell_type": "code", "execution_count": 83, "id": "a62ceb8d", "metadata": {}, "outputs": [], "source": [ "tv_df = pd.DataFrame(\n", " parsed_data[\"tv\"], \n", " columns=[\n", " \"call_sign\", \"community_city\", \"community_state\", \"party_name\", \n", " \"contact_website\", \"contact_name\", \"contact_email\", \"contact_phone\",\n", " ],\n", ")" ] }, { "cell_type": "code", "execution_count": 85, "id": "7a3d2324", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
call_signcommunity_citycommunity_stateparty_namecontact_websitecontact_namecontact_emailcontact_phone
0WPHY-CDTRENTONNJRNN NATIONAL, LLCgregzanoni@wphytv.com6095872500
1K31KK-DKINGSVILLE-ALICETXSCRIPPS BROADCASTING HOLDINGS LLCwww.telemundocc.comPhil Brooksphil.brooks@kristv.com361-886-6100
\n", "
" ], "text/plain": [ " call_sign community_city community_state \\\n", "0 WPHY-CD TRENTON NJ \n", "1 K31KK-D KINGSVILLE-ALICE TX \n", "\n", " party_name contact_website contact_name \\\n", "0 RNN NATIONAL, LLC \n", "1 SCRIPPS BROADCASTING HOLDINGS LLC www.telemundocc.com Phil Brooks \n", "\n", " contact_email contact_phone \n", "0 gregzanoni@wphytv.com 6095872500 \n", "1 phil.brooks@kristv.com 361-886-6100 " ] }, "execution_count": 85, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tv_df.head(2)" ] }, { "cell_type": "code", "execution_count": 89, "id": "dde698f8", "metadata": {}, "outputs": [], "source": [ "tv_df.to_csv(\"us_tv_stations.csv\", index=False)" ] }, { "cell_type": "code", "execution_count": null, "id": "1d2aba8d", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "87308fcc", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "f9769d79", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.10" } }, "nbformat": 4, "nbformat_minor": 5 }