Done.
Total PA home services businesses: 1286
Business_Name City State Categories Rating Review_Count
0 Absolutely Perfect Inc Bensalem PA Masonry/Concrete, Gardeners, Lawn Services, Tr... 3.5 5
1 A-1 Expert Cleaning Services Levittown PA Home Cleaning, Home Services, Office Cleaning,... 5.0 5
2 Zakian Rug Cleaning Philadelphia PA Carpet Cleaning, Rugs, Shopping, Flooring, Loc... 3.5 26
3 A Personal Touch Cleaning Service Villanova PA Carpet Cleaning, Local Services, Home Services... 4.5 7
4 Draino Philadelphia PA Plumbing, Home Services 3.0 10 
Service_Type
Cleaning       539
HVAC           316
Landscaping    152
Roofing        144
Plumbing       135
Name: count, dtype: int64
County
Philadelphia    476
Name: count, dtype: int64
County Service_Type Business_Count
0 Philadelphia Cleaning 253
1 Philadelphia HVAC 87
2 Philadelphia Landscaping 23
3 Philadelphia Plumbing 53
4 Philadelphia Roofing 60
Service_Type Cleaning HVAC Landscaping Plumbing Roofing
County
Philadelphia 253 87 23 53 60
No description has been provided for this image
County Service_Type Avg_Rating Avg_Reviews
0 Philadelphia Cleaning 3.519763 21.450593
1 Philadelphia HVAC 3.758621 27.632184
2 Philadelphia Landscaping 3.956522 24.173913
3 Philadelphia Plumbing 3.716981 22.433962
4 Philadelphia Roofing 3.325000 12.983333
County Service_Type Business_Count Total_Count Service_Share Avg_Rating Avg_Reviews
0 Philadelphia Cleaning 253 476 0.531513 3.519763 21.450593
1 Philadelphia HVAC 87 476 0.182773 3.758621 27.632184
2 Philadelphia Landscaping 23 476 0.048319 3.956522 24.173913
3 Philadelphia Plumbing 53 476 0.111345 3.716981 22.433962
4 Philadelphia Roofing 60 476 0.126050 3.325000 12.983333
County Service_Type Business_Count Total_Count Service_Share Avg_Rating Avg_Reviews Opportunity_Score
4 Philadelphia Roofing 0.160870 476 0.160870 0.000000 0.000000 0.911522
3 Philadelphia Plumbing 0.130435 476 0.130435 0.620693 0.645145 0.644059
2 Philadelphia Landscaping 0.000000 476 0.000000 1.000000 0.763922 0.597216
1 Philadelphia HVAC 0.278261 476 0.278261 0.686628 1.000000 0.475299
0 Philadelphia Cleaning 1.000000 476 1.000000 0.308402 0.578015 0.257296
County B01003_001E
0 Adams 107914
1 Allegheny 1231814
2 Armstrong 63679
3 Beaver 165540
4 Berks 439117 
Index(['Population'], dtype='object')
County B01003_001E 
Index(['Business_Name', 'City', 'State', 'Categories', 'Rating',
       'Review_Count'],
      dtype='object')
             City  Business_Count
106  Philadelphia             476
142  West Chester              40
99     Norristown              26
33     Doylestown              24
137    Warminster              20
81       Lansdale              19
66      Havertown              18
6        Bensalem              18
95        Newtown              17
83      Levittown              17

Businesses with unknown county: 810
         County  Business_Count
0  Philadelphia             476
No description has been provided for this image 
         County    Rating  Review_Count
0  Philadelphia  3.581933         10355
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image
No description has been provided for this image 
<Figure size 640x480 with 0 Axes>

Pennsylvania Business Overview – Summary This analysis examined businesses across major cities in Pennsylvania using the provided dataset. Key steps included mapping cities to counties, aggregating business counts, computing average ratings, and summing review totals. Key Insights: Business Distribution: Philadelphia and Allegheny counties have the highest number of businesses, reflecting their population and economic activity. Average Ratings: Some counties with fewer businesses show higher average ratings, suggesting smaller markets may maintain higher customer satisfaction. Review Volume: The total number of reviews per county correlates with business density but also highlights counties with highly engaged customer bases. Visualization: The bubble plot combines three dimensions: X-axis: Number of businesses Y-axis: Average rating Bubble size: Total review count Color: County Conclusion: This visualization provides a clear overview of Pennsylvania’s county-level business landscape, helping identify where business activity is concentrated and how customer engagement varies. The analysis could support market research, business expansion decisions, or local economic studies.