difficulty in using ggplot2 on imported data set

VeyUche · March 28, 2022, 3:43pm

Error in FUN(X[[i]], ...) : object 'rice_production' not found

ggplot(data=ICRISAT_District_Level_Data)+ geom_bar(mapping=aes(x=rice_production))
Error in FUN(X[[i]], ...) : object 'rice_production' not found

i really don't know what i am doing wrongly but each time i try to plot using an imported dataset, Error in FUN(X[[i]], ...) just continues to pop up but i can comfortably do it with any dataset that is already in R
please i need some assistance with this

kindly note that i used the read_csv function to import my file and even attach it but it still won't work

FJCC · March 28, 2022, 3:47pm

Please post the output of

str(ICRISAT_District_Level_Data)

Place a line with three back ticks just before and after the output when you paste it into your reply, like this
```
Pasted output
```

VeyUche · March 28, 2022, 4:53pm

str(ICRISAT_District_Level_Data)

spec_tbl_df [12,418 x 80] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
 $ Dist Code                                  : num [1:12418] 1 1 1 1 1 1 1 1 1 1 ...
 $ Year                                       : num [1:12418] 1978 1979 1980 1981 1982 ...
 $ State Code                                 : num [1:12418] 14 14 14 14 14 14 14 14 14 14 ...
 $ State Name                                 : chr [1:12418] "Chhattisgarh" "Chhattisgarh" "Chhattisgarh" "Chhattisgarh" ...
 $ Dist Name                                  : chr [1:12418] "Durg" "Durg" "Durg" "Durg" ...
 $ RICE AREA (1000 ha)                        : num [1:12418] 612 617 635 630 628 ...
 $ RICE PRODUCTION (1000 tons)                : num [1:12418] 362 331 516 507 513 ...
 $ RICE YIELD (Kg per ha)                     : num [1:12418] 591 536 812 805 817 ...
 $ WHEAT AREA (1000 ha)                       : num [1:12418] 48.7 44.6 44.1 41.5 41.1 39.9 40.5 39.4 37 43 ...
 $ WHEAT PRODUCTION (1000 tons)               : num [1:12418] 25.6 17.8 33.6 23.6 23.9 20.6 19.9 21 24 23 ...
 $ WHEAT YIELD (Kg per ha)                    : num [1:12418] 526 399 762 569 582 ...
 $ KHARIF SORGHUM AREA (1000 ha)              : num [1:12418] 0.1 0.5 0.2 0.2 0.1 0.1 0.3 0.3 0.2 0.3 ...
 $ KHARIF SORGHUM PRODUCTION (1000 tons)      : num [1:12418] 0.1 0.5 0.2 0.2 0.1 0.1 0.3 0.2 0.1 0.2 ...
 $ KHARIF SORGHUM YIELD (Kg per ha)           : num [1:12418] 1000 1000 1000 1000 1000 ...
 $ RABI SORGHUM AREA (1000 ha)                : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ RABI SORGHUM PRODUCTION (1000 tons)        : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ RABI SORGHUM YIELD (Kg per ha)             : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ SORGHUM AREA (1000 ha)                     : num [1:12418] 0.1 0.5 0.2 0.2 0.1 0.1 0.3 0.3 0.2 0.3 ...
 $ SORGHUM PRODUCTION (1000 tons)             : num [1:12418] 0.1 0.5 0.2 0.2 0.1 0.1 0.3 0.2 0.1 0.2 ...
 $ SORGHUM YIELD (Kg per ha)                  : num [1:12418] 1000 1000 1000 1000 1000 ...
 $ PEARL MILLET AREA (1000 ha)                : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ PEARL MILLET PRODUCTION (1000 tons)        : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ PEARL MILLET YIELD (Kg per ha)             : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ MAIZE AREA (1000 ha)                       : num [1:12418] 3.4 3 3 3 3 3 3.6 3.8 4 4 ...
 $ MAIZE PRODUCTION (1000 tons)               : num [1:12418] 2.9 3.6 2.8 3 3.1 3.7 4.1 3 3 3 ...
 $ MAIZE YIELD (Kg per ha)                    : num [1:12418] 853 1200 933 1000 1033 ...
 $ FINGER MILLET AREA (1000 ha)               : num [1:12418] 0.7 0.7 0.6 0.7 0.6 0.7 0.6 0.5 0.6 0.4 ...
 $ FINGER MILLET PRODUCTION (1000 tons)       : num [1:12418] 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.1 0.1 0.1 ...
 $ FINGER MILLET YIELD (Kg per ha)            : num [1:12418] 286 286 333 286 333 ...
 $ BARLEY AREA (1000 ha)                      : num [1:12418] 0.1 0.2 0.2 0.2 0.1 0.1 0.1 0.1 0 0 ...
 $ BARLEY PRODUCTION (1000 tons)              : num [1:12418] 0.1 0 0.1 0.1 0.1 0 0.1 0.1 0 0 ...
 $ BARLEY YIELD (Kg per ha)                   : num [1:12418] 1000 0 500 500 1000 0 1000 1000 0 0 ...
 $ CHICKPEA AREA (1000 ha)                    : num [1:12418] 52.1 65.3 54.2 60.9 71.7 ...
 $ CHICKPEA PRODUCTION (1000 tons)            : num [1:12418] 17 15.7 18 23.1 27.9 24.7 40 38.1 55 52.1 ...
 $ CHICKPEA YIELD (Kg per ha)                 : num [1:12418] 326 240 332 379 389 ...
 $ PIGEONPEA AREA (1000 ha)                   : num [1:12418] 31.4 29.6 29.2 28.7 24 25.1 26 28.2 27 26 ...
 $ PIGEONPEA PRODUCTION (1000 tons)           : num [1:12418] 24.8 16.9 22.9 31.2 18.8 25.9 27.1 31.8 29 26 ...
 $ PIGEONPEA YIELD (Kg per ha)                : num [1:12418] 790 571 784 1087 783 ...
 $ MINOR PULSES AREA (1000 ha)                : num [1:12418] 308 194 311 318 309 ...
 $ MINOR PULSES PRODUCTION (1000 tons)        : num [1:12418] 67.9 35.7 100.8 63.3 82.8 ...
 $ MINOR PULSES YIELD (Kg per ha)             : num [1:12418] 220 184 325 199 268 ...
 $ GROUNDNUT AREA (1000 ha)                   : num [1:12418] 0.1 0.1 0.1 0.1 0.1 0.1 0.2 0.3 1 1 ...
 $ GROUNDNUT PRODUCTION (1000 tons)           : num [1:12418] 0.1 0.2 0.2 0.1 0.1 0.1 0.2 0.3 1 1 ...
 $ GROUNDNUT YIELD (Kg per ha)                : num [1:12418] 1000 2000 2000 1000 1000 1000 1000 1000 1000 1000 ...
 $ SESAMUM AREA (1000 ha)                     : num [1:12418] 5.7 8.5 8.2 8.6 9.1 8.1 7.8 8.2 7.3 6.8 ...
 $ SESAMUM PRODUCTION (1000 tons)             : num [1:12418] 0.5 0.6 0.9 1 0.9 1 0.9 1.1 0.5 1.1 ...
 $ SESAMUM YIELD (Kg per ha)                  : num [1:12418] 87.7 70.6 109.8 116.3 98.9 ...
 $ RAPESEED AND MUSTARD AREA (1000 ha)        : num [1:12418] 1.6 1.7 1.9 2 1.8 2 2.2 2.3 2.2 2.3 ...
 $ RAPESEED AND MUSTARD PRODUCTION (1000 tons): num [1:12418] 0.5 0.3 0.7 0.9 0.7 0.9 1 0.7 0.7 1.2 ...
 $ RAPESEED AND MUSTARD YIELD (Kg per ha)     : num [1:12418] 312 176 368 450 389 ...
 $ SAFFLOWER AREA (1000 ha)                   : num [1:12418] 0.2 0.2 0.3 0.3 0.4 0.4 0.5 0.4 0.4 0.3 ...
 $ SAFFLOWER PRODUCTION (1000 tons)           : num [1:12418] 0 0 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 ...
 $ SAFFLOWER YIELD (Kg per ha)                : num [1:12418] 0 0 333 333 250 ...
 $ CASTOR AREA (1000 ha)                      : num [1:12418] 0.2 0.1 0.2 0.3 0 0.1 0.1 0.1 0 0 ...
 $ CASTOR PRODUCTION (1000 tons)              : num [1:12418] 0.1 0 0.1 0.1 0 0 0 0 0 0 ...
 $ CASTOR YIELD (Kg per ha)                   : num [1:12418] 500 0 500 333 0 ...
 $ LINSEED AREA (1000 ha)                     : num [1:12418] 111.7 101.4 96.7 95.4 98.1 ...
 $ LINSEED PRODUCTION (1000 tons)             : num [1:12418] 13.4 5.3 17.2 12.1 12.3 18.1 13.3 15.6 16.7 12.2 ...
 $ LINSEED YIELD (Kg per ha)                  : num [1:12418] 120 52.3 177.9 126.8 125.4 ...
 $ SUNFLOWER AREA (1000 ha)                   : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ SUNFLOWER PRODUCTION (1000 tons)           : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ SUNFLOWER YIELD (Kg per ha)                : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ SOYABEAN AREA (1000 ha)                    : num [1:12418] 0 0.1 0 0 1.2 2.2 2.1 1.1 0.8 0.5 ...
 $ SOYABEAN PRODUCTION (1000 tons)            : num [1:12418] 0 0 0 0 0.7 1.2 1.3 0.7 0.4 0.3 ...
 $ SOYABEAN YIELD (Kg per ha)                 : num [1:12418] 0 0 0 0 583 ...
 $ OILSEEDS AREA (1000 ha)                    : num [1:12418] 146 103 113 117 118 ...
 $ OILSEEDS PRODUCTION (1000 tons)            : num [1:12418] 17.5 5.4 19.8 15.8 15.9 22.4 18.1 19 18.6 22.4 ...
 $ OILSEEDS YIELD (Kg per ha)                 : num [1:12418] 120.2 52.5 174.6 134.9 134.9 ...
 $ SUGARCANE AREA (1000 ha)                   : num [1:12418] 0.1 0.1 0.1 0.1 0.1 0.2 0.3 0.3 0.4 0.1 ...
 $ SUGARCANE PRODUCTION (1000 tons)           : num [1:12418] 0.2 0.1 0.1 0.1 0.2 0.3 0.5 0.3 0.5 0.3 ...
 $ SUGARCANE YIELD (Kg per ha)                : num [1:12418] 2000 1000 1000 1000 2000 ...
 $ COTTON AREA (1000 ha)                      : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ COTTON PRODUCTION (1000 tons)              : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ COTTON YIELD (Kg per ha)                   : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ FRUITS AREA (1000 ha)                      : num [1:12418] 4.75 4.76 4.66 4.66 4.7 4.75 4.73 4.61 4.8 4.69 ...
 $ VEGETABLES AREA (1000 ha)                  : num [1:12418] 8.67 8.62 9.57 9.55 10 ...
 $ FRUITS AND VEGETABLES AREA (1000 ha)       : num [1:12418] 13.4 13.4 14.2 14.2 14.7 ...
 $ POTATOES AREA (1000 ha)                    : num [1:12418] 0.04 0.06 0.07 0.05 0.08 0.06 0.05 0.04 0.06 0.08 ...
 $ ONION AREA (1000 ha)                       : num [1:12418] 0.43 0.48 0.47 0.51 0.38 0.46 0.45 0.46 0.43 0.54 ...
 $ FODDER AREA (1000 ha)                      : num [1:12418] 0.34 0.28 0.21 0.27 0.21 0.22 0.17 0.29 0.31 0.15 ...
 - attr(*, "spec")=
  .. cols(
  ..   `Dist Code` = col_double(),
  ..   Year = col_double(),
  ..   `State Code` = col_double(),
  ..   `State Name` = col_character(),
  ..   `Dist Name` = col_character(),
  ..   `RICE AREA (1000 ha)` = col_double(),
  ..   `RICE PRODUCTION (1000 tons)` = col_double(),
  ..   `RICE YIELD (Kg per ha)` = col_double(),
  ..   `WHEAT AREA (1000 ha)` = col_double(),
  ..   `WHEAT PRODUCTION (1000 tons)` = col_double(),
  ..   `WHEAT YIELD (Kg per ha)` = col_double(),
  ..   `KHARIF SORGHUM AREA (1000 ha)` = col_double(),
  ..   `KHARIF SORGHUM PRODUCTION (1000 tons)` = col_double(),
  ..   `KHARIF SORGHUM YIELD (Kg per ha)` = col_double(),
  ..   `RABI SORGHUM AREA (1000 ha)` = col_double(),
  ..   `RABI SORGHUM PRODUCTION (1000 tons)` = col_double(),
  ..   `RABI SORGHUM YIELD (Kg per ha)` = col_double(),
  ..   `SORGHUM AREA (1000 ha)` = col_double(),
  ..   `SORGHUM PRODUCTION (1000 tons)` = col_double(),
  ..   `SORGHUM YIELD (Kg per ha)` = col_double(),
  ..   `PEARL MILLET AREA (1000 ha)` = col_double(),
  ..   `PEARL MILLET PRODUCTION (1000 tons)` = col_double(),
  ..   `PEARL MILLET YIELD (Kg per ha)` = col_double(),
  ..   `MAIZE AREA (1000 ha)` = col_double(),
  ..   `MAIZE PRODUCTION (1000 tons)` = col_double(),
  ..   `MAIZE YIELD (Kg per ha)` = col_double(),
  ..   `FINGER MILLET AREA (1000 ha)` = col_double(),
  ..   `FINGER MILLET PRODUCTION (1000 tons)` = col_double(),
  ..   `FINGER MILLET YIELD (Kg per ha)` = col_double(),
  ..   `BARLEY AREA (1000 ha)` = col_double(),
  ..   `BARLEY PRODUCTION (1000 tons)` = col_double(),
  ..   `BARLEY YIELD (Kg per ha)` = col_double(),
  ..   `CHICKPEA AREA (1000 ha)` = col_double(),
  ..   `CHICKPEA PRODUCTION (1000 tons)` = col_double(),
  ..   `CHICKPEA YIELD (Kg per ha)` = col_double(),
  ..   `PIGEONPEA AREA (1000 ha)` = col_double(),
  ..   `PIGEONPEA PRODUCTION (1000 tons)` = col_double(),
  ..   `PIGEONPEA YIELD (Kg per ha)` = col_double(),
  ..   `MINOR PULSES AREA (1000 ha)` = col_double(),
  ..   `MINOR PULSES PRODUCTION (1000 tons)` = col_double(),
  ..   `MINOR PULSES YIELD (Kg per ha)` = col_double(),
  ..   `GROUNDNUT AREA (1000 ha)` = col_double(),
  ..   `GROUNDNUT PRODUCTION (1000 tons)` = col_double(),
  ..   `GROUNDNUT YIELD (Kg per ha)` = col_double(),
  ..   `SESAMUM AREA (1000 ha)` = col_double(),
  ..   `SESAMUM PRODUCTION (1000 tons)` = col_double(),
  ..   `SESAMUM YIELD (Kg per ha)` = col_double(),
  ..   `RAPESEED AND MUSTARD AREA (1000 ha)` = col_double(),
  ..   `RAPESEED AND MUSTARD PRODUCTION (1000 tons)` = col_double(),
  ..   `RAPESEED AND MUSTARD YIELD (Kg per ha)` = col_double(),
  ..   `SAFFLOWER AREA (1000 ha)` = col_double(),
  ..   `SAFFLOWER PRODUCTION (1000 tons)` = col_double(),
  ..   `SAFFLOWER YIELD (Kg per ha)` = col_double(),
  ..   `CASTOR AREA (1000 ha)` = col_double(),
  ..   `CASTOR PRODUCTION (1000 tons)` = col_double(),
  ..   `CASTOR YIELD (Kg per ha)` = col_double(),
  ..   `LINSEED AREA (1000 ha)` = col_double(),
  ..   `LINSEED PRODUCTION (1000 tons)` = col_double(),
  ..   `LINSEED YIELD (Kg per ha)` = col_double(),
  ..   `SUNFLOWER AREA (1000 ha)` = col_double(),
  ..   `SUNFLOWER PRODUCTION (1000 tons)` = col_double(),
  ..   `SUNFLOWER YIELD (Kg per ha)` = col_double(),
  ..   `SOYABEAN AREA (1000 ha)` = col_double(),
  ..   `SOYABEAN PRODUCTION (1000 tons)` = col_double(),
  ..   `SOYABEAN YIELD (Kg per ha)` = col_double(),
  ..   `OILSEEDS AREA (1000 ha)` = col_double(),
  ..   `OILSEEDS PRODUCTION (1000 tons)` = col_double(),
  ..   `OILSEEDS YIELD (Kg per ha)` = col_double(),
  ..   `SUGARCANE AREA (1000 ha)` = col_double(),
  ..   `SUGARCANE PRODUCTION (1000 tons)` = col_double(),
  ..   `SUGARCANE YIELD (Kg per ha)` = col_double(),
  ..   `COTTON AREA (1000 ha)` = col_double(),
  ..   `COTTON PRODUCTION (1000 tons)` = col_double(),
  ..   `COTTON YIELD (Kg per ha)` = col_double(),
  ..   `FRUITS AREA (1000 ha)` = col_double(),
  ..   `VEGETABLES AREA (1000 ha)` = col_double(),
  ..   `FRUITS AND VEGETABLES AREA (1000 ha)` = col_double(),
  ..   `POTATOES AREA (1000 ha)` = col_double(),
  ..   `ONION AREA (1000 ha)` = col_double(),
  ..   `FODDER AREA (1000 ha)` = col_double()
  .. )
 - attr(*, "problems")=<externalptr>

VeyUche · March 28, 2022, 5:04pm

spec_tbl_df [12,418 x 80] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
 $ Dist Code                                  : num [1:12418] 1 1 1 1 1 1 1 1 1 1 ...
 $ Year                                       : num [1:12418] 1978 1979 1980 1981 1982 ...
 $ State Code                                 : num [1:12418] 14 14 14 14 14 14 14 14 14 14 ...
 $ State Name                                 : chr [1:12418] "Chhattisgarh" "Chhattisgarh" "Chhattisgarh" "Chhattisgarh" ...
 $ Dist Name                                  : chr [1:12418] "Durg" "Durg" "Durg" "Durg" ...
 $ RICE AREA (1000 ha)                        : num [1:12418] 612 617 635 630 628 ...
 $ RICE PRODUCTION (1000 tons)                : num [1:12418] 362 331 516 507 513 ...
 $ RICE YIELD (Kg per ha)                     : num [1:12418] 591 536 812 805 817 ...
 $ WHEAT AREA (1000 ha)                       : num [1:12418] 48.7 44.6 44.1 41.5 41.1 39.9 40.5 39.4 37 43 ...
 $ WHEAT PRODUCTION (1000 tons)               : num [1:12418] 25.6 17.8 33.6 23.6 23.9 20.6 19.9 21 24 23 ...
 $ WHEAT YIELD (Kg per ha)                    : num [1:12418] 526 399 762 569 582 ...
 $ KHARIF SORGHUM AREA (1000 ha)              : num [1:12418] 0.1 0.5 0.2 0.2 0.1 0.1 0.3 0.3 0.2 0.3 ...
 $ KHARIF SORGHUM PRODUCTION (1000 tons)      : num [1:12418] 0.1 0.5 0.2 0.2 0.1 0.1 0.3 0.2 0.1 0.2 ...
 $ KHARIF SORGHUM YIELD (Kg per ha)           : num [1:12418] 1000 1000 1000 1000 1000 ...
 $ RABI SORGHUM AREA (1000 ha)                : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ RABI SORGHUM PRODUCTION (1000 tons)        : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ RABI SORGHUM YIELD (Kg per ha)             : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ SORGHUM AREA (1000 ha)                     : num [1:12418] 0.1 0.5 0.2 0.2 0.1 0.1 0.3 0.3 0.2 0.3 ...
 $ SORGHUM PRODUCTION (1000 tons)             : num [1:12418] 0.1 0.5 0.2 0.2 0.1 0.1 0.3 0.2 0.1 0.2 ...
 $ SORGHUM YIELD (Kg per ha)                  : num [1:12418] 1000 1000 1000 1000 1000 ...
 $ PEARL MILLET AREA (1000 ha)                : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ PEARL MILLET PRODUCTION (1000 tons)        : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ PEARL MILLET YIELD (Kg per ha)             : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ MAIZE AREA (1000 ha)                       : num [1:12418] 3.4 3 3 3 3 3 3.6 3.8 4 4 ...
 $ MAIZE PRODUCTION (1000 tons)               : num [1:12418] 2.9 3.6 2.8 3 3.1 3.7 4.1 3 3 3 ...
 $ MAIZE YIELD (Kg per ha)                    : num [1:12418] 853 1200 933 1000 1033 ...
 $ FINGER MILLET AREA (1000 ha)               : num [1:12418] 0.7 0.7 0.6 0.7 0.6 0.7 0.6 0.5 0.6 0.4 ...
 $ FINGER MILLET PRODUCTION (1000 tons)       : num [1:12418] 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.1 0.1 0.1 ...
 $ FINGER MILLET YIELD (Kg per ha)            : num [1:12418] 286 286 333 286 333 ...
 $ BARLEY AREA (1000 ha)                      : num [1:12418] 0.1 0.2 0.2 0.2 0.1 0.1 0.1 0.1 0 0 ...
 $ BARLEY PRODUCTION (1000 tons)              : num [1:12418] 0.1 0 0.1 0.1 0.1 0 0.1 0.1 0 0 ...
 $ BARLEY YIELD (Kg per ha)                   : num [1:12418] 1000 0 500 500 1000 0 1000 1000 0 0 ...
 $ CHICKPEA AREA (1000 ha)                    : num [1:12418] 52.1 65.3 54.2 60.9 71.7 ...
 $ CHICKPEA PRODUCTION (1000 tons)            : num [1:12418] 17 15.7 18 23.1 27.9 24.7 40 38.1 55 52.1 ...
 $ CHICKPEA YIELD (Kg per ha)                 : num [1:12418] 326 240 332 379 389 ...
 $ PIGEONPEA AREA (1000 ha)                   : num [1:12418] 31.4 29.6 29.2 28.7 24 25.1 26 28.2 27 26 ...
 $ PIGEONPEA PRODUCTION (1000 tons)           : num [1:12418] 24.8 16.9 22.9 31.2 18.8 25.9 27.1 31.8 29 26 ...
 $ PIGEONPEA YIELD (Kg per ha)                : num [1:12418] 790 571 784 1087 783 ...
 $ MINOR PULSES AREA (1000 ha)                : num [1:12418] 308 194 311 318 309 ...
 $ MINOR PULSES PRODUCTION (1000 tons)        : num [1:12418] 67.9 35.7 100.8 63.3 82.8 ...
 $ MINOR PULSES YIELD (Kg per ha)             : num [1:12418] 220 184 325 199 268 ...
 $ GROUNDNUT AREA (1000 ha)                   : num [1:12418] 0.1 0.1 0.1 0.1 0.1 0.1 0.2 0.3 1 1 ...
 $ GROUNDNUT PRODUCTION (1000 tons)           : num [1:12418] 0.1 0.2 0.2 0.1 0.1 0.1 0.2 0.3 1 1 ...
 $ GROUNDNUT YIELD (Kg per ha)                : num [1:12418] 1000 2000 2000 1000 1000 1000 1000 1000 1000 1000 ...
 $ SESAMUM AREA (1000 ha)                     : num [1:12418] 5.7 8.5 8.2 8.6 9.1 8.1 7.8 8.2 7.3 6.8 ...
 $ SESAMUM PRODUCTION (1000 tons)             : num [1:12418] 0.5 0.6 0.9 1 0.9 1 0.9 1.1 0.5 1.1 ...
 $ SESAMUM YIELD (Kg per ha)                  : num [1:12418] 87.7 70.6 109.8 116.3 98.9 ...
 $ RAPESEED AND MUSTARD AREA (1000 ha)        : num [1:12418] 1.6 1.7 1.9 2 1.8 2 2.2 2.3 2.2 2.3 ...
 $ RAPESEED AND MUSTARD PRODUCTION (1000 tons): num [1:12418] 0.5 0.3 0.7 0.9 0.7 0.9 1 0.7 0.7 1.2 ...
 $ RAPESEED AND MUSTARD YIELD (Kg per ha)     : num [1:12418] 312 176 368 450 389 ...
 $ SAFFLOWER AREA (1000 ha)                   : num [1:12418] 0.2 0.2 0.3 0.3 0.4 0.4 0.5 0.4 0.4 0.3 ...
 $ SAFFLOWER PRODUCTION (1000 tons)           : num [1:12418] 0 0 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 ...
 $ SAFFLOWER YIELD (Kg per ha)                : num [1:12418] 0 0 333 333 250 ...
 $ CASTOR AREA (1000 ha)                      : num [1:12418] 0.2 0.1 0.2 0.3 0 0.1 0.1 0.1 0 0 ...
 $ CASTOR PRODUCTION (1000 tons)              : num [1:12418] 0.1 0 0.1 0.1 0 0 0 0 0 0 ...
 $ CASTOR YIELD (Kg per ha)                   : num [1:12418] 500 0 500 333 0 ...
 $ LINSEED AREA (1000 ha)                     : num [1:12418] 111.7 101.4 96.7 95.4 98.1 ...
 $ LINSEED PRODUCTION (1000 tons)             : num [1:12418] 13.4 5.3 17.2 12.1 12.3 18.1 13.3 15.6 16.7 12.2 ...
 $ LINSEED YIELD (Kg per ha)                  : num [1:12418] 120 52.3 177.9 126.8 125.4 ...
 $ SUNFLOWER AREA (1000 ha)                   : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ SUNFLOWER PRODUCTION (1000 tons)           : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ SUNFLOWER YIELD (Kg per ha)                : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ SOYABEAN AREA (1000 ha)                    : num [1:12418] 0 0.1 0 0 1.2 2.2 2.1 1.1 0.8 0.5 ...
 $ SOYABEAN PRODUCTION (1000 tons)            : num [1:12418] 0 0 0 0 0.7 1.2 1.3 0.7 0.4 0.3 ...
 $ SOYABEAN YIELD (Kg per ha)                 : num [1:12418] 0 0 0 0 583 ...
 $ OILSEEDS AREA (1000 ha)                    : num [1:12418] 146 103 113 117 118 ...
 $ OILSEEDS PRODUCTION (1000 tons)            : num [1:12418] 17.5 5.4 19.8 15.8 15.9 22.4 18.1 19 18.6 22.4 ...
 $ OILSEEDS YIELD (Kg per ha)                 : num [1:12418] 120.2 52.5 174.6 134.9 134.9 ...
 $ SUGARCANE AREA (1000 ha)                   : num [1:12418] 0.1 0.1 0.1 0.1 0.1 0.2 0.3 0.3 0.4 0.1 ...
 $ SUGARCANE PRODUCTION (1000 tons)           : num [1:12418] 0.2 0.1 0.1 0.1 0.2 0.3 0.5 0.3 0.5 0.3 ...
 $ SUGARCANE YIELD (Kg per ha)                : num [1:12418] 2000 1000 1000 1000 2000 ...
 $ COTTON AREA (1000 ha)                      : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ COTTON PRODUCTION (1000 tons)              : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ COTTON YIELD (Kg per ha)                   : num [1:12418] 0 0 0 0 0 0 0 0 0 0 ...
 $ FRUITS AREA (1000 ha)                      : num [1:12418] 4.75 4.76 4.66 4.66 4.7 4.75 4.73 4.61 4.8 4.69 ...
 $ VEGETABLES AREA (1000 ha)                  : num [1:12418] 8.67 8.62 9.57 9.55 10 ...
 $ FRUITS AND VEGETABLES AREA (1000 ha)       : num [1:12418] 13.4 13.4 14.2 14.2 14.7 ...
 $ POTATOES AREA (1000 ha)                    : num [1:12418] 0.04 0.06 0.07 0.05 0.08 0.06 0.05 0.04 0.06 0.08 ...
 $ ONION AREA (1000 ha)                       : num [1:12418] 0.43 0.48 0.47 0.51 0.38 0.46 0.45 0.46 0.43 0.54 ...
 $ FODDER AREA (1000 ha)                      : num [1:12418] 0.34 0.28 0.21 0.27 0.21 0.22 0.17 0.29 0.31 0.15 ...
 - attr(*, "spec")=
  .. cols(
  ..   `Dist Code` = col_double(),
  ..   Year = col_double(),
  ..   `State Code` = col_double(),
  ..   `State Name` = col_character(),
  ..   `Dist Name` = col_character(),
  ..   `RICE AREA (1000 ha)` = col_double(),
  ..   `RICE PRODUCTION (1000 tons)` = col_double(),
  ..   `RICE YIELD (Kg per ha)` = col_double(),
  ..   `WHEAT AREA (1000 ha)` = col_double(),
  ..   `WHEAT PRODUCTION (1000 tons)` = col_double(),
  ..   `WHEAT YIELD (Kg per ha)` = col_double(),
  ..   `KHARIF SORGHUM AREA (1000 ha)` = col_double(),
  ..   `KHARIF SORGHUM PRODUCTION (1000 tons)` = col_double(),
  ..   `KHARIF SORGHUM YIELD (Kg per ha)` = col_double(),
  ..   `RABI SORGHUM AREA (1000 ha)` = col_double(),
  ..   `RABI SORGHUM PRODUCTION (1000 tons)` = col_double(),
  ..   `RABI SORGHUM YIELD (Kg per ha)` = col_double(),
  ..   `SORGHUM AREA (1000 ha)` = col_double(),
  ..   `SORGHUM PRODUCTION (1000 tons)` = col_double(),
  ..   `SORGHUM YIELD (Kg per ha)` = col_double(),
  ..   `PEARL MILLET AREA (1000 ha)` = col_double(),
  ..   `PEARL MILLET PRODUCTION (1000 tons)` = col_double(),
  ..   `PEARL MILLET YIELD (Kg per ha)` = col_double(),
  ..   `MAIZE AREA (1000 ha)` = col_double(),
  ..   `MAIZE PRODUCTION (1000 tons)` = col_double(),
  ..   `MAIZE YIELD (Kg per ha)` = col_double(),
  ..   `FINGER MILLET AREA (1000 ha)` = col_double(),
  ..   `FINGER MILLET PRODUCTION (1000 tons)` = col_double(),
  ..   `FINGER MILLET YIELD (Kg per ha)` = col_double(),
  ..   `BARLEY AREA (1000 ha)` = col_double(),
  ..   `BARLEY PRODUCTION (1000 tons)` = col_double(),
  ..   `BARLEY YIELD (Kg per ha)` = col_double(),
  ..   `CHICKPEA AREA (1000 ha)` = col_double(),
  ..   `CHICKPEA PRODUCTION (1000 tons)` = col_double(),
  ..   `CHICKPEA YIELD (Kg per ha)` = col_double(),
  ..   `PIGEONPEA AREA (1000 ha)` = col_double(),
  ..   `PIGEONPEA PRODUCTION (1000 tons)` = col_double(),
  ..   `PIGEONPEA YIELD (Kg per ha)` = col_double(),
  ..   `MINOR PULSES AREA (1000 ha)` = col_double(),
  ..   `MINOR PULSES PRODUCTION (1000 tons)` = col_double(),
  ..   `MINOR PULSES YIELD (Kg per ha)` = col_double(),
  ..   `GROUNDNUT AREA (1000 ha)` = col_double(),
  ..   `GROUNDNUT PRODUCTION (1000 tons)` = col_double(),
  ..   `GROUNDNUT YIELD (Kg per ha)` = col_double(),
  ..   `SESAMUM AREA (1000 ha)` = col_double(),
  ..   `SESAMUM PRODUCTION (1000 tons)` = col_double(),
  ..   `SESAMUM YIELD (Kg per ha)` = col_double(),
  ..   `RAPESEED AND MUSTARD AREA (1000 ha)` = col_double(),
  ..   `RAPESEED AND MUSTARD PRODUCTION (1000 tons)` = col_double(),
  ..   `RAPESEED AND MUSTARD YIELD (Kg per ha)` = col_double(),
  ..   `SAFFLOWER AREA (1000 ha)` = col_double(),
  ..   `SAFFLOWER PRODUCTION (1000 tons)` = col_double(),
  ..   `SAFFLOWER YIELD (Kg per ha)` = col_double(),
  ..   `CASTOR AREA (1000 ha)` = col_double(),
  ..   `CASTOR PRODUCTION (1000 tons)` = col_double(),
  ..   `CASTOR YIELD (Kg per ha)` = col_double(),
  ..   `LINSEED AREA (1000 ha)` = col_double(),
  ..   `LINSEED PRODUCTION (1000 tons)` = col_double(),
  ..   `LINSEED YIELD (Kg per ha)` = col_double(),
  ..   `SUNFLOWER AREA (1000 ha)` = col_double(),
  ..   `SUNFLOWER PRODUCTION (1000 tons)` = col_double(),
  ..   `SUNFLOWER YIELD (Kg per ha)` = col_double(),
  ..   `SOYABEAN AREA (1000 ha)` = col_double(),
  ..   `SOYABEAN PRODUCTION (1000 tons)` = col_double(),
  ..   `SOYABEAN YIELD (Kg per ha)` = col_double(),
  ..   `OILSEEDS AREA (1000 ha)` = col_double(),
  ..   `OILSEEDS PRODUCTION (1000 tons)` = col_double(),
  ..   `OILSEEDS YIELD (Kg per ha)` = col_double(),
  ..   `SUGARCANE AREA (1000 ha)` = col_double(),
  ..   `SUGARCANE PRODUCTION (1000 tons)` = col_double(),
  ..   `SUGARCANE YIELD (Kg per ha)` = col_double(),
  ..   `COTTON AREA (1000 ha)` = col_double(),
  ..   `COTTON PRODUCTION (1000 tons)` = col_double(),
  ..   `COTTON YIELD (Kg per ha)` = col_double(),
  ..   `FRUITS AREA (1000 ha)` = col_double(),
  ..   `VEGETABLES AREA (1000 ha)` = col_double(),
  ..   `FRUITS AND VEGETABLES AREA (1000 ha)` = col_double(),
  ..   `POTATOES AREA (1000 ha)` = col_double(),
  ..   `ONION AREA (1000 ha)` = col_double(),
  ..   `FODDER AREA (1000 ha)` = col_double()
  .. )
 - attr(*, "problems")=<externalptr>

FJCC · March 28, 2022, 5:07pm

It seems the column is named RICE PRODUCTION (1000 tons). Also, geom_bar is not appropriate for a numeric column. What do you want on the x and y axes?

VeyUche · March 28, 2022, 5:14pm

x= RICE PRODUCTION, y=Year

And also I tried to use geom_point still but it doesn't work either, works perfectly with dataset in R but I can't with Imported dataset

startz · March 28, 2022, 5:47pm

As @FJCC pointed out, the variable name is RICE PRODUCTION (1000 tons), not RICE PRODUCTION. You also need to take care when using variable names containing spaces.

VeyUche · March 28, 2022, 6:20pm

Ok let me go try it out right now

system · April 18, 2022, 6:20pm

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.