Claret School Class Picture 1992-1993

Grade VI Pedro Paterno

Adviser Ms. Janette Posadas

Claret School of Quezon City

S.Y. 1992-1993

May 7 Relief goods: one whole chicken 😁

I love it. Lutuin na! 

Fix: Picture from blog post in Blogger is not picked-up as preview in Facebook post

Please follow steps and screen shots below. 

1. Go Theme and click the three dots
2. Click Edit HTML
3. Search for "html b:version". You can use Ctrl+F
4. In the, insert "xmlns:og='http://ogp.me/ns#'" at the end of it

Claret School Class Picture 19??

Claret School of Q.C. 94-95 Class Picture

ECL Intergroup, Inc.

How do I merge Rows in R?

Q: How do I merge rows in R?

A: Tidyverse's summarize can be use. Sample below.

Requirement: Remove duplicates and merge data (rows) at the same time.

Sample data

Expected output after merging

Output when we use Excel's Remove Duplicates. Data is lost

Output using R, we get the expected output

Code:

library(tidyverse)

library(readxl)

sampleContainer<-read_excel("SampleContainers.xlsx")

cleanData<-sampleContainer %>%

  group_by(ReferenceNumber, ContainerNumber) %>%

  summarize(lastPullOutadvise=first(PullOutAdvice, order_by = PullOutAdvice),

            lastPullOutCY=first(PullOutCY, order_by = PullOutCY ))