Displaying 4 results from an estimated 4 matches for "fin1540166".
2018 Feb 03
2
find unique and summerize
...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 ID by country code
1 44 33 358 TOT
CAN1540164...
2018 Feb 03
2
find unique and summerize
...t;- table(Country, IDNum)
tbl2=addmargins(tbl1)
write.xlsx(tbl2,"tt1.xlsx"),sheetName="summary", row.names=FALSE)
The above did not give me that table.
2. I want select those unique Ids that do have records in all countries.
From the above data set, this ID "FIN1540166" should be excluded from
the summary table and the table looks like as follow
IDNum
Country 1 33 358 44 Sum
CAN1540164 47 141 248 90 526
USA1540165 290 757 321 171 1539
Sum 337 898 569 261 2065
Thank you again
On Fri, Feb 2, 2018 a...
2018 Feb 03
0
find unique and summerize
...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 ID by country code
> 1...
2018 Feb 05
0
find unique and summerize
...Name="summary",
>> row.names=FALSE)
>> The above did not give me that table.
>>
>>
>> 2. I want select those unique Ids that do have records in all
>> countries.
>> From the above data set, this ID "FIN1540166" should be
>> excluded from the summary table and the table looks like as follow
>>
>> IDNum Country 1 33 358 44 Sum CAN1540164 47 141 248 90 526
>> USA1540165 290 757 321 171 1539 Sum 337 898 569 261 2065
>>
>> Thank you aga...