Overview
Rows
44,934
Columns
4
Missing Values
0%
0 total
Duplicate Rows
36
24.29 MB in memory
Data Quality
Missing Values by Column
No missing values detected
Outlier Summary
No outliers detected (IQR method)
Distributions
Summary Statistics
| Column | Count | Mean | Std | Min | Median | Max |
|---|
Correlations
Text Analysis
Text Preprocessing Summary
Raw Tokens
1,228,164
Clean Tokens
967,675
Raw Vocabulary
15,760
Clean Vocabulary
16,104
Remove URLs (regex)Remove special characters (keep letters only)Normalize whitespaceLowercase conversionWordNet lemmatizationFilter words < 3 characters
Total Reviews
44,934
Mean Polarity
0.376
Positive
88.38%
Negative
3.32%
Top Words in Reviews
easyprocessservicecustomerhelpfulthankpolicyrecommendquestionsexcellentcoveragequickbestalwaysprofessionalexperiencenjmworkeverythingclaimansweredneededhelphelpedneverknowledgeableableuseagentplanhighlycallextremelyinformationapplicationphonejewelersexplainedfriendlyonlinerepresentativereceivedfastyearscarnewthanksgettingrighthappymutualwebsiteeveryjewelrysimplefeelcarefindfirstmedicare
Sentiment Distribution
Top Bigrams
Sentiment by Location (Polarity x 100)
LDA Topic Weights
Topic Details
Topic 1
insurancecoveragebestpolicyplanneedsoptionsrecommendhelphealth
Topic 2
easyprocessquicksimplefastapplicationwebsiteonlinefriendlyrecommend
Topic 3
helpfulknowledgeableprofessionalgreatthankagentfriendlyextremelyexperiencecompany
Topic 4
questionsansweredphonecartimecalleddidanswertookhelpful
Topic 5
insuranceusepolicycompanyjewelrymutualjewelerscoverageeasyyear
Topic 6
servicecustomergreatnjmclaimexcellentcompanygoodexperienceyears