Trade services info
Tanay Karnik
4 July 2018
getwd()## [1] "C:/Users/TANAY/Documents"tradedata <- read.csv("output14-15.csv")
summary(tradedata)## Date File.Name Log PBSY.Cottonseed..MS.Valley
## : 82 : 82 : 82 Min. :36.20
## 09-Jun-14: 2 010214.pdf: 1 Success:458 1st Qu.:45.66
## 11-Mar-14: 2 010215.pdf: 1 Median :48.20
## 01-Apr-14: 1 010314.pdf: 1 Mean :53.13
## 01-Apr-15: 1 010515.pdf: 1 3rd Qu.:51.15
## 01-Aug-14: 1 010614.pdf: 1 Max. :90.86
## (Other) :451 (Other) :453 NA's :82
## Peanut..Southeast Corn..Midwest Soybean..Decatur Soybean..Paranagua
## Min. :50.00 Min. :33.50 Min. :25.55 Mode:logical
## 1st Qu.:56.00 1st Qu.:36.50 1st Qu.:30.70 NA's:540
## Median :58.00 Median :38.50 Median :33.25
## Mean :57.66 Mean :38.48 Mean :33.70
## 3rd Qu.:59.00 3rd Qu.:40.25 3rd Qu.:36.13
## Max. :72.00 Max. :44.00 Max. :43.57
## NA's :82 NA's :82 NA's :82
## Soybean..Buenos.Aires Soybean..Brazil..bulk Soybean..Brazil
## Mode:logical :495 :127
## NA's:540 670.2 : 2 Unq : 7
## 673.28 : 2 629.63 : 3
## Unq : 2 629.41 : 2
## 651.74 : 1 634.7 : 2
## 654.33 : 1 638.45 : 2
## (Other): 37 (Other):397
## Soybean..Argentina..bulk Soybean..Argentina Coconut..Gulf
## Min. :659.2 :127 Min. :47.50
## 1st Qu.:668.9 645.73 : 3 1st Qu.:52.91
## Median :677.9 678.13 : 3 Median :55.75
## Mean :682.9 768.74 : 3 Mean :57.15
## 3rd Qu.:696.9 789.47 : 3 3rd Qu.:60.44
## Max. :729.3 821.43 : 3 Max. :70.25
## NA's :495 (Other):398 NA's :82
## Coconut..Pacific RBD.Palm..Gulf Sunflower..Dakotas
## Min. :47.00 Min. :26.88 Mode:logical
## 1st Qu.:52.41 1st Qu.:33.22 NA's:540
## Median :55.25 Median :35.63
## Mean :56.67 Mean :36.44
## 3rd Qu.:60.00 3rd Qu.:41.13
## Max. :69.75 Max. :48.25
## NA's :82 NA's :80
## Sunflower..Argentina..bulk Sunflower..Argentina SD.Canola..Toronto..C.
## Min. :760.0 :125 Mode:logical
## 1st Qu.:790.0 850 : 45 NA's:540
## Median :800.0 920 : 39
## Mean :793.6 840 : 29
## 3rd Qu.:800.0 860 : 24
## Max. :800.0 810 : 22
## NA's :495 (Other):256
## SD.Canola..Toronto..US. SD.Canola..Vancouver..C.
## Mode:logical Mode:logical
## NA's:540 NA's:540
##
##
##
##
##
## SD.Canola..Vancouver..US. RBD.Canola..Toronto..US.
## Min. :28.05 : 80
## 1st Qu.:33.08 44.27 : 3
## Median :34.78 44.36 : 3
## Mean :35.97 44.8 : 3
## 3rd Qu.:39.97 44.87 : 3
## Max. :47.49 46.01 : 3
## NA's :80 (Other):445
## RBD.Canola..Vancouver..C. RBD.Canola..Vancouver..US.
## :175 Min. :31.05
## 36.49 : 3 1st Qu.:32.47
## 38.01 : 3 Median :33.54
## 39.29 : 3 Mean :33.36
## 39.3 : 3 3rd Qu.:34.16
## 39.37 : 3 Max. :37.58
## (Other):350 NA's :445
## Crude.Coconut..US.Gulf Crude.Coconut..Pacific Coconut..US.Gulf
## --- :234 Min. :46.00 Mode:logical
## : 80 1st Qu.:51.25 NA's:540
## 54.75 : 17 Median :54.25
## 54.5 : 13 Mean :55.61
## 51.75 : 10 3rd Qu.:58.75
## 49.75 : 9 Max. :68.75
## (Other):177 NA's :80
## Coconut..Pacific.1 RBD.Palm..US.Gulf RBD.Palm.Olein..US.Gulf
## Mode:logical Min. :25.88 Min. :26.50
## NA's:540 1st Qu.:32.35 1st Qu.:32.47
## Median :34.63 Median :34.75
## Mean :35.44 Mean :35.72
## 3rd Qu.:40.13 3rd Qu.:40.25
## Max. :47.25 Max. :47.88
## NA's :80 NA's :80
## RBD.Palm.Stearin..US.Gulf RBD.Palm.Kernel..US.Gulf
## Min. :22.38 --- :234
## 1st Qu.:30.19 : 80
## Median :34.50 51.25 : 8
## Mean :34.13 51.38 : 7
## 3rd Qu.:39.25 43.88 : 6
## Max. :45.00 45.75 : 6
## NA's :80 (Other):199
## RBWD.NuSun..fob.Dakotas RBWD.Linoleic.Sun..fob.Dakotas
## Min. :53.00 Min. :70.00
## 1st Qu.:61.00 1st Qu.:73.00
## Median :62.00 Median :73.00
## Mean :63.04 Mean :72.63
## 3rd Qu.:64.00 3rd Qu.:73.00
## Max. :74.00 Max. :74.00
## NA's :80 NA's :80
## Cottonseed..Salad..NY Cottonseed..Salad Cottonseed..Cooking..NY
## Min. : 51.00 Mode:logical Min. :49.00
## 1st Qu.: 58.09 NA's:540 1st Qu.:56.09
## Median : 60.00 Median :58.00
## Mean : 67.70 Mean :65.68
## 3rd Qu.: 66.00 3rd Qu.:64.00
## Max. :101.41 Max. :99.71
## NA's :80 NA's :80
## Cottonseed..Cooking Peanut..NY Peanut Corn..NY
## Mode:logical Min. :49.75 Mode:logical Min. :45.75
## NA's:540 1st Qu.:74.00 NA's:540 1st Qu.:48.50
## Median :77.00 Median :51.00
## Mean :76.47 Mean :51.04
## 3rd Qu.:78.00 3rd Qu.:53.50
## Max. :94.00 Max. :80.00
## NA's :80 NA's :80
## Corn Soybean..NY Soybean Coconut..Wagons...NY
## Mode:logical Min. :32.79 Mode:logical Min. :44.50
## NA's:540 1st Qu.:38.18 NA's:540 1st Qu.:68.85
## Median :41.13 Median :71.75
## Mean :41.81 Mean :72.70
## 3rd Qu.:45.29 3rd Qu.:75.44
## Max. :57.77 Max. :85.88
## NA's :80 NA's :80
## Coconut..Wagons. RBD.Palm..Wagons...NY RBD.Palm..NY RBD.Palm
## Mode:logical Min. :37.13 Mode:logical Mode:logical
## NA's:540 1st Qu.:42.50 NA's:540 NA's:540
## Median :45.00
## Mean :46.93
## 3rd Qu.:52.56
## Max. :59.63
## NA's :80
## Canola..NY Canola..LA Canola
## Min. :33.79 Min. :35.24 Mode:logical
## 1st Qu.:39.05 1st Qu.:39.52 NA's:540
## Median :42.70 Median :42.35
## Mean :42.70 Mean :42.64
## 3rd Qu.:45.76 3rd Qu.:44.84
## Max. :53.71 Max. :53.71
## NA's :80 NA's :80library(lattice)
library(ggplot2)
summary(tradedata$PBSY.Cottonseed..MS.Valley)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 36.20 45.66 48.20 53.13 51.15 90.86 82histogram(tradedata$PBSY.Cottonseed..MS.Valley, Main="Range of Sale Price", xlab="Price", ylab="No. of days")
summary(tradedata$Peanut..Southeast)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 50.00 56.00 58.00 57.66 59.00 72.00 82histogram(tradedata$Peanut..Southeast, Main="Range of Sale Price", xlab="Price", ylab="No. of days")
summary(tradedata$Corn..Midwest)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 33.50 36.50 38.50 38.48 40.25 44.00 82histogram(tradedata$Corn..Midwest, Main="Range of Sale Price", xlab="Price", ylab="No. of days")
summary(tradedata$Soybean..Decatur)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 25.55 30.70 33.25 33.70 36.13 43.57 82histogram(tradedata$Soybean..Decatur, Main="Soybean..Decatur", xlab="Price", ylab="No. of days")
summary(tradedata$Coconut..Gulf)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 47.50 52.91 55.75 57.15 60.44 70.25 82histogram(tradedata$Coconut..Gulf, Main="Coconut..Gulf", xlab="Price", ylab="No. of days")
summary(tradedata$Coconut..Pacific)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 47.00 52.41 55.25 56.67 60.00 69.75 82histogram(tradedata$Coconut..Pacific, Main="Coconut..Pacific", xlab="Price", ylab="No. of days")
summary(tradedata$RBD.Palm..Gulf)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 26.88 33.22 35.63 36.44 41.13 48.25 80histogram(tradedata$RBD.Palm..Gulf, Main="RBD.Palm..Gulf", xlab="Price", ylab="No. of days")
summary(tradedata$SD.Canola..Vancouver..US.)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 28.05 33.08 34.78 35.97 39.97 47.49 80histogram(tradedata$SD.Canola..Vancouver..US., Main="SD.Canola..Vancouver..US.", xlab="Price", ylab="No. of days")
summary(tradedata$Crude.Coconut..Pacific)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 46.00 51.25 54.25 55.61 58.75 68.75 80histogram(tradedata$Crude.Coconut..Pacific, Main="Crude.Coconut..Pacific", xlab="Price", ylab="No. of days")
R Markdown
This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.
When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:
summary(cars)## speed dist
## Min. : 4.0 Min. : 2.00
## 1st Qu.:12.0 1st Qu.: 26.00
## Median :15.0 Median : 36.00
## Mean :15.4 Mean : 42.98
## 3rd Qu.:19.0 3rd Qu.: 56.00
## Max. :25.0 Max. :120.00Including Plots
You can also embed plots, for example:
Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.