i have 2 data frames:
df1
servername web01 web02 j2k101 tomcat101 prdc1001 and df2
servername application web01 web j2k10 internal tomcat101 application i want use merge command merge df1 , df2 servernames have application associated them this
merge(df1,df2, by=c("servername") i want list of servers don't have application name. how that?
df1[!(df1$servername %in% df2$servername),] note, have inconsistent capitalisation. if want fixed:
df1[!(toupper(df1$servername) %in% toupper(df2$servername)),]
Comments
Post a Comment