{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "4201132e-811d-4c88-86cb-d24bb9e55549", "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": null, "id": "67e3b5f9-b662-4ba4-85fc-debc0ad33d12", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 2, "id": "b8d125cf-c22a-4a1b-8c8a-6eb5e9939969", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Clients: 11049\n", "Sessions: 828614\n" ] } ], "source": [ "clients_df = pd.read_csv('naics_tagged_client_list.csv')\n", "counseling_df = pd.read_csv('client_counsoling_sessions.csv')\n", "\n", "print(f\"Clients: {clients_df.shape[0]}\")\n", "print(f\"Sessions: {counseling_df.shape[0]}\")" ] }, { "cell_type": "code", "execution_count": 3, "id": "f8bb3f3e-7d23-45b7-b6d0-6193631590ab", "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", " \n", " \n", " \n", " \n", " \n", " \n", "
Session DateClientClient IDCounselorSession TypeContact TypeCenterPrep+ContactTotal Hours
09/30/2022 12:00 AMButler Technologies (PI704874)PI704874Towers, KateFollow-upOnline (email or chat)University of Pittsburgh SBDC4.54.5
19/30/2022 12:00 AMLouri Bean Creative (PI706063)PI706063Wholihan, MichaelInitial/NewOutreach (face-to-face)University of Pittsburgh SBDC3.03.0
29/30/2022 12:00 AMLeverage Cleaning (PI705380)PI705380Wholihan, MichaelFollow-upPhoneUniversity of Pittsburgh SBDC2.02.0
39/30/2022 12:00 AMScratch & co (PI704915)PI704915Wholihan, MichaelFollow-upOutreach (face-to-face)University of Pittsburgh SBDC3.03.0
49/30/2022 12:00 AMDiverse Industrial Solutions, LLC (IN001291)IN001291Wholihan, MichaelInitial/NewPhoneUniversity of Pittsburgh SBDC2.02.0
\n", "
" ], "text/plain": [ " Session Date Client Client ID \\\n", "0 9/30/2022 12:00 AM Butler Technologies (PI704874) PI704874 \n", "1 9/30/2022 12:00 AM Louri Bean Creative (PI706063) PI706063 \n", "2 9/30/2022 12:00 AM Leverage Cleaning (PI705380) PI705380 \n", "3 9/30/2022 12:00 AM Scratch & co (PI704915) PI704915 \n", "4 9/30/2022 12:00 AM Diverse Industrial Solutions, LLC (IN001291) IN001291 \n", "\n", " Counselor Session Type Contact Type \\\n", "0 Towers, Kate Follow-up Online (email or chat) \n", "1 Wholihan, Michael Initial/New Outreach (face-to-face) \n", "2 Wholihan, Michael Follow-up Phone \n", "3 Wholihan, Michael Follow-up Outreach (face-to-face) \n", "4 Wholihan, Michael Initial/New Phone \n", "\n", " Center Prep+Contact Total Hours \n", "0 University of Pittsburgh SBDC 4.5 4.5 \n", "1 University of Pittsburgh SBDC 3.0 3.0 \n", "2 University of Pittsburgh SBDC 2.0 2.0 \n", "3 University of Pittsburgh SBDC 3.0 3.0 \n", "4 University of Pittsburgh SBDC 2.0 2.0 " ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "counseling_df.head()" ] }, { "cell_type": "code", "execution_count": 4, "id": "6cd5bca1-8895-4133-a71e-1a9e9cdd9f71", "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", " \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", "
Unnamed: 0ClientClient IDCounty Out of StateEmailLast CounselingNAICsPhonePhysical AddressPhysical Address CountyPhysical Address StatePrimary ContactPrimary NAICSNAICS_2PA NAICs Code PercentagePASBDC NAICs Code Percentage
00\\tProinnov@ LLC (WD04170)WD04170FalseJardensonC@ICLOUD.com9/9/2025 12:00 AMNaN(267) 748-44656752 Oakland St.PhiladelphiaPennsylvaniaJardenson CastroNaN0.00.00000014.915377
11\"C.J.A.\"/ Crawley Jones and Allen real estate...WD02759Falsemrkcrawley@gmail.com10/20/2025 12:00 AM531390-OtherActivitiesRelatedtoRealEstate\\r\\r\\...(215) 290-9828673 Rively aveDelawarePennsylvaniamark crawley531390 - Other Activities Related to Real Esta...53.02.5101272.688026
22Anjie's Cleaning Bees (PS018402)PS018402Falseanjelicagonzalez2001@gmail.com10/14/2024 12:00 AM561720-JanitorialServices\\r\\r\\n\\r\\r\\n(717) 521-36251129 High StLycomingPennsylvaniaAnjelica Gonzez561720 - Janitorial Services \\r\\r\\n56.03.6056474.344285
33BRENIMAN PROPERTIES, LLC (C8538)C8538Falser_breniman@yahoo.com10/17/2025 12:00 AM531120-LessorsofNonresidentialBuildings(except...NaN147 Heeter RdClarionPennsylvaniaRYAN BRENIMAN531120 - Lessors of Nonresidential Buildings (...53.02.5101272.688026
44Civil War Cider Co., Inc. (BU016079)BU016079Falserob@civilwarcider.com10/21/2024 12:00 AM312130-Wineries\\r\\r\\n\\r\\r\\n(570) 523-3414606 Market St.UnionPennsylvaniaRobert Antanitis, II312130 - Wineries \\r\\r\\n31.02.8763044.923522
\n", "
" ], "text/plain": [ " Unnamed: 0 Client Client ID \\\n", "0 0 \\tProinnov@ LLC (WD04170) WD04170 \n", "1 1 \"C.J.A.\"/ Crawley Jones and Allen real estate... WD02759 \n", "2 2 Anjie's Cleaning Bees (PS018402) PS018402 \n", "3 3 BRENIMAN PROPERTIES, LLC (C8538) C8538 \n", "4 4 Civil War Cider Co., Inc. (BU016079) BU016079 \n", "\n", " County Out of State Email Last Counseling \\\n", "0 False JardensonC@ICLOUD.com 9/9/2025 12:00 AM \n", "1 False mrkcrawley@gmail.com 10/20/2025 12:00 AM \n", "2 False anjelicagonzalez2001@gmail.com 10/14/2024 12:00 AM \n", "3 False r_breniman@yahoo.com 10/17/2025 12:00 AM \n", "4 False rob@civilwarcider.com 10/21/2024 12:00 AM \n", "\n", " NAICs Phone \\\n", "0 NaN (267) 748-4465 \n", "1 531390-OtherActivitiesRelatedtoRealEstate\\r\\r\\... (215) 290-9828 \n", "2 561720-JanitorialServices\\r\\r\\n\\r\\r\\n (717) 521-3625 \n", "3 531120-LessorsofNonresidentialBuildings(except... NaN \n", "4 312130-Wineries\\r\\r\\n\\r\\r\\n (570) 523-3414 \n", "\n", " Physical Address Physical Address County Physical Address State \\\n", "0 6752 Oakland St. Philadelphia Pennsylvania \n", "1 673 Rively ave Delaware Pennsylvania \n", "2 1129 High St Lycoming Pennsylvania \n", "3 147 Heeter Rd Clarion Pennsylvania \n", "4 606 Market St. Union Pennsylvania \n", "\n", " Primary Contact Primary NAICS \\\n", "0 Jardenson Castro NaN \n", "1 mark crawley 531390 - Other Activities Related to Real Esta... \n", "2 Anjelica Gonzez 561720 - Janitorial Services \\r\\r\\n \n", "3 RYAN BRENIMAN 531120 - Lessors of Nonresidential Buildings (... \n", "4 Robert Antanitis, II 312130 - Wineries \\r\\r\\n \n", "\n", " NAICS_2 PA NAICs Code Percentage PASBDC NAICs Code Percentage \n", "0 0.0 0.000000 14.915377 \n", "1 53.0 2.510127 2.688026 \n", "2 56.0 3.605647 4.344285 \n", "3 53.0 2.510127 2.688026 \n", "4 31.0 2.876304 4.923522 " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "clients_df.head()" ] }, { "cell_type": "code", "execution_count": null, "id": "694bb828-bbdc-4f6d-a002-ec9d8f603ed5", "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.13.7" } }, "nbformat": 4, "nbformat_minor": 5 }