Code
<- c("tidyverse", "readxl", "knitr") # create vector of packages
my_packages invisible(lapply(my_packages, require, character.only = TRUE)) # load multiple packages
::opts_chunk$set(echo = TRUE, warning=FALSE, message=FALSE) knitr
Tim Shores
March 5, 2023
Challenge 3 includes four tasks:
pivot_longer
I chose to read in the organic egg file, organiceggpoultry.xls. The thought of chickens always brings a smile to my face.
One tricky property of the egg data set is that the Excel file includes data in three tabs, so I can’t just read it in with read_xls()
. I use excel_sheets()
to return a list of data frames with data populated by each sheet in the Excel file. From the purrr
library, the map()
assigns each sheet from the list as a vector element. Also from purrr
, set_names()
gives the vector element the same name as the Excel sheet.
Messy, but a good stepping stone. Here are the three vector elements printed:
$Data
# A tibble: 124 × 11
(Certified Orga…¹ ...2 ...3 ...4 ...5 ...6 ...7 ...8 ...9 ...10 ...11
<chr> <chr> <chr> <chr> <chr> <lgl> <chr> <chr> <chr> <chr> <chr>
1 <NA> <NA> <NA> <NA> <NA> NA <NA> <NA> <NA> <NA> <NA>
2 USDA Certified O… <NA> <NA> <NA> <NA> NA USDA… <NA> <NA> <NA> <NA>
3 Price per Carton… <NA> <NA> <NA> <NA> NA Pric… <NA> <NA> <NA> <NA>
4 <NA> "Ext… "Ext… "Lar… "Lar… NA Whole B/S … Bone… Whol… Thig…
5 Jan 2004 "230" "132" "230" "126" NA 197.5 645.5 too … 193.5 too …
6 February "230" "134… "226… "128… NA 197.5 642.5 too … 193.5 203
7 March "230" "137" "225" "131" NA 209 642.5 too … 193.5 203
8 April "234… "137" "225" "131" NA 212 642.5 too … 193.5 203
9 May "236" "137" "225" "131" NA 214.5 642.5 too … 193.5 203
10 June "241" "137" "231… "133… NA 216.… 641 too … 201.… 200.…
# … with 114 more rows, and abbreviated variable name
# ¹`(Certified Organic denotes products grown and processed according to USDA's national organic standards and certified by USDA-accredited State and private certification organizations.)`
$`Organic egg prices, 2004-13`
# A tibble: 75 × 13
Prices pa…¹ ...2 ...3 ...4 ...5 ...6 ...7 ...8 ...9 ...10 ...11 ...12
<chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 "Year" Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov.
2 "2013" <NA> <NA> <NA> <NA> <NA> Cent… <NA> <NA> <NA> <NA> <NA>
3 "Certified… <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
4 "Extra Lar… 290 290 290 290 290 290 290 290 290 290 290
5 "Extra Lar… 188.… 188.… 188.… 188.… 188.… 188.… 188.… 188.… 188.… 188.… 188.…
6 "Large \nD… 267.5 267.5 267.5 267.5 267.5 267.5 267.5 267.5 267.5 267.5 267.5
7 "Large \n1… 178 178 178 178 178 178 178 178 178 178 178
8 <NA> Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov.
9 "2012" <NA> <NA> <NA> <NA> <NA> Cent… <NA> <NA> <NA> <NA> <NA>
10 "Certified… <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
# … with 65 more rows, 1 more variable: ...13 <chr>, and abbreviated variable
# name
# ¹`Prices paid by first receiver for USDA certified organic eggs, monthly, 2004-13 1/`
$`Organic poultry prices, 2004-13`
# A tibble: 100 × 13
Prices pa…¹ ...2 ...3 ...4 ...5 ...6 ...7 ...8 ...9 ...10 ...11 ...12
<chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Year Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov.
2 2013 <NA> <NA> <NA> <NA> <NA> Cent… <NA> <NA> <NA> <NA> <NA>
3 Organic yo… <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
4 Whole 238.5 238.5 238.5 238.5 238.5 238.5 238.5 238.5 238.5 238.5 238.5
5 B/S Breast 703.… 703.… 703.… 703.… 703.… 703.… 703.… 703.… 703.… 703.… 703.…
6 Bone-in Br… 390.5 390.5 390.5 390.5 390.5 390.5 390.5 390.5 390.5 390.5 390.5
7 Whole Legs 203.5 203.5 203.5 203.5 203.5 203.5 203.5 203.5 203.5 203.5 203.5
8 Thighs 216.… 216.… 216.… 216.… 216.… 216.… 216.… 216.… 216.… 216.… 216.…
9 <NA> Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov.
10 2012 <NA> <NA> <NA> <NA> <NA> Cent… <NA> <NA> <NA> <NA> <NA>
# … with 90 more rows, 1 more variable: ...13 <chr>, and abbreviated variable
# name
# ¹`Prices paid by first receiver for USDA certified organic poultry, monthly, 2004-13 1/`
The next step is to use map()
again to assign each data frame in the list to its own variable. This will let me tidy each data frame separately. This is useful because each Excel sheet is organized in a different way, and therefore I must use different commands to tidy each sheet. For clarity of reference, I chose data frame variable names similar to the source file sheet names.
We now have three data frames from one Excel workbook. Here is each data frame printed:
df_eggPoultryData <- map(names(listEggDFs), ~assign(.x, listEggDFs[[.x]], envir = .GlobalEnv))[[1]] # assign the first df in the list to a separate df
df_eggPrices <- map(names(listEggDFs), ~assign(.x, listEggDFs[[.x]], envir = .GlobalEnv))[[2]] # assign the second df in the list to a separate df
df_poultryPrices <- map(names(listEggDFs), ~assign(.x, listEggDFs[[.x]], envir = .GlobalEnv))[[3]] # assign the third df in the list to a separate df
df_eggPoultryData
# A tibble: 124 × 11
(Certified Orga…¹ ...2 ...3 ...4 ...5 ...6 ...7 ...8 ...9 ...10 ...11
<chr> <chr> <chr> <chr> <chr> <lgl> <chr> <chr> <chr> <chr> <chr>
1 <NA> <NA> <NA> <NA> <NA> NA <NA> <NA> <NA> <NA> <NA>
2 USDA Certified O… <NA> <NA> <NA> <NA> NA USDA… <NA> <NA> <NA> <NA>
3 Price per Carton… <NA> <NA> <NA> <NA> NA Pric… <NA> <NA> <NA> <NA>
4 <NA> "Ext… "Ext… "Lar… "Lar… NA Whole B/S … Bone… Whol… Thig…
5 Jan 2004 "230" "132" "230" "126" NA 197.5 645.5 too … 193.5 too …
6 February "230" "134… "226… "128… NA 197.5 642.5 too … 193.5 203
7 March "230" "137" "225" "131" NA 209 642.5 too … 193.5 203
8 April "234… "137" "225" "131" NA 212 642.5 too … 193.5 203
9 May "236" "137" "225" "131" NA 214.5 642.5 too … 193.5 203
10 June "241" "137" "231… "133… NA 216.… 641 too … 201.… 200.…
# … with 114 more rows, and abbreviated variable name
# ¹`(Certified Organic denotes products grown and processed according to USDA's national organic standards and certified by USDA-accredited State and private certification organizations.)`
# A tibble: 75 × 13
Prices pa…¹ ...2 ...3 ...4 ...5 ...6 ...7 ...8 ...9 ...10 ...11 ...12
<chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 "Year" Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov.
2 "2013" <NA> <NA> <NA> <NA> <NA> Cent… <NA> <NA> <NA> <NA> <NA>
3 "Certified… <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
4 "Extra Lar… 290 290 290 290 290 290 290 290 290 290 290
5 "Extra Lar… 188.… 188.… 188.… 188.… 188.… 188.… 188.… 188.… 188.… 188.… 188.…
6 "Large \nD… 267.5 267.5 267.5 267.5 267.5 267.5 267.5 267.5 267.5 267.5 267.5
7 "Large \n1… 178 178 178 178 178 178 178 178 178 178 178
8 <NA> Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov.
9 "2012" <NA> <NA> <NA> <NA> <NA> Cent… <NA> <NA> <NA> <NA> <NA>
10 "Certified… <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
# … with 65 more rows, 1 more variable: ...13 <chr>, and abbreviated variable
# name
# ¹`Prices paid by first receiver for USDA certified organic eggs, monthly, 2004-13 1/`
# A tibble: 100 × 13
Prices pa…¹ ...2 ...3 ...4 ...5 ...6 ...7 ...8 ...9 ...10 ...11 ...12
<chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
1 Year Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov.
2 2013 <NA> <NA> <NA> <NA> <NA> Cent… <NA> <NA> <NA> <NA> <NA>
3 Organic yo… <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA> <NA>
4 Whole 238.5 238.5 238.5 238.5 238.5 238.5 238.5 238.5 238.5 238.5 238.5
5 B/S Breast 703.… 703.… 703.… 703.… 703.… 703.… 703.… 703.… 703.… 703.… 703.…
6 Bone-in Br… 390.5 390.5 390.5 390.5 390.5 390.5 390.5 390.5 390.5 390.5 390.5
7 Whole Legs 203.5 203.5 203.5 203.5 203.5 203.5 203.5 203.5 203.5 203.5 203.5
8 Thighs 216.… 216.… 216.… 216.… 216.… 216.… 216.… 216.… 216.… 216.… 216.…
9 <NA> Jan. Feb. Mar. Apr. May June July Aug. Sep. Oct. Nov.
10 2012 <NA> <NA> <NA> <NA> <NA> Cent… <NA> <NA> <NA> <NA> <NA>
# … with 90 more rows, 1 more variable: ...13 <chr>, and abbreviated variable
# name
# ¹`Prices paid by first receiver for USDA certified organic poultry, monthly, 2004-13 1/`
The data describes the price of several types of USDA certified organic egg and chicken products from the years 2004 to 2013. The price was paid by ‘first receivers’, described in a footnote as “those entities that purchases the processed product from the poultry or egg company, such as a retailer, distributor, or manufacturer.” The cited data sources are the U.S. Department of Agriculture, Agricultural Marketing Service (AMS) Market News, Organic Poultry and Eggs (Weekly reports).
Although the three Excel worksheets appear at first glance to have different data, the second and third worksheets are just tables that repeat and reorganize the data from the first worksheet. In my analysis below, I only use the data frame df_eggPoultryData mapped from the first Excel worksheet.
The data format has several problems. It’s formatted for visual inspection rather than computational analysis. There are extra headings and columns. The date labels are inconsistent. The data is messy in that it uses 9 columns to describe what should be a single variable: the type of egg or chicken item that has price data. As a result, we can consider each row to include 9 observations. I will tidy this up below.
The data includes 11 variables (date, 4 egg carton items and 5 chicken items, and an empty column) with prices for 9 items for each month of 10 years in 120 rows.
The end result of tidying and pivoting will be a data frame with variables for month, year, item, price, product (egg or chicken), and unit (price per carton or price cents per pound).
By pivoting 9 variables into an item and price column representing 120 months of data, the final table should have \(9 * 120 = 1,080\) rows. Along with month, year, product, and unit variables, the final table should have 6 columns.
Now we will pivot the data, and compare our pivoted data dimensions to the dimensions calculated above as a “sanity” check.
The following code block takes the following actions to tidy up the eggData data frame:
select
to remove a blank column between the egg and chicken data sets.separate_wider_delim
, mutate
, and fill
to tidy the month column and separate year into its own column. The source data labels the year only on January, implying the year for the other months. It’s important to make both month and year explicit for each observation so we don’t end up with analysis that makes it difficult to identify the year.pivot_longer
to pivot the egg and chicken product column headings into row values under a new item
column, with their values listed in a price
column.mutate
to tidy up item values and make labels consistent.mutate
and str_detect
to assign the egg and chicken product and unit variables that I recorded earlier according to each egg and chicken item. I used the literal values from the header without modification. They could be made more clear but not without the risk of distorting their original meaning.The full table is below, and it matches my expectation of \(9 * 120 = 1,080\) rows.
A new observation added to this data would require the following details:
How does it meet requirements for tidy data?
Here is the full data set tidied, pivoted, and printed:
productname <- c(df_eggPoultryData[2,1],df_eggPoultryData[2,7])
unitname <- c(df_eggPoultryData[3,1],df_eggPoultryData[3,7])
colnames(df_eggPoultryData) <- df_eggPoultryData[4, ]
colnames(df_eggPoultryData)[1] <- "month"
df_eggPoultryData <- df_eggPoultryData %>%
slice(-(1:4)) %>%
select(!`NA`) %>%
separate_wider_delim(month, delim = " ", names = c("month", "year"), too_few = "align_start", too_many = "merge") %>%
mutate(month = replace(month, month == 'Jan', 'January')) %>%
mutate(year = replace(year, year == '/1', NA)) %>%
fill(year) %>%
pivot_longer(cols = -c(month,year), names_to = "item", values_to = "price") %>%
mutate(item = str_remove_all(item, '\\n')) %>%
mutate(item = str_remove_all(item, '1/2 Dozen')) %>%
mutate(item = str_replace_all(item, 'Doz\\.','Dozen')) %>%
mutate(product = case_when(
str_detect(item, regex("^[EL]")) ~ productname[[1]],
str_detect(item, regex("^[BTW]")) ~ productname[[2]]
)) %>%
mutate(unit = case_when(
str_detect(item, regex("^[EL]")) ~ unitname[[1]],
str_detect(item, regex("^[BTW]")) ~ unitname[[2]]
)) %>%
print(n=1080)
# A tibble: 1,080 × 6
month year item price product unit
<chr> <chr> <chr> <chr> <chr> <chr>
1 January 2004 Extra Large Dozen 230 USDA Certif… Pric…
2 January 2004 Extra Large 1/2 Dozen 132 USDA Certif… Pric…
3 January 2004 Large Dozen 230 USDA Certif… Pric…
4 January 2004 Large 1/2 Dozen 126 USDA Certif… Pric…
5 January 2004 Whole 197.5 USDA Certif… Pric…
6 January 2004 B/S Breast 645.5 USDA Certif… Pric…
7 January 2004 Bone-in Breast too few USDA Certif… Pric…
8 January 2004 Whole Legs 193.5 USDA Certif… Pric…
9 January 2004 Thighs too few USDA Certif… Pric…
10 February 2004 Extra Large Dozen 230 USDA Certif… Pric…
11 February 2004 Extra Large 1/2 Dozen 134.5 USDA Certif… Pric…
12 February 2004 Large Dozen 226.25 USDA Certif… Pric…
13 February 2004 Large 1/2 Dozen 128.5 USDA Certif… Pric…
14 February 2004 Whole 197.5 USDA Certif… Pric…
15 February 2004 B/S Breast 642.5 USDA Certif… Pric…
16 February 2004 Bone-in Breast too few USDA Certif… Pric…
17 February 2004 Whole Legs 193.5 USDA Certif… Pric…
18 February 2004 Thighs 203 USDA Certif… Pric…
19 March 2004 Extra Large Dozen 230 USDA Certif… Pric…
20 March 2004 Extra Large 1/2 Dozen 137 USDA Certif… Pric…
21 March 2004 Large Dozen 225 USDA Certif… Pric…
22 March 2004 Large 1/2 Dozen 131 USDA Certif… Pric…
23 March 2004 Whole 209 USDA Certif… Pric…
24 March 2004 B/S Breast 642.5 USDA Certif… Pric…
25 March 2004 Bone-in Breast too few USDA Certif… Pric…
26 March 2004 Whole Legs 193.5 USDA Certif… Pric…
27 March 2004 Thighs 203 USDA Certif… Pric…
28 April 2004 Extra Large Dozen 234.5 USDA Certif… Pric…
29 April 2004 Extra Large 1/2 Dozen 137 USDA Certif… Pric…
30 April 2004 Large Dozen 225 USDA Certif… Pric…
31 April 2004 Large 1/2 Dozen 131 USDA Certif… Pric…
32 April 2004 Whole 212 USDA Certif… Pric…
33 April 2004 B/S Breast 642.5 USDA Certif… Pric…
34 April 2004 Bone-in Breast too few USDA Certif… Pric…
35 April 2004 Whole Legs 193.5 USDA Certif… Pric…
36 April 2004 Thighs 203 USDA Certif… Pric…
37 May 2004 Extra Large Dozen 236 USDA Certif… Pric…
38 May 2004 Extra Large 1/2 Dozen 137 USDA Certif… Pric…
39 May 2004 Large Dozen 225 USDA Certif… Pric…
40 May 2004 Large 1/2 Dozen 131 USDA Certif… Pric…
41 May 2004 Whole 214.5 USDA Certif… Pric…
42 May 2004 B/S Breast 642.5 USDA Certif… Pric…
43 May 2004 Bone-in Breast too few USDA Certif… Pric…
44 May 2004 Whole Legs 193.5 USDA Certif… Pric…
45 May 2004 Thighs 203 USDA Certif… Pric…
46 June 2004 Extra Large Dozen 241 USDA Certif… Pric…
47 June 2004 Extra Large 1/2 Dozen 137 USDA Certif… Pric…
48 June 2004 Large Dozen 231.375 USDA Certif… Pric…
49 June 2004 Large 1/2 Dozen 133.5 USDA Certif… Pric…
50 June 2004 Whole 216.375 USDA Certif… Pric…
51 June 2004 B/S Breast 641 USDA Certif… Pric…
52 June 2004 Bone-in Breast too few USDA Certif… Pric…
53 June 2004 Whole Legs 201.875 USDA Certif… Pric…
54 June 2004 Thighs 200.375 USDA Certif… Pric…
55 July 2004 Extra Large Dozen 241 USDA Certif… Pric…
56 July 2004 Extra Large 1/2 Dozen 137 USDA Certif… Pric…
57 July 2004 Large Dozen 233.5 USDA Certif… Pric…
58 July 2004 Large 1/2 Dozen 133.5 USDA Certif… Pric…
59 July 2004 Whole 217 USDA Certif… Pric…
60 July 2004 B/S Breast 642.5 USDA Certif… Pric…
61 July 2004 Bone-in Breast 390.5 USDA Certif… Pric…
62 July 2004 Whole Legs 203.5 USDA Certif… Pric…
63 July 2004 Thighs 199.5 USDA Certif… Pric…
64 August 2004 Extra Large Dozen 241 USDA Certif… Pric…
65 August 2004 Extra Large 1/2 Dozen 137 USDA Certif… Pric…
66 August 2004 Large Dozen 233.5 USDA Certif… Pric…
67 August 2004 Large 1/2 Dozen 133.5 USDA Certif… Pric…
68 August 2004 Whole 217 USDA Certif… Pric…
69 August 2004 B/S Breast 642.5 USDA Certif… Pric…
70 August 2004 Bone-in Breast 390.5 USDA Certif… Pric…
71 August 2004 Whole Legs 203.5 USDA Certif… Pric…
72 August 2004 Thighs 199.5 USDA Certif… Pric…
73 September 2004 Extra Large Dozen 241 USDA Certif… Pric…
74 September 2004 Extra Large 1/2 Dozen 135.875 USDA Certif… Pric…
75 September 2004 Large Dozen 233.5 USDA Certif… Pric…
76 September 2004 Large 1/2 Dozen 129.75 USDA Certif… Pric…
77 September 2004 Whole 217 USDA Certif… Pric…
78 September 2004 B/S Breast 642.5 USDA Certif… Pric…
79 September 2004 Bone-in Breast 390.5 USDA Certif… Pric…
80 September 2004 Whole Legs 203.5 USDA Certif… Pric…
81 September 2004 Thighs 199.5 USDA Certif… Pric…
82 October 2004 Extra Large Dozen 241 USDA Certif… Pric…
83 October 2004 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
84 October 2004 Large Dozen 233.5 USDA Certif… Pric…
85 October 2004 Large 1/2 Dozen 128.5 USDA Certif… Pric…
86 October 2004 Whole 217 USDA Certif… Pric…
87 October 2004 B/S Breast 642.5 USDA Certif… Pric…
88 October 2004 Bone-in Breast 390.5 USDA Certif… Pric…
89 October 2004 Whole Legs 203.5 USDA Certif… Pric…
90 October 2004 Thighs 199.5 USDA Certif… Pric…
91 November 2004 Extra Large Dozen 241 USDA Certif… Pric…
92 November 2004 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
93 November 2004 Large Dozen 233.5 USDA Certif… Pric…
94 November 2004 Large 1/2 Dozen 128.5 USDA Certif… Pric…
95 November 2004 Whole 217 USDA Certif… Pric…
96 November 2004 B/S Breast 642.5 USDA Certif… Pric…
97 November 2004 Bone-in Breast 390.5 USDA Certif… Pric…
98 November 2004 Whole Legs 203.5 USDA Certif… Pric…
99 November 2004 Thighs 199.5 USDA Certif… Pric…
100 December 2004 Extra Large Dozen 241 USDA Certif… Pric…
101 December 2004 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
102 December 2004 Large Dozen 233.5 USDA Certif… Pric…
103 December 2004 Large 1/2 Dozen 128.5 USDA Certif… Pric…
104 December 2004 Whole 217 USDA Certif… Pric…
105 December 2004 B/S Breast 642.5 USDA Certif… Pric…
106 December 2004 Bone-in Breast 390.5 USDA Certif… Pric…
107 December 2004 Whole Legs 203.5 USDA Certif… Pric…
108 December 2004 Thighs 199.5 USDA Certif… Pric…
109 January 2005 Extra Large Dozen 241 USDA Certif… Pric…
110 January 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
111 January 2005 Large Dozen 233.5 USDA Certif… Pric…
112 January 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
113 January 2005 Whole 217 USDA Certif… Pric…
114 January 2005 B/S Breast 644 USDA Certif… Pric…
115 January 2005 Bone-in Breast 390.5 USDA Certif… Pric…
116 January 2005 Whole Legs 203.5 USDA Certif… Pric…
117 January 2005 Thighs 213 USDA Certif… Pric…
118 February 2005 Extra Large Dozen 241 USDA Certif… Pric…
119 February 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
120 February 2005 Large Dozen 233.5 USDA Certif… Pric…
121 February 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
122 February 2005 Whole 217 USDA Certif… Pric…
123 February 2005 B/S Breast 645.5 USDA Certif… Pric…
124 February 2005 Bone-in Breast 390.5 USDA Certif… Pric…
125 February 2005 Whole Legs 203.5 USDA Certif… Pric…
126 February 2005 Thighs 222 USDA Certif… Pric…
127 March 2005 Extra Large Dozen 241 USDA Certif… Pric…
128 March 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
129 March 2005 Large Dozen 233.5 USDA Certif… Pric…
130 March 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
131 March 2005 Whole 217 USDA Certif… Pric…
132 March 2005 B/S Breast 645.5 USDA Certif… Pric…
133 March 2005 Bone-in Breast 390.5 USDA Certif… Pric…
134 March 2005 Whole Legs 203.5 USDA Certif… Pric…
135 March 2005 Thighs 222 USDA Certif… Pric…
136 April 2005 Extra Large Dozen 241 USDA Certif… Pric…
137 April 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
138 April 2005 Large Dozen 233.5 USDA Certif… Pric…
139 April 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
140 April 2005 Whole 217 USDA Certif… Pric…
141 April 2005 B/S Breast 645.5 USDA Certif… Pric…
142 April 2005 Bone-in Breast 390.5 USDA Certif… Pric…
143 April 2005 Whole Legs 203.5 USDA Certif… Pric…
144 April 2005 Thighs 222 USDA Certif… Pric…
145 May 2005 Extra Large Dozen 241 USDA Certif… Pric…
146 May 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
147 May 2005 Large Dozen 233.5 USDA Certif… Pric…
148 May 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
149 May 2005 Whole 217 USDA Certif… Pric…
150 May 2005 B/S Breast 645.5 USDA Certif… Pric…
151 May 2005 Bone-in Breast 390.5 USDA Certif… Pric…
152 May 2005 Whole Legs 203.5 USDA Certif… Pric…
153 May 2005 Thighs 222 USDA Certif… Pric…
154 June 2005 Extra Large Dozen 241 USDA Certif… Pric…
155 June 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
156 June 2005 Large Dozen 233.5 USDA Certif… Pric…
157 June 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
158 June 2005 Whole 217 USDA Certif… Pric…
159 June 2005 B/S Breast 645.5 USDA Certif… Pric…
160 June 2005 Bone-in Breast 390.5 USDA Certif… Pric…
161 June 2005 Whole Legs 203.5 USDA Certif… Pric…
162 June 2005 Thighs 222 USDA Certif… Pric…
163 July 2005 Extra Large Dozen 241 USDA Certif… Pric…
164 July 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
165 July 2005 Large Dozen 233.5 USDA Certif… Pric…
166 July 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
167 July 2005 Whole 217 USDA Certif… Pric…
168 July 2005 B/S Breast 645.5 USDA Certif… Pric…
169 July 2005 Bone-in Breast 390.5 USDA Certif… Pric…
170 July 2005 Whole Legs 203.5 USDA Certif… Pric…
171 July 2005 Thighs 222 USDA Certif… Pric…
172 August 2005 Extra Large Dozen 241 USDA Certif… Pric…
173 August 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
174 August 2005 Large Dozen 233.5 USDA Certif… Pric…
175 August 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
176 August 2005 Whole 217 USDA Certif… Pric…
177 August 2005 B/S Breast 645.5 USDA Certif… Pric…
178 August 2005 Bone-in Breast 390.5 USDA Certif… Pric…
179 August 2005 Whole Legs 203.5 USDA Certif… Pric…
180 August 2005 Thighs 222 USDA Certif… Pric…
181 September 2005 Extra Large Dozen 241 USDA Certif… Pric…
182 September 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
183 September 2005 Large Dozen 233.5 USDA Certif… Pric…
184 September 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
185 September 2005 Whole 217 USDA Certif… Pric…
186 September 2005 B/S Breast 645.5 USDA Certif… Pric…
187 September 2005 Bone-in Breast 390.5 USDA Certif… Pric…
188 September 2005 Whole Legs 203.5 USDA Certif… Pric…
189 September 2005 Thighs 222 USDA Certif… Pric…
190 October 2005 Extra Large Dozen 241 USDA Certif… Pric…
191 October 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
192 October 2005 Large Dozen 233.5 USDA Certif… Pric…
193 October 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
194 October 2005 Whole 217 USDA Certif… Pric…
195 October 2005 B/S Breast 645.5 USDA Certif… Pric…
196 October 2005 Bone-in Breast 390.5 USDA Certif… Pric…
197 October 2005 Whole Legs 203.5 USDA Certif… Pric…
198 October 2005 Thighs 222 USDA Certif… Pric…
199 November 2005 Extra Large Dozen 241 USDA Certif… Pric…
200 November 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
201 November 2005 Large Dozen 233.5 USDA Certif… Pric…
202 November 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
203 November 2005 Whole 217 USDA Certif… Pric…
204 November 2005 B/S Breast 645.5 USDA Certif… Pric…
205 November 2005 Bone-in Breast 390.5 USDA Certif… Pric…
206 November 2005 Whole Legs 203.5 USDA Certif… Pric…
207 November 2005 Thighs 222 USDA Certif… Pric…
208 December 2005 Extra Large Dozen 241 USDA Certif… Pric…
209 December 2005 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
210 December 2005 Large Dozen 233.5 USDA Certif… Pric…
211 December 2005 Large 1/2 Dozen 128.5 USDA Certif… Pric…
212 December 2005 Whole 217 USDA Certif… Pric…
213 December 2005 B/S Breast 645.5 USDA Certif… Pric…
214 December 2005 Bone-in Breast 390.5 USDA Certif… Pric…
215 December 2005 Whole Legs 203.5 USDA Certif… Pric…
216 December 2005 Thighs 222 USDA Certif… Pric…
217 January 2006 Extra Large Dozen 241 USDA Certif… Pric…
218 January 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
219 January 2006 Large Dozen 233.5 USDA Certif… Pric…
220 January 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
221 January 2006 Whole 217 USDA Certif… Pric…
222 January 2006 B/S Breast 645.5 USDA Certif… Pric…
223 January 2006 Bone-in Breast 390.5 USDA Certif… Pric…
224 January 2006 Whole Legs 203.5 USDA Certif… Pric…
225 January 2006 Thighs 222 USDA Certif… Pric…
226 February 2006 Extra Large Dozen 241 USDA Certif… Pric…
227 February 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
228 February 2006 Large Dozen 233.5 USDA Certif… Pric…
229 February 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
230 February 2006 Whole 217 USDA Certif… Pric…
231 February 2006 B/S Breast 645.5 USDA Certif… Pric…
232 February 2006 Bone-in Breast 390.5 USDA Certif… Pric…
233 February 2006 Whole Legs 203.5 USDA Certif… Pric…
234 February 2006 Thighs 222 USDA Certif… Pric…
235 March 2006 Extra Large Dozen 241.375 USDA Certif… Pric…
236 March 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
237 March 2006 Large Dozen 233.5 USDA Certif… Pric…
238 March 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
239 March 2006 Whole 219.625 USDA Certif… Pric…
240 March 2006 B/S Breast 645.5 USDA Certif… Pric…
241 March 2006 Bone-in Breast 390.5 USDA Certif… Pric…
242 March 2006 Whole Legs 203.5 USDA Certif… Pric…
243 March 2006 Thighs 222 USDA Certif… Pric…
244 April 2006 Extra Large Dozen 241.5 USDA Certif… Pric…
245 April 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
246 April 2006 Large Dozen 233.5 USDA Certif… Pric…
247 April 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
248 April 2006 Whole 220.5 USDA Certif… Pric…
249 April 2006 B/S Breast 645.5 USDA Certif… Pric…
250 April 2006 Bone-in Breast 390.5 USDA Certif… Pric…
251 April 2006 Whole Legs 203.5 USDA Certif… Pric…
252 April 2006 Thighs 222 USDA Certif… Pric…
253 May 2006 Extra Large Dozen 241.5 USDA Certif… Pric…
254 May 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
255 May 2006 Large Dozen 233.5 USDA Certif… Pric…
256 May 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
257 May 2006 Whole 220.5 USDA Certif… Pric…
258 May 2006 B/S Breast 645.5 USDA Certif… Pric…
259 May 2006 Bone-in Breast 390.5 USDA Certif… Pric…
260 May 2006 Whole Legs 203.5 USDA Certif… Pric…
261 May 2006 Thighs 222 USDA Certif… Pric…
262 June 2006 Extra Large Dozen 241.5 USDA Certif… Pric…
263 June 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
264 June 2006 Large Dozen 233.5 USDA Certif… Pric…
265 June 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
266 June 2006 Whole 220.5 USDA Certif… Pric…
267 June 2006 B/S Breast 645.5 USDA Certif… Pric…
268 June 2006 Bone-in Breast 390.5 USDA Certif… Pric…
269 June 2006 Whole Legs 203.5 USDA Certif… Pric…
270 June 2006 Thighs 222 USDA Certif… Pric…
271 July 2006 Extra Large Dozen 241.5 USDA Certif… Pric…
272 July 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
273 July 2006 Large Dozen 233.5 USDA Certif… Pric…
274 July 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
275 July 2006 Whole 220.5 USDA Certif… Pric…
276 July 2006 B/S Breast 645.5 USDA Certif… Pric…
277 July 2006 Bone-in Breast 390.5 USDA Certif… Pric…
278 July 2006 Whole Legs 203.5 USDA Certif… Pric…
279 July 2006 Thighs 222 USDA Certif… Pric…
280 August 2006 Extra Large Dozen 241.5 USDA Certif… Pric…
281 August 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
282 August 2006 Large Dozen 233.5 USDA Certif… Pric…
283 August 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
284 August 2006 Whole 220.5 USDA Certif… Pric…
285 August 2006 B/S Breast 645.5 USDA Certif… Pric…
286 August 2006 Bone-in Breast 390.5 USDA Certif… Pric…
287 August 2006 Whole Legs 203.5 USDA Certif… Pric…
288 August 2006 Thighs 222 USDA Certif… Pric…
289 September 2006 Extra Large Dozen 241.5 USDA Certif… Pric…
290 September 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
291 September 2006 Large Dozen 233.5 USDA Certif… Pric…
292 September 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
293 September 2006 Whole 220.5 USDA Certif… Pric…
294 September 2006 B/S Breast 645.5 USDA Certif… Pric…
295 September 2006 Bone-in Breast 390.5 USDA Certif… Pric…
296 September 2006 Whole Legs 203.5 USDA Certif… Pric…
297 September 2006 Thighs 222 USDA Certif… Pric…
298 October 2006 Extra Large Dozen 241.5 USDA Certif… Pric…
299 October 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
300 October 2006 Large Dozen 233.5 USDA Certif… Pric…
301 October 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
302 October 2006 Whole 220.5 USDA Certif… Pric…
303 October 2006 B/S Breast 645.5 USDA Certif… Pric…
304 October 2006 Bone-in Breast 390.5 USDA Certif… Pric…
305 October 2006 Whole Legs 203.5 USDA Certif… Pric…
306 October 2006 Thighs 222 USDA Certif… Pric…
307 November 2006 Extra Large Dozen 241.5 USDA Certif… Pric…
308 November 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
309 November 2006 Large Dozen 233.5 USDA Certif… Pric…
310 November 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
311 November 2006 Whole 220.5 USDA Certif… Pric…
312 November 2006 B/S Breast 645.5 USDA Certif… Pric…
313 November 2006 Bone-in Breast 390.5 USDA Certif… Pric…
314 November 2006 Whole Legs 203.5 USDA Certif… Pric…
315 November 2006 Thighs 222 USDA Certif… Pric…
316 December 2006 Extra Large Dozen 241.5 USDA Certif… Pric…
317 December 2006 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
318 December 2006 Large Dozen 233.5 USDA Certif… Pric…
319 December 2006 Large 1/2 Dozen 128.5 USDA Certif… Pric…
320 December 2006 Whole 220.5 USDA Certif… Pric…
321 December 2006 B/S Breast 645.5 USDA Certif… Pric…
322 December 2006 Bone-in Breast 390.5 USDA Certif… Pric…
323 December 2006 Whole Legs 203.5 USDA Certif… Pric…
324 December 2006 Thighs 222 USDA Certif… Pric…
325 January 2007 Extra Large Dozen 241.5 USDA Certif… Pric…
326 January 2007 Extra Large 1/2 Dozen 135.5 USDA Certif… Pric…
327 January 2007 Large Dozen 233.5 USDA Certif… Pric…
328 January 2007 Large 1/2 Dozen 128.5 USDA Certif… Pric…
329 January 2007 Whole 220.5 USDA Certif… Pric…
330 January 2007 B/S Breast 645.5 USDA Certif… Pric…
331 January 2007 Bone-in Breast 390.5 USDA Certif… Pric…
332 January 2007 Whole Legs 203.5 USDA Certif… Pric…
333 January 2007 Thighs 222 USDA Certif… Pric…
334 February 2007 Extra Large Dozen 244.125 USDA Certif… Pric…
335 February 2007 Extra Large 1/2 Dozen 138.125 USDA Certif… Pric…
336 February 2007 Large Dozen 236.125 USDA Certif… Pric…
337 February 2007 Large 1/2 Dozen 131.125 USDA Certif… Pric…
338 February 2007 Whole 220.5 USDA Certif… Pric…
339 February 2007 B/S Breast 645.5 USDA Certif… Pric…
340 February 2007 Bone-in Breast 390.5 USDA Certif… Pric…
341 February 2007 Whole Legs 203.5 USDA Certif… Pric…
342 February 2007 Thighs 222 USDA Certif… Pric…
343 March 2007 Extra Large Dozen 245 USDA Certif… Pric…
344 March 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
345 March 2007 Large Dozen 237 USDA Certif… Pric…
346 March 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
347 March 2007 Whole 220.5 USDA Certif… Pric…
348 March 2007 B/S Breast 645.5 USDA Certif… Pric…
349 March 2007 Bone-in Breast 390.5 USDA Certif… Pric…
350 March 2007 Whole Legs 203.5 USDA Certif… Pric…
351 March 2007 Thighs 222 USDA Certif… Pric…
352 April 2007 Extra Large Dozen 245 USDA Certif… Pric…
353 April 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
354 April 2007 Large Dozen 237 USDA Certif… Pric…
355 April 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
356 April 2007 Whole 220.5 USDA Certif… Pric…
357 April 2007 B/S Breast 645.5 USDA Certif… Pric…
358 April 2007 Bone-in Breast 390.5 USDA Certif… Pric…
359 April 2007 Whole Legs 203.5 USDA Certif… Pric…
360 April 2007 Thighs 222 USDA Certif… Pric…
361 May 2007 Extra Large Dozen 245 USDA Certif… Pric…
362 May 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
363 May 2007 Large Dozen 237 USDA Certif… Pric…
364 May 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
365 May 2007 Whole 220.5 USDA Certif… Pric…
366 May 2007 B/S Breast 645.5 USDA Certif… Pric…
367 May 2007 Bone-in Breast 390.5 USDA Certif… Pric…
368 May 2007 Whole Legs 203.5 USDA Certif… Pric…
369 May 2007 Thighs 222 USDA Certif… Pric…
370 June 2007 Extra Large Dozen 245 USDA Certif… Pric…
371 June 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
372 June 2007 Large Dozen 237 USDA Certif… Pric…
373 June 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
374 June 2007 Whole 220.5 USDA Certif… Pric…
375 June 2007 B/S Breast 645.5 USDA Certif… Pric…
376 June 2007 Bone-in Breast 390.5 USDA Certif… Pric…
377 June 2007 Whole Legs 203.5 USDA Certif… Pric…
378 June 2007 Thighs 222 USDA Certif… Pric…
379 July 2007 Extra Large Dozen 245 USDA Certif… Pric…
380 July 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
381 July 2007 Large Dozen 237 USDA Certif… Pric…
382 July 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
383 July 2007 Whole 220.5 USDA Certif… Pric…
384 July 2007 B/S Breast 645.5 USDA Certif… Pric…
385 July 2007 Bone-in Breast 390.5 USDA Certif… Pric…
386 July 2007 Whole Legs 203.5 USDA Certif… Pric…
387 July 2007 Thighs 222 USDA Certif… Pric…
388 August 2007 Extra Large Dozen 245 USDA Certif… Pric…
389 August 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
390 August 2007 Large Dozen 237 USDA Certif… Pric…
391 August 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
392 August 2007 Whole 220.5 USDA Certif… Pric…
393 August 2007 B/S Breast 645.5 USDA Certif… Pric…
394 August 2007 Bone-in Breast 390.5 USDA Certif… Pric…
395 August 2007 Whole Legs 203.5 USDA Certif… Pric…
396 August 2007 Thighs 222 USDA Certif… Pric…
397 September 2007 Extra Large Dozen 245 USDA Certif… Pric…
398 September 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
399 September 2007 Large Dozen 237 USDA Certif… Pric…
400 September 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
401 September 2007 Whole 220.5 USDA Certif… Pric…
402 September 2007 B/S Breast 645.5 USDA Certif… Pric…
403 September 2007 Bone-in Breast 390.5 USDA Certif… Pric…
404 September 2007 Whole Legs 203.5 USDA Certif… Pric…
405 September 2007 Thighs 222 USDA Certif… Pric…
406 October 2007 Extra Large Dozen 245 USDA Certif… Pric…
407 October 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
408 October 2007 Large Dozen 237 USDA Certif… Pric…
409 October 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
410 October 2007 Whole 220.5 USDA Certif… Pric…
411 October 2007 B/S Breast 645.5 USDA Certif… Pric…
412 October 2007 Bone-in Breast 390.5 USDA Certif… Pric…
413 October 2007 Whole Legs 203.5 USDA Certif… Pric…
414 October 2007 Thighs 222 USDA Certif… Pric…
415 November 2007 Extra Large Dozen 245 USDA Certif… Pric…
416 November 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
417 November 2007 Large Dozen 237 USDA Certif… Pric…
418 November 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
419 November 2007 Whole 220.5 USDA Certif… Pric…
420 November 2007 B/S Breast 645.5 USDA Certif… Pric…
421 November 2007 Bone-in Breast 390.5 USDA Certif… Pric…
422 November 2007 Whole Legs 203.5 USDA Certif… Pric…
423 November 2007 Thighs 222 USDA Certif… Pric…
424 December 2007 Extra Large Dozen 245 USDA Certif… Pric…
425 December 2007 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
426 December 2007 Large Dozen 237 USDA Certif… Pric…
427 December 2007 Large 1/2 Dozen 132 USDA Certif… Pric…
428 December 2007 Whole 220.5 USDA Certif… Pric…
429 December 2007 B/S Breast 645.5 USDA Certif… Pric…
430 December 2007 Bone-in Breast 390.5 USDA Certif… Pric…
431 December 2007 Whole Legs 203.5 USDA Certif… Pric…
432 December 2007 Thighs 222 USDA Certif… Pric…
433 January 2008 Extra Large Dozen 245 USDA Certif… Pric…
434 January 2008 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
435 January 2008 Large Dozen 237 USDA Certif… Pric…
436 January 2008 Large 1/2 Dozen 132 USDA Certif… Pric…
437 January 2008 Whole 220.5 USDA Certif… Pric…
438 January 2008 B/S Breast 645.5 USDA Certif… Pric…
439 January 2008 Bone-in Breast 390.5 USDA Certif… Pric…
440 January 2008 Whole Legs 203.5 USDA Certif… Pric…
441 January 2008 Thighs 222 USDA Certif… Pric…
442 February 2008 Extra Large Dozen 245 USDA Certif… Pric…
443 February 2008 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
444 February 2008 Large Dozen 237 USDA Certif… Pric…
445 February 2008 Large 1/2 Dozen 132 USDA Certif… Pric…
446 February 2008 Whole 220.5 USDA Certif… Pric…
447 February 2008 B/S Breast 645.5 USDA Certif… Pric…
448 February 2008 Bone-in Breast 390.5 USDA Certif… Pric…
449 February 2008 Whole Legs 203.5 USDA Certif… Pric…
450 February 2008 Thighs 222 USDA Certif… Pric…
451 March 2008 Extra Large Dozen 245 USDA Certif… Pric…
452 March 2008 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
453 March 2008 Large Dozen 237 USDA Certif… Pric…
454 March 2008 Large 1/2 Dozen 132 USDA Certif… Pric…
455 March 2008 Whole 220.5 USDA Certif… Pric…
456 March 2008 B/S Breast 645.5 USDA Certif… Pric…
457 March 2008 Bone-in Breast 390.5 USDA Certif… Pric…
458 March 2008 Whole Legs 203.5 USDA Certif… Pric…
459 March 2008 Thighs 222 USDA Certif… Pric…
460 April 2008 Extra Large Dozen 245 USDA Certif… Pric…
461 April 2008 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
462 April 2008 Large Dozen 237 USDA Certif… Pric…
463 April 2008 Large 1/2 Dozen 132 USDA Certif… Pric…
464 April 2008 Whole 220.5 USDA Certif… Pric…
465 April 2008 B/S Breast 645.5 USDA Certif… Pric…
466 April 2008 Bone-in Breast 390.5 USDA Certif… Pric…
467 April 2008 Whole Legs 203.5 USDA Certif… Pric…
468 April 2008 Thighs 222 USDA Certif… Pric…
469 May 2008 Extra Large Dozen 245 USDA Certif… Pric…
470 May 2008 Extra Large 1/2 Dozen 139 USDA Certif… Pric…
471 May 2008 Large Dozen 237 USDA Certif… Pric…
472 May 2008 Large 1/2 Dozen 132 USDA Certif… Pric…
473 May 2008 Whole 220.5 USDA Certif… Pric…
474 May 2008 B/S Breast 645.5 USDA Certif… Pric…
475 May 2008 Bone-in Breast 390.5 USDA Certif… Pric…
476 May 2008 Whole Legs 203.5 USDA Certif… Pric…
477 May 2008 Thighs 222 USDA Certif… Pric…
478 June 2008 Extra Large Dozen 285.5 USDA Certif… Pric…
479 June 2008 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
480 June 2008 Large Dozen 277.5 USDA Certif… Pric…
481 June 2008 Large 1/2 Dozen 174.5 USDA Certif… Pric…
482 June 2008 Whole 248 USDA Certif… Pric…
483 June 2008 B/S Breast 645.5 USDA Certif… Pric…
484 June 2008 Bone-in Breast 390.5 USDA Certif… Pric…
485 June 2008 Whole Legs 203.5 USDA Certif… Pric…
486 June 2008 Thighs 222 USDA Certif… Pric…
487 July 2008 Extra Large Dozen 285.5 USDA Certif… Pric…
488 July 2008 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
489 July 2008 Large Dozen 277.5 USDA Certif… Pric…
490 July 2008 Large 1/2 Dozen 174.5 USDA Certif… Pric…
491 July 2008 Whole 248 USDA Certif… Pric…
492 July 2008 B/S Breast 645.5 USDA Certif… Pric…
493 July 2008 Bone-in Breast 390.5 USDA Certif… Pric…
494 July 2008 Whole Legs 203.5 USDA Certif… Pric…
495 July 2008 Thighs 222 USDA Certif… Pric…
496 August 2008 Extra Large Dozen 285.5 USDA Certif… Pric…
497 August 2008 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
498 August 2008 Large Dozen 277.5 USDA Certif… Pric…
499 August 2008 Large 1/2 Dozen 174.5 USDA Certif… Pric…
500 August 2008 Whole 248 USDA Certif… Pric…
501 August 2008 B/S Breast 645.5 USDA Certif… Pric…
502 August 2008 Bone-in Breast 390.5 USDA Certif… Pric…
503 August 2008 Whole Legs 203.5 USDA Certif… Pric…
504 August 2008 Thighs 222 USDA Certif… Pric…
505 September 2008 Extra Large Dozen 285.5 USDA Certif… Pric…
506 September 2008 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
507 September 2008 Large Dozen 277.5 USDA Certif… Pric…
508 September 2008 Large 1/2 Dozen 174.5 USDA Certif… Pric…
509 September 2008 Whole 248 USDA Certif… Pric…
510 September 2008 B/S Breast 645.5 USDA Certif… Pric…
511 September 2008 Bone-in Breast 390.5 USDA Certif… Pric…
512 September 2008 Whole Legs 203.5 USDA Certif… Pric…
513 September 2008 Thighs 222 USDA Certif… Pric…
514 October 2008 Extra Large Dozen 285.5 USDA Certif… Pric…
515 October 2008 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
516 October 2008 Large Dozen 277.5 USDA Certif… Pric…
517 October 2008 Large 1/2 Dozen 174.5 USDA Certif… Pric…
518 October 2008 Whole 248 USDA Certif… Pric…
519 October 2008 B/S Breast 645.5 USDA Certif… Pric…
520 October 2008 Bone-in Breast 390.5 USDA Certif… Pric…
521 October 2008 Whole Legs 203.5 USDA Certif… Pric…
522 October 2008 Thighs 222 USDA Certif… Pric…
523 November 2008 Extra Large Dozen 285.5 USDA Certif… Pric…
524 November 2008 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
525 November 2008 Large Dozen 277.5 USDA Certif… Pric…
526 November 2008 Large 1/2 Dozen 174.5 USDA Certif… Pric…
527 November 2008 Whole 248 USDA Certif… Pric…
528 November 2008 B/S Breast 645.5 USDA Certif… Pric…
529 November 2008 Bone-in Breast 390.5 USDA Certif… Pric…
530 November 2008 Whole Legs 203.5 USDA Certif… Pric…
531 November 2008 Thighs 222 USDA Certif… Pric…
532 December 2008 Extra Large Dozen 285.5 USDA Certif… Pric…
533 December 2008 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
534 December 2008 Large Dozen 277.5 USDA Certif… Pric…
535 December 2008 Large 1/2 Dozen 174.5 USDA Certif… Pric…
536 December 2008 Whole 248 USDA Certif… Pric…
537 December 2008 B/S Breast 645.5 USDA Certif… Pric…
538 December 2008 Bone-in Breast 390.5 USDA Certif… Pric…
539 December 2008 Whole Legs 203.5 USDA Certif… Pric…
540 December 2008 Thighs 222 USDA Certif… Pric…
541 January 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
542 January 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
543 January 2009 Large Dozen 277.5 USDA Certif… Pric…
544 January 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
545 January 2009 Whole 248 USDA Certif… Pric…
546 January 2009 B/S Breast 645.5 USDA Certif… Pric…
547 January 2009 Bone-in Breast 390.5 USDA Certif… Pric…
548 January 2009 Whole Legs 203.5 USDA Certif… Pric…
549 January 2009 Thighs 222 USDA Certif… Pric…
550 February 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
551 February 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
552 February 2009 Large Dozen 277.5 USDA Certif… Pric…
553 February 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
554 February 2009 Whole 248 USDA Certif… Pric…
555 February 2009 B/S Breast 645.5 USDA Certif… Pric…
556 February 2009 Bone-in Breast 390.5 USDA Certif… Pric…
557 February 2009 Whole Legs 203.5 USDA Certif… Pric…
558 February 2009 Thighs 222 USDA Certif… Pric…
559 March 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
560 March 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
561 March 2009 Large Dozen 277.5 USDA Certif… Pric…
562 March 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
563 March 2009 Whole 248 USDA Certif… Pric…
564 March 2009 B/S Breast 645.5 USDA Certif… Pric…
565 March 2009 Bone-in Breast 390.5 USDA Certif… Pric…
566 March 2009 Whole Legs 203.5 USDA Certif… Pric…
567 March 2009 Thighs 222 USDA Certif… Pric…
568 April 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
569 April 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
570 April 2009 Large Dozen 277.5 USDA Certif… Pric…
571 April 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
572 April 2009 Whole 248 USDA Certif… Pric…
573 April 2009 B/S Breast 645.5 USDA Certif… Pric…
574 April 2009 Bone-in Breast 390.5 USDA Certif… Pric…
575 April 2009 Whole Legs 203.5 USDA Certif… Pric…
576 April 2009 Thighs 222 USDA Certif… Pric…
577 May 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
578 May 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
579 May 2009 Large Dozen 277.5 USDA Certif… Pric…
580 May 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
581 May 2009 Whole 248 USDA Certif… Pric…
582 May 2009 B/S Breast 645.5 USDA Certif… Pric…
583 May 2009 Bone-in Breast 390.5 USDA Certif… Pric…
584 May 2009 Whole Legs 203.5 USDA Certif… Pric…
585 May 2009 Thighs 222 USDA Certif… Pric…
586 June 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
587 June 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
588 June 2009 Large Dozen 277.5 USDA Certif… Pric…
589 June 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
590 June 2009 Whole 248 USDA Certif… Pric…
591 June 2009 B/S Breast 645.5 USDA Certif… Pric…
592 June 2009 Bone-in Breast 390.5 USDA Certif… Pric…
593 June 2009 Whole Legs 203.5 USDA Certif… Pric…
594 June 2009 Thighs 222 USDA Certif… Pric…
595 July 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
596 July 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
597 July 2009 Large Dozen 277.5 USDA Certif… Pric…
598 July 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
599 July 2009 Whole 248 USDA Certif… Pric…
600 July 2009 B/S Breast 645.5 USDA Certif… Pric…
601 July 2009 Bone-in Breast 390.5 USDA Certif… Pric…
602 July 2009 Whole Legs 203.5 USDA Certif… Pric…
603 July 2009 Thighs 222 USDA Certif… Pric…
604 August 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
605 August 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
606 August 2009 Large Dozen 271.5 USDA Certif… Pric…
607 August 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
608 August 2009 Whole 248 USDA Certif… Pric…
609 August 2009 B/S Breast 645.5 USDA Certif… Pric…
610 August 2009 Bone-in Breast 390.5 USDA Certif… Pric…
611 August 2009 Whole Legs 203.5 USDA Certif… Pric…
612 August 2009 Thighs 222 USDA Certif… Pric…
613 September 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
614 September 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
615 September 2009 Large Dozen 271.5 USDA Certif… Pric…
616 September 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
617 September 2009 Whole 248 USDA Certif… Pric…
618 September 2009 B/S Breast 645.5 USDA Certif… Pric…
619 September 2009 Bone-in Breast 390.5 USDA Certif… Pric…
620 September 2009 Whole Legs 203.5 USDA Certif… Pric…
621 September 2009 Thighs 222 USDA Certif… Pric…
622 October 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
623 October 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
624 October 2009 Large Dozen 271.5 USDA Certif… Pric…
625 October 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
626 October 2009 Whole 248 USDA Certif… Pric…
627 October 2009 B/S Breast 645.5 USDA Certif… Pric…
628 October 2009 Bone-in Breast 390.5 USDA Certif… Pric…
629 October 2009 Whole Legs 203.5 USDA Certif… Pric…
630 October 2009 Thighs 222 USDA Certif… Pric…
631 November 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
632 November 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
633 November 2009 Large Dozen 271.5 USDA Certif… Pric…
634 November 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
635 November 2009 Whole 248 USDA Certif… Pric…
636 November 2009 B/S Breast 645.5 USDA Certif… Pric…
637 November 2009 Bone-in Breast 390.5 USDA Certif… Pric…
638 November 2009 Whole Legs 203.5 USDA Certif… Pric…
639 November 2009 Thighs 222 USDA Certif… Pric…
640 December 2009 Extra Large Dozen 285.5 USDA Certif… Pric…
641 December 2009 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
642 December 2009 Large Dozen 271.5 USDA Certif… Pric…
643 December 2009 Large 1/2 Dozen 174.5 USDA Certif… Pric…
644 December 2009 Whole 248 USDA Certif… Pric…
645 December 2009 B/S Breast 645.5 USDA Certif… Pric…
646 December 2009 Bone-in Breast 390.5 USDA Certif… Pric…
647 December 2009 Whole Legs 203.5 USDA Certif… Pric…
648 December 2009 Thighs 222 USDA Certif… Pric…
649 January 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
650 January 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
651 January 2010 Large Dozen 271.5 USDA Certif… Pric…
652 January 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
653 January 2010 Whole 248 USDA Certif… Pric…
654 January 2010 B/S Breast 645.5 USDA Certif… Pric…
655 January 2010 Bone-in Breast 390.5 USDA Certif… Pric…
656 January 2010 Whole Legs 203.5 USDA Certif… Pric…
657 January 2010 Thighs 222 USDA Certif… Pric…
658 February 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
659 February 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
660 February 2010 Large Dozen 271.5 USDA Certif… Pric…
661 February 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
662 February 2010 Whole 248 USDA Certif… Pric…
663 February 2010 B/S Breast 645.5 USDA Certif… Pric…
664 February 2010 Bone-in Breast 390.5 USDA Certif… Pric…
665 February 2010 Whole Legs 203.5 USDA Certif… Pric…
666 February 2010 Thighs 222 USDA Certif… Pric…
667 March 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
668 March 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
669 March 2010 Large Dozen 268 USDA Certif… Pric…
670 March 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
671 March 2010 Whole 248 USDA Certif… Pric…
672 March 2010 B/S Breast 645.5 USDA Certif… Pric…
673 March 2010 Bone-in Breast 390.5 USDA Certif… Pric…
674 March 2010 Whole Legs 203.5 USDA Certif… Pric…
675 March 2010 Thighs 222 USDA Certif… Pric…
676 April 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
677 April 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
678 April 2010 Large Dozen 268 USDA Certif… Pric…
679 April 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
680 April 2010 Whole 241.5 USDA Certif… Pric…
681 April 2010 B/S Breast 645.5 USDA Certif… Pric…
682 April 2010 Bone-in Breast 390.5 USDA Certif… Pric…
683 April 2010 Whole Legs 203.5 USDA Certif… Pric…
684 April 2010 Thighs 222 USDA Certif… Pric…
685 May 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
686 May 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
687 May 2010 Large Dozen 268 USDA Certif… Pric…
688 May 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
689 May 2010 Whole 235 USDA Certif… Pric…
690 May 2010 B/S Breast 645.5 USDA Certif… Pric…
691 May 2010 Bone-in Breast 390.5 USDA Certif… Pric…
692 May 2010 Whole Legs 203.5 USDA Certif… Pric…
693 May 2010 Thighs 222 USDA Certif… Pric…
694 June 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
695 June 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
696 June 2010 Large Dozen 268 USDA Certif… Pric…
697 June 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
698 June 2010 Whole 235 USDA Certif… Pric…
699 June 2010 B/S Breast 645.5 USDA Certif… Pric…
700 June 2010 Bone-in Breast 390.5 USDA Certif… Pric…
701 June 2010 Whole Legs 203.5 USDA Certif… Pric…
702 June 2010 Thighs 222 USDA Certif… Pric…
703 July 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
704 July 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
705 July 2010 Large Dozen 268 USDA Certif… Pric…
706 July 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
707 July 2010 Whole 241.5 USDA Certif… Pric…
708 July 2010 B/S Breast 645.5 USDA Certif… Pric…
709 July 2010 Bone-in Breast 390.5 USDA Certif… Pric…
710 July 2010 Whole Legs 203.5 USDA Certif… Pric…
711 July 2010 Thighs 222 USDA Certif… Pric…
712 August 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
713 August 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
714 August 2010 Large Dozen 268 USDA Certif… Pric…
715 August 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
716 August 2010 Whole 235 USDA Certif… Pric…
717 August 2010 B/S Breast 642.29999999999995 USDA Certif… Pric…
718 August 2010 Bone-in Breast 390.5 USDA Certif… Pric…
719 August 2010 Whole Legs 203.5 USDA Certif… Pric…
720 August 2010 Thighs 219.19999999999999 USDA Certif… Pric…
721 September 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
722 September 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
723 September 2010 Large Dozen 268 USDA Certif… Pric…
724 September 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
725 September 2010 Whole 235 USDA Certif… Pric…
726 September 2010 B/S Breast 637.5 USDA Certif… Pric…
727 September 2010 Bone-in Breast 390.5 USDA Certif… Pric…
728 September 2010 Whole Legs 203.5 USDA Certif… Pric…
729 September 2010 Thighs 215 USDA Certif… Pric…
730 October 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
731 October 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
732 October 2010 Large Dozen 267.5 USDA Certif… Pric…
733 October 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
734 October 2010 Whole 235 USDA Certif… Pric…
735 October 2010 B/S Breast 637.5 USDA Certif… Pric…
736 October 2010 Bone-in Breast 390.5 USDA Certif… Pric…
737 October 2010 Whole Legs 203.5 USDA Certif… Pric…
738 October 2010 Thighs 215 USDA Certif… Pric…
739 November 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
740 November 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
741 November 2010 Large Dozen 267.5 USDA Certif… Pric…
742 November 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
743 November 2010 Whole 235 USDA Certif… Pric…
744 November 2010 B/S Breast 637.5 USDA Certif… Pric…
745 November 2010 Bone-in Breast 390.5 USDA Certif… Pric…
746 November 2010 Whole Legs 203.5 USDA Certif… Pric…
747 November 2010 Thighs 215 USDA Certif… Pric…
748 December 2010 Extra Large Dozen 285.5 USDA Certif… Pric…
749 December 2010 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
750 December 2010 Large Dozen 267.5 USDA Certif… Pric…
751 December 2010 Large 1/2 Dozen 174.5 USDA Certif… Pric…
752 December 2010 Whole 235 USDA Certif… Pric…
753 December 2010 B/S Breast 637.5 USDA Certif… Pric…
754 December 2010 Bone-in Breast 390.5 USDA Certif… Pric…
755 December 2010 Whole Legs 203.5 USDA Certif… Pric…
756 December 2010 Thighs 215 USDA Certif… Pric…
757 January 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
758 January 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
759 January 2011 Large Dozen 267.5 USDA Certif… Pric…
760 January 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
761 January 2011 Whole 235 USDA Certif… Pric…
762 January 2011 B/S Breast 637.5 USDA Certif… Pric…
763 January 2011 Bone-in Breast 390.5 USDA Certif… Pric…
764 January 2011 Whole Legs 203.5 USDA Certif… Pric…
765 January 2011 Thighs 215 USDA Certif… Pric…
766 February 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
767 February 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
768 February 2011 Large Dozen 267.5 USDA Certif… Pric…
769 February 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
770 February 2011 Whole 235 USDA Certif… Pric…
771 February 2011 B/S Breast 637.5 USDA Certif… Pric…
772 February 2011 Bone-in Breast 390.5 USDA Certif… Pric…
773 February 2011 Whole Legs 203.5 USDA Certif… Pric…
774 February 2011 Thighs 215 USDA Certif… Pric…
775 March 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
776 March 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
777 March 2011 Large Dozen 267.5 USDA Certif… Pric…
778 March 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
779 March 2011 Whole 235 USDA Certif… Pric…
780 March 2011 B/S Breast 637.5 USDA Certif… Pric…
781 March 2011 Bone-in Breast 390.5 USDA Certif… Pric…
782 March 2011 Whole Legs 203.5 USDA Certif… Pric…
783 March 2011 Thighs 215 USDA Certif… Pric…
784 April 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
785 April 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
786 April 2011 Large Dozen 267.5 USDA Certif… Pric…
787 April 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
788 April 2011 Whole 235 USDA Certif… Pric…
789 April 2011 B/S Breast 637.5 USDA Certif… Pric…
790 April 2011 Bone-in Breast 390.5 USDA Certif… Pric…
791 April 2011 Whole Legs 203.5 USDA Certif… Pric…
792 April 2011 Thighs 215 USDA Certif… Pric…
793 May 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
794 May 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
795 May 2011 Large Dozen 267.5 USDA Certif… Pric…
796 May 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
797 May 2011 Whole 235 USDA Certif… Pric…
798 May 2011 B/S Breast 637.5 USDA Certif… Pric…
799 May 2011 Bone-in Breast 390.5 USDA Certif… Pric…
800 May 2011 Whole Legs 203.5 USDA Certif… Pric…
801 May 2011 Thighs 215 USDA Certif… Pric…
802 June 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
803 June 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
804 June 2011 Large Dozen 270 USDA Certif… Pric…
805 June 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
806 June 2011 Whole 235 USDA Certif… Pric…
807 June 2011 B/S Breast 637.5 USDA Certif… Pric…
808 June 2011 Bone-in Breast 390.5 USDA Certif… Pric…
809 June 2011 Whole Legs 203.5 USDA Certif… Pric…
810 June 2011 Thighs 215 USDA Certif… Pric…
811 July 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
812 July 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
813 July 2011 Large Dozen 270 USDA Certif… Pric…
814 July 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
815 July 2011 Whole 235 USDA Certif… Pric…
816 July 2011 B/S Breast 637.5 USDA Certif… Pric…
817 July 2011 Bone-in Breast 390.5 USDA Certif… Pric…
818 July 2011 Whole Legs 203.5 USDA Certif… Pric…
819 July 2011 Thighs 215 USDA Certif… Pric…
820 August 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
821 August 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
822 August 2011 Large Dozen 270 USDA Certif… Pric…
823 August 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
824 August 2011 Whole 235 USDA Certif… Pric…
825 August 2011 B/S Breast 637.5 USDA Certif… Pric…
826 August 2011 Bone-in Breast 390.5 USDA Certif… Pric…
827 August 2011 Whole Legs 203.5 USDA Certif… Pric…
828 August 2011 Thighs 215 USDA Certif… Pric…
829 September 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
830 September 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
831 September 2011 Large Dozen 270 USDA Certif… Pric…
832 September 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
833 September 2011 Whole 235 USDA Certif… Pric…
834 September 2011 B/S Breast 637.5 USDA Certif… Pric…
835 September 2011 Bone-in Breast 390.5 USDA Certif… Pric…
836 September 2011 Whole Legs 203.5 USDA Certif… Pric…
837 September 2011 Thighs 215 USDA Certif… Pric…
838 October 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
839 October 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
840 October 2011 Large Dozen 270 USDA Certif… Pric…
841 October 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
842 October 2011 Whole 235 USDA Certif… Pric…
843 October 2011 B/S Breast 637.5 USDA Certif… Pric…
844 October 2011 Bone-in Breast 390.5 USDA Certif… Pric…
845 October 2011 Whole Legs 203.5 USDA Certif… Pric…
846 October 2011 Thighs 215 USDA Certif… Pric…
847 November 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
848 November 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
849 November 2011 Large Dozen 270 USDA Certif… Pric…
850 November 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
851 November 2011 Whole 235 USDA Certif… Pric…
852 November 2011 B/S Breast 637.5 USDA Certif… Pric…
853 November 2011 Bone-in Breast 390.5 USDA Certif… Pric…
854 November 2011 Whole Legs 203.5 USDA Certif… Pric…
855 November 2011 Thighs 215 USDA Certif… Pric…
856 December 2011 Extra Large Dozen 285.5 USDA Certif… Pric…
857 December 2011 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
858 December 2011 Large Dozen 270 USDA Certif… Pric…
859 December 2011 Large 1/2 Dozen 174.5 USDA Certif… Pric…
860 December 2011 Whole 235 USDA Certif… Pric…
861 December 2011 B/S Breast 637.5 USDA Certif… Pric…
862 December 2011 Bone-in Breast 390.5 USDA Certif… Pric…
863 December 2011 Whole Legs 203.5 USDA Certif… Pric…
864 December 2011 Thighs 215 USDA Certif… Pric…
865 January 2012 Extra Large Dozen 285.5 USDA Certif… Pric…
866 January 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
867 January 2012 Large Dozen 267.5 USDA Certif… Pric…
868 January 2012 Large 1/2 Dozen 174.5 USDA Certif… Pric…
869 January 2012 Whole 235 USDA Certif… Pric…
870 January 2012 B/S Breast 637.5 USDA Certif… Pric…
871 January 2012 Bone-in Breast 390.5 USDA Certif… Pric…
872 January 2012 Whole Legs 203.5 USDA Certif… Pric…
873 January 2012 Thighs 215 USDA Certif… Pric…
874 February 2012 Extra Large Dozen 288.5 USDA Certif… Pric…
875 February 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
876 February 2012 Large Dozen 267.5 USDA Certif… Pric…
877 February 2012 Large 1/2 Dozen 174.5 USDA Certif… Pric…
878 February 2012 Whole 238.5 USDA Certif… Pric…
879 February 2012 B/S Breast 700 USDA Certif… Pric…
880 February 2012 Bone-in Breast 390.5 USDA Certif… Pric…
881 February 2012 Whole Legs 203.5 USDA Certif… Pric…
882 February 2012 Thighs 215 USDA Certif… Pric…
883 March 2012 Extra Large Dozen 288.5 USDA Certif… Pric…
884 March 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
885 March 2012 Large Dozen 267.5 USDA Certif… Pric…
886 March 2012 Large 1/2 Dozen 174.5 USDA Certif… Pric…
887 March 2012 Whole 238.5 USDA Certif… Pric…
888 March 2012 B/S Breast 700 USDA Certif… Pric…
889 March 2012 Bone-in Breast 390.5 USDA Certif… Pric…
890 March 2012 Whole Legs 203.5 USDA Certif… Pric…
891 March 2012 Thighs 215 USDA Certif… Pric…
892 April 2012 Extra Large Dozen 288.5 USDA Certif… Pric…
893 April 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
894 April 2012 Large Dozen 267.5 USDA Certif… Pric…
895 April 2012 Large 1/2 Dozen 174.5 USDA Certif… Pric…
896 April 2012 Whole 238.5 USDA Certif… Pric…
897 April 2012 B/S Breast 700 USDA Certif… Pric…
898 April 2012 Bone-in Breast 390.5 USDA Certif… Pric…
899 April 2012 Whole Legs 203.5 USDA Certif… Pric…
900 April 2012 Thighs 215 USDA Certif… Pric…
901 May 2012 Extra Large Dozen 288.5 USDA Certif… Pric…
902 May 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
903 May 2012 Large Dozen 267.5 USDA Certif… Pric…
904 May 2012 Large 1/2 Dozen 173.25 USDA Certif… Pric…
905 May 2012 Whole 238.5 USDA Certif… Pric…
906 May 2012 B/S Breast 700 USDA Certif… Pric…
907 May 2012 Bone-in Breast 390.5 USDA Certif… Pric…
908 May 2012 Whole Legs 203.5 USDA Certif… Pric…
909 May 2012 Thighs 215 USDA Certif… Pric…
910 June 2012 Extra Large Dozen 288.5 USDA Certif… Pric…
911 June 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
912 June 2012 Large Dozen 267.5 USDA Certif… Pric…
913 June 2012 Large 1/2 Dozen 173.25 USDA Certif… Pric…
914 June 2012 Whole 238.5 USDA Certif… Pric…
915 June 2012 B/S Breast 700 USDA Certif… Pric…
916 June 2012 Bone-in Breast 390.5 USDA Certif… Pric…
917 June 2012 Whole Legs 203.5 USDA Certif… Pric…
918 June 2012 Thighs 215 USDA Certif… Pric…
919 July 2012 Extra Large Dozen 288.5 USDA Certif… Pric…
920 July 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
921 July 2012 Large Dozen 267.5 USDA Certif… Pric…
922 July 2012 Large 1/2 Dozen 173.25 USDA Certif… Pric…
923 July 2012 Whole 238.5 USDA Certif… Pric…
924 July 2012 B/S Breast 700 USDA Certif… Pric…
925 July 2012 Bone-in Breast 390.5 USDA Certif… Pric…
926 July 2012 Whole Legs 203.5 USDA Certif… Pric…
927 July 2012 Thighs 215 USDA Certif… Pric…
928 August 2012 Extra Large Dozen 288.5 USDA Certif… Pric…
929 August 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
930 August 2012 Large Dozen 267.5 USDA Certif… Pric…
931 August 2012 Large 1/2 Dozen 173.25 USDA Certif… Pric…
932 August 2012 Whole 238.5 USDA Certif… Pric…
933 August 2012 B/S Breast 700 USDA Certif… Pric…
934 August 2012 Bone-in Breast 390.5 USDA Certif… Pric…
935 August 2012 Whole Legs 203.5 USDA Certif… Pric…
936 August 2012 Thighs 216.25 USDA Certif… Pric…
937 September 2012 Extra Large Dozen 288.5 USDA Certif… Pric…
938 September 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
939 September 2012 Large Dozen 267.5 USDA Certif… Pric…
940 September 2012 Large 1/2 Dozen 173.25 USDA Certif… Pric…
941 September 2012 Whole 238.5 USDA Certif… Pric…
942 September 2012 B/S Breast 700 USDA Certif… Pric…
943 September 2012 Bone-in Breast 390.5 USDA Certif… Pric…
944 September 2012 Whole Legs 203.5 USDA Certif… Pric…
945 September 2012 Thighs 216.25 USDA Certif… Pric…
946 October 2012 Extra Large Dozen 288.5 USDA Certif… Pric…
947 October 2012 Extra Large 1/2 Dozen 185.5 USDA Certif… Pric…
948 October 2012 Large Dozen 267.5 USDA Certif… Pric…
949 October 2012 Large 1/2 Dozen 173.25 USDA Certif… Pric…
950 October 2012 Whole 238.5 USDA Certif… Pric…
951 October 2012 B/S Breast 700 USDA Certif… Pric…
952 October 2012 Bone-in Breast 390.5 USDA Certif… Pric…
953 October 2012 Whole Legs 203.5 USDA Certif… Pric…
954 October 2012 Thighs 216.25 USDA Certif… Pric…
955 November 2012 Extra Large Dozen 290 USDA Certif… Pric…
956 November 2012 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
957 November 2012 Large Dozen 267.5 USDA Certif… Pric…
958 November 2012 Large 1/2 Dozen 178 USDA Certif… Pric…
959 November 2012 Whole 238.5 USDA Certif… Pric…
960 November 2012 B/S Breast 703.75 USDA Certif… Pric…
961 November 2012 Bone-in Breast 390.5 USDA Certif… Pric…
962 November 2012 Whole Legs 203.5 USDA Certif… Pric…
963 November 2012 Thighs 216.25 USDA Certif… Pric…
964 December 2012 Extra Large Dozen 290 USDA Certif… Pric…
965 December 2012 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
966 December 2012 Large Dozen 267.5 USDA Certif… Pric…
967 December 2012 Large 1/2 Dozen 178 USDA Certif… Pric…
968 December 2012 Whole 238.5 USDA Certif… Pric…
969 December 2012 B/S Breast 703.75 USDA Certif… Pric…
970 December 2012 Bone-in Breast 390.5 USDA Certif… Pric…
971 December 2012 Whole Legs 203.5 USDA Certif… Pric…
972 December 2012 Thighs 216.25 USDA Certif… Pric…
973 January 2013 Extra Large Dozen 290 USDA Certif… Pric…
974 January 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
975 January 2013 Large Dozen 267.5 USDA Certif… Pric…
976 January 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
977 January 2013 Whole 238.5 USDA Certif… Pric…
978 January 2013 B/S Breast 703.75 USDA Certif… Pric…
979 January 2013 Bone-in Breast 390.5 USDA Certif… Pric…
980 January 2013 Whole Legs 203.5 USDA Certif… Pric…
981 January 2013 Thighs 216.25 USDA Certif… Pric…
982 February 2013 Extra Large Dozen 290 USDA Certif… Pric…
983 February 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
984 February 2013 Large Dozen 267.5 USDA Certif… Pric…
985 February 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
986 February 2013 Whole 238.5 USDA Certif… Pric…
987 February 2013 B/S Breast 703.75 USDA Certif… Pric…
988 February 2013 Bone-in Breast 390.5 USDA Certif… Pric…
989 February 2013 Whole Legs 203.5 USDA Certif… Pric…
990 February 2013 Thighs 216.25 USDA Certif… Pric…
991 March 2013 Extra Large Dozen 290 USDA Certif… Pric…
992 March 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
993 March 2013 Large Dozen 267.5 USDA Certif… Pric…
994 March 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
995 March 2013 Whole 238.5 USDA Certif… Pric…
996 March 2013 B/S Breast 703.75 USDA Certif… Pric…
997 March 2013 Bone-in Breast 390.5 USDA Certif… Pric…
998 March 2013 Whole Legs 203.5 USDA Certif… Pric…
999 March 2013 Thighs 216.25 USDA Certif… Pric…
1000 April 2013 Extra Large Dozen 290 USDA Certif… Pric…
1001 April 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
1002 April 2013 Large Dozen 267.5 USDA Certif… Pric…
1003 April 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
1004 April 2013 Whole 238.5 USDA Certif… Pric…
1005 April 2013 B/S Breast 703.75 USDA Certif… Pric…
1006 April 2013 Bone-in Breast 390.5 USDA Certif… Pric…
1007 April 2013 Whole Legs 203.5 USDA Certif… Pric…
1008 April 2013 Thighs 216.25 USDA Certif… Pric…
1009 May 2013 Extra Large Dozen 290 USDA Certif… Pric…
1010 May 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
1011 May 2013 Large Dozen 267.5 USDA Certif… Pric…
1012 May 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
1013 May 2013 Whole 238.5 USDA Certif… Pric…
1014 May 2013 B/S Breast 703.75 USDA Certif… Pric…
1015 May 2013 Bone-in Breast 390.5 USDA Certif… Pric…
1016 May 2013 Whole Legs 203.5 USDA Certif… Pric…
1017 May 2013 Thighs 216.25 USDA Certif… Pric…
1018 June 2013 Extra Large Dozen 290 USDA Certif… Pric…
1019 June 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
1020 June 2013 Large Dozen 267.5 USDA Certif… Pric…
1021 June 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
1022 June 2013 Whole 238.5 USDA Certif… Pric…
1023 June 2013 B/S Breast 703.75 USDA Certif… Pric…
1024 June 2013 Bone-in Breast 390.5 USDA Certif… Pric…
1025 June 2013 Whole Legs 203.5 USDA Certif… Pric…
1026 June 2013 Thighs 216.25 USDA Certif… Pric…
1027 July 2013 Extra Large Dozen 290 USDA Certif… Pric…
1028 July 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
1029 July 2013 Large Dozen 267.5 USDA Certif… Pric…
1030 July 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
1031 July 2013 Whole 238.5 USDA Certif… Pric…
1032 July 2013 B/S Breast 703.75 USDA Certif… Pric…
1033 July 2013 Bone-in Breast 390.5 USDA Certif… Pric…
1034 July 2013 Whole Legs 203.5 USDA Certif… Pric…
1035 July 2013 Thighs 216.25 USDA Certif… Pric…
1036 August 2013 Extra Large Dozen 290 USDA Certif… Pric…
1037 August 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
1038 August 2013 Large Dozen 267.5 USDA Certif… Pric…
1039 August 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
1040 August 2013 Whole 238.5 USDA Certif… Pric…
1041 August 2013 B/S Breast 703.75 USDA Certif… Pric…
1042 August 2013 Bone-in Breast 390.5 USDA Certif… Pric…
1043 August 2013 Whole Legs 203.5 USDA Certif… Pric…
1044 August 2013 Thighs 216.25 USDA Certif… Pric…
1045 September 2013 Extra Large Dozen 290 USDA Certif… Pric…
1046 September 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
1047 September 2013 Large Dozen 267.5 USDA Certif… Pric…
1048 September 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
1049 September 2013 Whole 238.5 USDA Certif… Pric…
1050 September 2013 B/S Breast 703.75 USDA Certif… Pric…
1051 September 2013 Bone-in Breast 390.5 USDA Certif… Pric…
1052 September 2013 Whole Legs 203.5 USDA Certif… Pric…
1053 September 2013 Thighs 216.25 USDA Certif… Pric…
1054 October 2013 Extra Large Dozen 290 USDA Certif… Pric…
1055 October 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
1056 October 2013 Large Dozen 267.5 USDA Certif… Pric…
1057 October 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
1058 October 2013 Whole 238.5 USDA Certif… Pric…
1059 October 2013 B/S Breast 703.75 USDA Certif… Pric…
1060 October 2013 Bone-in Breast 390.5 USDA Certif… Pric…
1061 October 2013 Whole Legs 203.5 USDA Certif… Pric…
1062 October 2013 Thighs 216.25 USDA Certif… Pric…
1063 November 2013 Extra Large Dozen 290 USDA Certif… Pric…
1064 November 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
1065 November 2013 Large Dozen 267.5 USDA Certif… Pric…
1066 November 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
1067 November 2013 Whole 238.5 USDA Certif… Pric…
1068 November 2013 B/S Breast 703.75 USDA Certif… Pric…
1069 November 2013 Bone-in Breast 390.5 USDA Certif… Pric…
1070 November 2013 Whole Legs 203.5 USDA Certif… Pric…
1071 November 2013 Thighs 216.25 USDA Certif… Pric…
1072 December 2013 Extra Large Dozen 290 USDA Certif… Pric…
1073 December 2013 Extra Large 1/2 Dozen 188.13 USDA Certif… Pric…
1074 December 2013 Large Dozen 267.5 USDA Certif… Pric…
1075 December 2013 Large 1/2 Dozen 178 USDA Certif… Pric…
1076 December 2013 Whole 238.5 USDA Certif… Pric…
1077 December 2013 B/S Breast 703.75 USDA Certif… Pric…
1078 December 2013 Bone-in Breast 390.5 USDA Certif… Pric…
1079 December 2013 Whole Legs 203.5 USDA Certif… Pric…
1080 December 2013 Thighs 216.25 USDA Certif… Pric…
---
title: "Challenge 3"
author: "Tim Shores"
description: "Tidy Data: Pivoting"
date: "03/05/2023"
format:
html:
toc: true
code-fold: true
code-copy: true
code-tools: true
categories:
- challenge_3
- eggs
---
```{r}
#| label: setup
#| warning: false
#| message: false
my_packages <- c("tidyverse", "readxl", "knitr") # create vector of packages
invisible(lapply(my_packages, require, character.only = TRUE)) # load multiple packages
knitr::opts_chunk$set(echo = TRUE, warning=FALSE, message=FALSE)
```
## Challenge Overview
Challenge 3 includes four tasks:
1. read in a dataset and describe it
2. identify what needs to be done to tidy the current data
3. anticipate the shape of pivoted data
4. pivot the data into tidy format using `pivot_longer`
## Task 1) Read in and Describe the Data
I chose to read in the organic egg file, organiceggpoultry.xls. The thought of chickens always brings a smile to my face.
One tricky property of the egg data set is that the Excel file includes data in three tabs, so I can't just read it in with `read_xls()`. I use `excel_sheets()` to return a list of data frames with data populated by each sheet in the Excel file. From the `purrr` library, the `map()` assigns each sheet from the list as a vector element. Also from `purrr`, `set_names()` gives the vector element the same name as the Excel sheet.
Messy, but a good stepping stone. Here are the three vector elements printed:
```{r}
#| echo: true
listEggDFs <- map(set_names(excel_sheets("../posts/_data/organiceggpoultry.xls")),
read_xls, path = "../posts/_data/organiceggpoultry.xls") # read in all sheets as dataframes in a list
listEggDFs
```
The next step is to use `map()` again to assign each data frame in the list to its own variable. This will let me tidy each data frame separately. This is useful because each Excel sheet is organized in a different way, and therefore I must use different commands to tidy each sheet. For clarity of reference, I chose data frame variable names similar to the source file sheet names.
We now have three data frames from one Excel workbook. Here is each data frame printed:
```{r}
df_eggPoultryData <- map(names(listEggDFs), ~assign(.x, listEggDFs[[.x]], envir = .GlobalEnv))[[1]] # assign the first df in the list to a separate df
df_eggPrices <- map(names(listEggDFs), ~assign(.x, listEggDFs[[.x]], envir = .GlobalEnv))[[2]] # assign the second df in the list to a separate df
df_poultryPrices <- map(names(listEggDFs), ~assign(.x, listEggDFs[[.x]], envir = .GlobalEnv))[[3]] # assign the third df in the list to a separate df
df_eggPoultryData
df_eggPrices
df_poultryPrices
```
### Briefly describe the data
The data describes the price of several types of USDA certified organic egg and chicken products from the years 2004 to 2013. The price was paid by 'first receivers', described in a footnote as "those entities that purchases the processed product from the poultry or egg company, such as a retailer, distributor, or manufacturer." The cited data sources are the U.S. Department of Agriculture, Agricultural Marketing Service (AMS) Market News, Organic Poultry and Eggs (Weekly reports).
Although the three Excel worksheets appear at first glance to have different data, the second and third worksheets are just tables that repeat and reorganize the data from the first worksheet. In my analysis below, I only use the data frame df_eggPoultryData mapped from the first Excel worksheet.
The data format has several problems. It's formatted for visual inspection rather than computational analysis. There are extra headings and columns. The date labels are inconsistent. The data is messy in that it uses 9 columns to describe what should be a single variable: the type of egg or chicken item that has price data. As a result, we can consider each row to include 9 observations. I will tidy this up below.
The data includes `r ncol(df_eggPoultryData)` variables (date, 4 egg carton items and 5 chicken items, and an empty column) with prices for `r ncol(df_eggPoultryData) - 2` items for each month of 10 years in `r nrow(df_eggPoultryData) - 4` rows.
## Task 2) Anticipate the End Result
The end result of tidying and pivoting will be a data frame with variables for month, year, item, price, product (egg or chicken), and unit (price per carton or price cents per pound).
By pivoting `r ncol(df_eggPoultryData) - 2` variables into an item and price column representing `r nrow(df_eggPoultryData) - 4` months of data, the final table should have $9 * 120 = 1,080$ rows. Along with month, year, product, and unit variables, the final table should have `r ncol(df_eggPoultryData) - 5` columns.
## Task 3) Pivot the Data
Now we will pivot the data, and compare our pivoted data dimensions to the dimensions calculated above as a "sanity" check.
The following code block takes the following actions to tidy up the eggData data frame:
1. Stores header values in list variables.
i) The headers in the original data tell us that four columns are about eggs, and the other four are about chicken.
ii) They also have egg and chicken unit information about table of values.
iii) This is not made clear in the 4th row column names, so we'll save these values now and add them back later.
2. Assigns values from the 4th populated row to column names.
3. Assigns "month" to the first column name.
4. Slice off the first four rows, which do not have table data.
5. Uses `select` to remove a blank column between the egg and chicken data sets.
6. Uses `separate_wider_delim`, `mutate`, and `fill` to tidy the month column and separate year into its own column. The source data labels the year only on January, implying the year for the other months. It's important to make both month and year explicit for each observation so we don't end up with analysis that makes it difficult to identify the year.
7. Uses `pivot_longer` to pivot the egg and chicken product column headings into row values under a new `item` column, with their values listed in a `price` column.
8. Uses `mutate` to tidy up item values and make labels consistent.
9. Uses `mutate` and `str_detect` to assign the egg and chicken product and unit variables that I recorded earlier according to each egg and chicken item. I used the literal values from the header without modification. They could be made more clear but not without the risk of distorting their original meaning.
10. Prints the entire table.
The full table is below, and it matches my expectation of $9 * 120 = 1,080$ rows.
A new observation added to this data would require the following details:
* Month and year of the observation (earlier than January 2004 or later than December 2013)
* Observation of price per carton of one of the egg items, or cents per pound of one of the chicken items.
How does it meet requirements for tidy data?
* Each column is now a single variable. The variable structure doesn't span columns as it does in the original data set.
* Every row is now a single observation. The original data set crammed 9 observations into each row.
* Every cell is a single value. This was also true of the original data set.
Here is the full data set tidied, pivoted, and printed:
```{r}
productname <- c(df_eggPoultryData[2,1],df_eggPoultryData[2,7])
unitname <- c(df_eggPoultryData[3,1],df_eggPoultryData[3,7])
colnames(df_eggPoultryData) <- df_eggPoultryData[4, ]
colnames(df_eggPoultryData)[1] <- "month"
df_eggPoultryData <- df_eggPoultryData %>%
slice(-(1:4)) %>%
select(!`NA`) %>%
separate_wider_delim(month, delim = " ", names = c("month", "year"), too_few = "align_start", too_many = "merge") %>%
mutate(month = replace(month, month == 'Jan', 'January')) %>%
mutate(year = replace(year, year == '/1', NA)) %>%
fill(year) %>%
pivot_longer(cols = -c(month,year), names_to = "item", values_to = "price") %>%
mutate(item = str_remove_all(item, '\\n')) %>%
mutate(item = str_remove_all(item, '1/2 Dozen')) %>%
mutate(item = str_replace_all(item, 'Doz\\.','Dozen')) %>%
mutate(product = case_when(
str_detect(item, regex("^[EL]")) ~ productname[[1]],
str_detect(item, regex("^[BTW]")) ~ productname[[2]]
)) %>%
mutate(unit = case_when(
str_detect(item, regex("^[EL]")) ~ unitname[[1]],
str_detect(item, regex("^[BTW]")) ~ unitname[[2]]
)) %>%
print(n=1080)
```