Entering edit mode
6.3 years ago
ersan
▴
10
I want to compare data two different table like that using R.
Table 1
X1
a;b
c
d;e
Table 2
Y1
a uuu uu
b vvv vv
c xxx xx
d yyy yy
e zzz zz
Ouptput Table 3
X1 Y2
a;b uuu|uu<\br>vvv|vv
c xxx|xx
d;e yyy|yy<\br>zzz|zz
Very thanks Chirag, i am receiving an error :
Error in mutate_impl(.data, dots) : Evaluation error: NA/NaN argument.
I am receiving another error:
What is the datatype of column Y1 in t2 ? In the sample data you provided, Y1 is character. Error suggest that your Y1 is integer. can you upload full data, if possible ? Without data its hard to predict.
I changed datatype of Y1 integer to character. I am now giving error
Data X1 Data Y
Without any error, it is working perfectly fine in my computer
I notice many duplicated rows. adding
t3 %>% unique()
will give you unique rowsI is worked at me, too. It is wonderfull. Thank you very very much!..
Could I add per X1 to Y2? Output like that:
I found a way. It is working. Thanks for all.
I have a same problem like that? Can you help me please? Merge two comma seperated column in one frame in R