Overview

Dataset statistics

Number of variables4
Number of observations1276
Missing cells9
Missing cells (%)0.2%
Total size in memory40.0 KiB
Average record size in memory32.1 B

Variable types

Numeric2
Categorical2

Alerts

language has constant value "en" Constant
comments has a high cardinality: 1248 distinct values High cardinality
ticket_id has unique values Unique
csat_score has 487 (38.2%) zeros Zeros

Reproduction

Analysis started2023-10-29 20:16:01.654890
Analysis finished2023-10-29 20:16:01.812556
Duration0.16 seconds
Software versionpandas-profiling v3.1.0
Download configurationconfig.json

Variables

ticket_id
Real number (ℝ≥0)

UNIQUE

Distinct1276
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.353220213 × 1013
Minimum4.353220203 × 1013
Maximum4.353220222 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.1 KiB
2023-10-29T20:16:01.948573image/svg+xmlMatplotlib v3.4.2, https://matplotlib.org/

Quantile statistics

Minimum4.353220203 × 1013
5-th percentile4.353220205 × 1013
Q14.353220209 × 1013
median4.353220214 × 1013
Q34.353220218 × 1013
95-th percentile4.353220221 × 1013
Maximum4.353220222 × 1013
Range188927
Interquartile range (IQR)88159.75

Descriptive statistics

Standard deviation52391.4578
Coefficient of variation (CV)1.203510395 × 10-9
Kurtosis-1.046417059
Mean4.353220213 × 1013
Median Absolute Deviation (MAD)44177.5
Skewness-0.2040907684
Sum5.554708992 × 1016
Variance2744864850
MonotonicityNot monotonic
2023-10-29T20:16:02.098174image/svg+xmlMatplotlib v3.4.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4.353220203 × 10131
 
0.1%
4.353220221 × 10131
 
0.1%
4.353220212 × 10131
 
0.1%
4.353220211 × 10131
 
0.1%
4.35322021 × 10131
 
0.1%
4.353220209 × 10131
 
0.1%
4.353220209 × 10131
 
0.1%
4.353220208 × 10131
 
0.1%
4.353220204 × 10131
 
0.1%
4.353220219 × 10131
 
0.1%
Other values (1266)1266
99.2%
ValueCountFrequency (%)
4.353220203 × 10131
0.1%
4.353220203 × 10131
0.1%
4.353220203 × 10131
0.1%
4.353220203 × 10131
0.1%
4.353220203 × 10131
0.1%
ValueCountFrequency (%)
4.353220222 × 10131
0.1%
4.353220222 × 10131
0.1%
4.353220222 × 10131
0.1%
4.353220222 × 10131
0.1%
4.353220222 × 10131
0.1%

csat_score
Real number (ℝ≥0)

ZEROS

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.473354232
Minimum0
Maximum4
Zeros487
Zeros (%)38.2%
Negative0
Negative (%)0.0%
Memory size10.1 KiB
2023-10-29T20:16:02.217812image/svg+xmlMatplotlib v3.4.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median4
Q34
95-th percentile4
Maximum4
Range4
Interquartile range (IQR)4

Descriptive statistics

Standard deviation1.943938602
Coefficient of variation (CV)0.7859523626
Kurtosis-1.764849246
Mean2.473354232
Median Absolute Deviation (MAD)0
Skewness-0.4877698613
Sum3156
Variance3.778897289
MonotonicityNot monotonic
2023-10-29T20:16:02.311080image/svg+xmlMatplotlib v3.4.2, https://matplotlib.org/
Histogram with fixed size bins (bins=2)
ValueCountFrequency (%)
4789
61.8%
0487
38.2%
ValueCountFrequency (%)
0487
38.2%
4789
61.8%
ValueCountFrequency (%)
4789
61.8%
0487
38.2%

comments
Categorical

HIGH CARDINALITY

Distinct1248
Distinct (%)98.5%
Missing9
Missing (%)0.7%
Memory size10.1 KiB
Quick response
 
3
very helpful
 
3
Issue not resolved
 
3
Quick response
 
2
not resolved
 
2
Other values (1243)
1254 

Unique

Unique1232 ?
Unique (%)97.2%

Sample

1st rowI got the help
2nd rowQuick and perfect solution.
3rd rowreally quick response
4th rowi cannot connect our accounting system to pleo...i have tried in edge and google
5th rowFast, helpful advice

Common Values

ValueCountFrequency (%)
Quick response3
 
0.2%
very helpful3
 
0.2%
Issue not resolved3
 
0.2%
Quick response 2
 
0.2%
not resolved2
 
0.2%
Very helpful2
 
0.2%
Helpful and quick2
 
0.2%
Great2
 
0.2%
same problem2
 
0.2%
Quick and helpful!2
 
0.2%
Other values (1238)1244
97.5%
(Missing)9
 
0.7%

language
Categorical

CONSTANT
REJECTED

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size10.1 KiB
en
1276 

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowen
2nd rowen
3rd rowen
4th rowen
5th rowen

Common Values

ValueCountFrequency (%)
en1276
100.0%