r - How to collect the IDs of same group from one file and write it in second file? -

-

I have two big txt files.
The first file contains two columns: Groups and id each group have different IDs. I want to collect all the IDs in each group in file A And I want to add them to B file. I have tried to use total () and merge () . But I was not sure that it was working correctly. Can anyone provide a good solution to this?

The following is the structure of my files and desired output: 

  File A Group ID A / B / CF1A / B / CF5A / B / Cf7a / b / cf6a / b / cf8e / ff1e / ff2e / ff4 . . File b group p / b / c ls a / b / c pr e / f sh e / f sh e / f gn. . Desired output: file B group ID PA / B / CF1 / F5 / F7 / F6 / F8 LS A / B / CF1 / F5 / F7 / F6 / F8 PR E / F R1 / R2 / R4 SHE / FR1 / R2 / R4 SHE / FR1 / R2 / R4 GN .    
 
 
 You can do this  dplyr  like this library 
 
  df.A & lt; - read.table (text = "group id a / b / cf1a / b / cf5a / b / cf7a / b / cf6a / b / cf8e / fr1 E / FR2E / FR4 ", Header = T, Sep =" ") DF. B & lt; - Read.table (text = "Group PA / B / C LS A / B / C PR E / F / E / FM / FGN", Header = T, Sep = "") Library (DP) TMP & Lt; - df.A%.% Group_by (Group)%.% Merge (ID = Paste (id, collapse = "/")) (TMP, DFB)

Comments

Post a Comment

Popular posts from this blog

jsp - No mapping found for HTTP request with URI with annotation config Spring MVC and Jetty -

-
Image
I'm only using annotation configuration, the server starts, but when I use some pages error is displayed: Warning: no mapping found for HTTP request with URI [/WEB-INF/view/main.jsp] name 'org.springframework.web.servlet.DispatcherServlet -D7259e with DispatcherServlet in Controller mapping works fine, but no JSP page is full. I am using Jetty 9.2.0.M0 and Spring MVC 4.0.4 release. JetTyP Config: Private Static Last String CONTEXT_PATH = "/"; Private Static Last String MAPPING_URL = "/ *"; Private Zero Server (Int port) throws exceptions {server server = new server (port); Server.addLifeCycleListener (New LifeCycleListener ()); Server.setHandler (getServletContextHandler (getContext ())); Server.start (); Server.join (); } Private static ServletContextHandler getServletContextHandler (WebApplicationContext context) throws IOException {LOGGER.info ( "ServletContextHandler is ready"); CircleContaxHandler themeHandler = new circactont...
Read more

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

java - Ajax call to jsp and jsp redirecting to further jsp -

-
I am getting an Ajax call on a jsp page which in turn is redirecting based on the value of a flag variable JSP file. The AJAX call is something like this: $ Ajax ({url: 'uploadwebcamimage.jsp', type: "post", data: {encodeimg: dataUrl, OwnerId: document.Clickpictures.OwnerId.value, OwnerPhone: document.Clickpictures.OwnerPhone.value, mobilepass: document.Clickpictures. Mobilepass.value, emailpass: document.Clickpictures.emailpass.value, mypassword: document.Clickpictures.mypassword.value, mygroupuserid: document.Clickpictures.mygroupuserid.value}, error: work () {warning ('error');} success : Function (msg) {// warning ((msg)); if (msg) indexOf ("true")> = 0) {// how grouplist location.href = "site_index_groupadmin.jsp res1 =?" + to get the grouplist;} else {warning ("unsuccessful");}}}); And in jsp I have done something like this: & lt;% ArrayList & lt; String & gt; List = New Arrestist & lt; Stri...
Read more