Off topic:Count frequency of elements of one file in another file
0
0
Entering edit mode
4.9 years ago
xxxxxxxx ▴ 20

I have 2 file

file 1-

M1  M2
M1  M3
M3  M1
M3  M2
M4  M5
M7  M6

file 2-
P1  M1,M2,M5,M6
P2  M1,M2,M3,M5
P3  M4,M5,M7,M6

I want to count the frequency of the file 1 pair of column 1 and column 2 in file 2. Expected output-

M1  M2  2
M1  M3  1
M3  M1  1
M3  M2  1
M4  M5  1
M7  M6  1
R .csv • 564 views
ADD COMMENT
This thread is not open. No new answers may be added
Traffic: 2223 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6