SUMMARY AND STRUCTURE OF THE DATASET
spc_tbl_ [2,245 × 14] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
$ STATE_NAME : chr [1:2245] "Andhra Pradesh" "Andhra Pradesh" "Andhra Pradesh" "Andhra Pradesh" ...
$ DISTRICT_NAME : chr [1:2245] "Alluri Sitharama Raju" "Bapatla" "Chittoor" "Guntur" ...
$ PMGSY_SCHEME : chr [1:2245] "PM-JANMAN" "PMGSY-II" "PMGSY-III" "PMGSY-II" ...
$ NO_OF_ROAD_WORK_SANCTIONED : num [1:2245] 96 6 37 4 3 159 1 9 19 12 ...
$ NO_OF_BRIDGES_SANCTIONED : num [1:2245] 0 0 2 0 0 5 0 0 0 1 ...
$ NO_OF_ROAD_WORKS_COMPLETED : num [1:2245] 0 6 33 4 3 159 0 9 0 10 ...
$ NO_OF_BRIDGES_COMPLETED : num [1:2245] 0 0 0 0 0 5 0 0 0 1 ...
$ NO_OF_ROAD_WORKS_BALANCE : num [1:2245] 96 0 4 0 0 0 1 0 19 2 ...
$ NO_OF_BRIDGES_BALANCE : num [1:2245] 0 0 2 0 0 0 0 0 0 0 ...
$ LENGTH_OF_ROAD_WORK_SANCTIONED_KM: num [1:2245] 218.5 53.4 276.2 35.1 19.5 ...
$ COST_OF_WORKS_SANCTIONED_LAKHS : num [1:2245] 196.5 28.7 172.5 17.4 12.2 ...
$ LENGTH_OF_ROAD_WORK_COMPLETED_KM : num [1:2245] 0 53.8 228.9 34.8 19.5 ...
$ EXPENDITURE_OCCURED_LAKHS : num [1:2245] 0 24.4 104.2 13.9 10.8 ...
$ LENGTH_OF_ROAD_WORK_BALANCE_KM : num [1:2245] 218.5 0 40.2 0 0 ...
- attr(*, "spec")=
.. cols(
.. STATE_NAME = col_character(),
.. DISTRICT_NAME = col_character(),
.. PMGSY_SCHEME = col_character(),
.. NO_OF_ROAD_WORK_SANCTIONED = col_double(),
.. NO_OF_BRIDGES_SANCTIONED = col_double(),
.. NO_OF_ROAD_WORKS_COMPLETED = col_double(),
.. NO_OF_BRIDGES_COMPLETED = col_double(),
.. NO_OF_ROAD_WORKS_BALANCE = col_double(),
.. NO_OF_BRIDGES_BALANCE = col_double(),
.. LENGTH_OF_ROAD_WORK_SANCTIONED_KM = col_double(),
.. COST_OF_WORKS_SANCTIONED_LAKHS = col_double(),
.. LENGTH_OF_ROAD_WORK_COMPLETED_KM = col_double(),
.. EXPENDITURE_OCCURED_LAKHS = col_double(),
.. LENGTH_OF_ROAD_WORK_BALANCE_KM = col_double()
.. )
- attr(*, "problems")=<externalptr>
STATE_NAME DISTRICT_NAME PMGSY_SCHEME
Length:2245 Length:2245 Length:2245
Class :character Class :character Class :character
Mode :character Mode :character Mode :character
NO_OF_ROAD_WORK_SANCTIONED NO_OF_BRIDGES_SANCTIONED NO_OF_ROAD_WORKS_COMPLETED
Min. : 0.00 Min. : 0.000 Min. : 0.00
1st Qu.: 9.00 1st Qu.: 0.000 1st Qu.: 5.00
Median : 19.00 Median : 0.000 Median : 14.00
Mean : 84.15 Mean : 5.318 Mean : 80.48
3rd Qu.: 88.00 3rd Qu.: 4.000 3rd Qu.: 85.00
Max. :1263.00 Max. :220.000 Max. :1263.00
NO_OF_BRIDGES_COMPLETED NO_OF_ROAD_WORKS_BALANCE NO_OF_BRIDGES_BALANCE
Min. : 0.000 Min. : 0.000 Min. : 0.00
1st Qu.: 0.000 1st Qu.: 0.000 1st Qu.: 0.00
Median : 0.000 Median : 0.000 Median : 0.00
Mean : 4.058 Mean : 3.671 Mean : 1.26
3rd Qu.: 2.000 3rd Qu.: 3.000 3rd Qu.: 0.00
Max. :209.000 Max. :121.000 Max. :105.00
LENGTH_OF_ROAD_WORK_SANCTIONED_KM COST_OF_WORKS_SANCTIONED_LAKHS
Min. : 0.00 Min. : 0.433
1st Qu.: 65.61 1st Qu.: 39.090
Median : 138.20 Median : 87.397
Mean : 368.53 Mean : 172.911
3rd Qu.: 417.43 3rd Qu.: 191.589
Max. :4546.13 Max. :2004.872
LENGTH_OF_ROAD_WORK_COMPLETED_KM EXPENDITURE_OCCURED_LAKHS
Min. : 0.0 Min. :-267.04
1st Qu.: 47.7 1st Qu.: 25.76
Median : 111.5 Median : 62.05
Mean : 341.5 Mean : 145.50
3rd Qu.: 384.7 3rd Qu.: 153.44
Max. :4349.9 Max. :1962.22
LENGTH_OF_ROAD_WORK_BALANCE_KM
Min. : 0.00
1st Qu.: 0.00
Median : 0.00
Mean : 19.27
3rd Qu.: 13.50
Max. :571.68
STATE_NAME DISTRICT_NAME
0 0
PMGSY_SCHEME NO_OF_ROAD_WORK_SANCTIONED
0 0
NO_OF_BRIDGES_SANCTIONED NO_OF_ROAD_WORKS_COMPLETED
0 0
NO_OF_BRIDGES_COMPLETED NO_OF_ROAD_WORKS_BALANCE
0 0
NO_OF_BRIDGES_BALANCE LENGTH_OF_ROAD_WORK_SANCTIONED_KM
0 0
COST_OF_WORKS_SANCTIONED_LAKHS LENGTH_OF_ROAD_WORK_COMPLETED_KM
0 0
EXPENDITURE_OCCURED_LAKHS LENGTH_OF_ROAD_WORK_BALANCE_KM
0 0
# A tibble: 6 × 14
STATE_NAME DISTRICT_NAME PMGSY_SCHEME NO_OF_ROAD_WORK_SANCTIONED
<chr> <chr> <chr> <dbl>
1 Andhra Pradesh Alluri Sitharama Raju PM-JANMAN 96
2 Andhra Pradesh Bapatla PMGSY-II 6
3 Andhra Pradesh Chittoor PMGSY-III 37
4 Andhra Pradesh Guntur PMGSY-II 4
5 Andhra Pradesh Kakinada RCPLWEA 3
6 Andhra Pradesh Krishna PMGSY-I 159
# ℹ 10 more variables: NO_OF_BRIDGES_SANCTIONED <dbl>,
# NO_OF_ROAD_WORKS_COMPLETED <dbl>, NO_OF_BRIDGES_COMPLETED <dbl>,
# NO_OF_ROAD_WORKS_BALANCE <dbl>, NO_OF_BRIDGES_BALANCE <dbl>,
# LENGTH_OF_ROAD_WORK_SANCTIONED_KM <dbl>,
# COST_OF_WORKS_SANCTIONED_LAKHS <dbl>,
# LENGTH_OF_ROAD_WORK_COMPLETED_KM <dbl>, EXPENDITURE_OCCURED_LAKHS <dbl>,
# LENGTH_OF_ROAD_WORK_BALANCE_KM <dbl>
