search for: 33usa1540165

...40164 1 25 A 44CAN1540164 1 11 A 33CAN1540164 1 12 A 33CAN1540164 1 23 A 33CAN1540164 1 65 A 33CAN1540164 1 41 A 358CAN1540164 1 28 A 358CAN1540164 1 32 A 358CAN1540164 1 41 A 358CAN1540164 1 54 A 358CAN1540164 1 29 A 358CAN1540164 1 64 B 1USA1540165 1 125 B 1USA1540165 1 165 B 44USA1540165 1 171 B 33USA1540165 1 254 B 33USA1540165 1 241 B 33USA1540165 1 262 B 358USA1540165 1 321 C 358FIN1540166 1 225 "),header = TRUE ,stringsAsFactors = FALSE) >From the above data there are three unique IDs and four country codes (1, 44, 33 and 358) I want the following two tables Table 1. count the unique...

...40164 1 23 > A 33CAN1540164 1 65 > A 33CAN1540164 1 41 > A 358CAN1540164 1 28 > A 358CAN1540164 1 32 > A 358CAN1540164 1 41 > A 358CAN1540164 1 54 > A 358CAN1540164 1 29 > A 358CAN1540164 1 64 > B 1USA1540165 1 125 > B 1USA1540165 1 165 > B 44USA1540165 1 171 > B 33USA1540165 1 254 > B 33USA1540165 1 241 > B 33USA1540165 1 262 > B 358USA1540165 1 321 > C 358FIN1540166 1 225 "),header = TRUE ,stringsAsFactors = FALSE) > > From the above data there are three unique IDs and four country codes (1, > 44, 33 and 358) > > I want the followin...

...A 33CAN1540164 1 41 >> A 358CAN1540164 1 28 >> A 358CAN1540164 1 32 >> A 358CAN1540164 1 41 >> A 358CAN1540164 1 54 >> A 358CAN1540164 1 29 >> A 358CAN1540164 1 64 >> B 1USA1540165 1 125 >> B 1USA1540165 1 165 >> B 44USA1540165 1 171 >> B 33USA1540165 1 254 >> B 33USA1540165 1 241 >> B 33USA1540165 1 262 >> B 358USA1540165 1 321 >> C 358FIN1540166 1 225 "),header = TRUE ,stringsAsFactors = FALSE) >> >> From the above data there are three unique IDs and four country codes >> (1, >> 44, 33 and...

...A 358CAN1540164 1 54 >> A 358CAN1540164 1 29 >> A 358CAN1540164 1 64 >> B 1USA1540165 1 125 >> B 1USA1540165 1 165 >> B 44USA1540165 1 171 >> B 33USA1540165 1 254 >> B 33USA1540165 1 241 >> B 33USA1540165 1 262 >> B 358USA1540165 1 321 >> C 358FIN1540166 1 225 "),header = TRUE >> ,stringsAsFactors = FALSE) >> >>...