Voice Call Quality Customer Experience (India)

Based on crowdsource data collected through MyCall app

@kaggle.arnavr10880_voice_call_quality_customer_experience_india

Table List

1 table(10.39 KB)

January Mycall 2022

@kaggle.arnavr10880_voice_call_quality_customer_experience_india.january_mycall_2022

10.39 KB
620 rows
8 columns

operator Operator	inout_travelling Inout Travelling	network_type Network Type	rating Rating	calldrop_category Calldrop Category	latitude Latitude	longitude Longitude	state_name State Name
BSNL	Indoor	3G	3	Satisfactory	-1	-1	NA
BSNL	Indoor	2G	3	Poor Voice Quality	-1	-1	NA
BSNL	Indoor	2G	3	Satisfactory	-1	-1	NA
BSNL	Indoor	3G	3	Satisfactory	-1	-1	NA
RJio	Outdoor	4G	4	Satisfactory	18.5197822	73.8561897	Maharashtra
RJio	Outdoor	4G	4	Satisfactory	18.5197822	73.8561897	Maharashtra
RJio	Outdoor	4G	4	Satisfactory	18.5197514	73.8561817	Maharashtra
RJio	Indoor	4G	4	Satisfactory	18.5197899	73.8562155	Maharashtra
RJio	Outdoor	4G	4	Satisfactory	18.5197799	73.8562287	Maharashtra
RJio	Indoor	4G	4	Satisfactory	18.5197456	73.8561782	Maharashtra


CREATE TABLE january_mycall_2022 (
  "operator" VARCHAR,
  "inout_travelling" VARCHAR,
  "network_type" VARCHAR,
  "rating" BIGINT,
  "calldrop_category" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "state_name" VARCHAR
);