Bumped by Community user

occurred May 15, 2023 at 3:09

Bumped by Community user

occurred Jan 13, 2023 at 23:06

Bumped by Community user

occurred Sep 15, 2022 at 16:08

Bumped by Community user

occurred Aug 13, 2022 at 18:05

Bumped by Community user

occurred Apr 10, 2022 at 21:04

Bumped by Community user

occurred Dec 10, 2021 at 2:06

Bumped by Community user

occurred Aug 9, 2021 at 9:03

Bumped by Community user

occurred Apr 3, 2021 at 3:07

Bumped by Community user

occurred Dec 2, 2020 at 23:06

Bumped by Community user

occurred Jul 25, 2020 at 14:02

added 2 characters in body; edited tags

Source Link

edited Jul 1, 2018 at 13:29

Jeff Schaller ♦

68.8k
35
122
264

I have two .csv files that I need to match based on column 1.

The two file structures look like this.

FILE1

gopAga1_00004004-RA,1122.825534,    -2.497919969,   0.411529843

gopAga1_00010932-RA,440.485381, 1.769511316,    0.312853434 

gopAga1_00007012-RA, 13.37565185,   -1.973108929,   0.380227982

etc...

FILE2

gopAga1_00004004-RA,    ENSACAP00000013845

gopAga1_00009937-RA,    ENSACAP00000000905

gopAga1_00010932-RA,    ENSACAP00000003279

gopAga1_00000875-RA,    ENSACAP00000000296

gopAga1_00010837-RA,    ENSACAP00000011919

gopAga1_00007012-RA,    ENSACAP00000012682

gopAga1_00017831-RA,    ENSACAP00000016147

gopAga1_00005588-RA,    ENSACAP00000011117

etc..

This is my current command that I am running using join:

This is formatted from what I have also read on the following threads here

join -1 1 -2 1 -t , -a 1 -e "NA" -o "2.2,1.1,1.2,1.3" <(sort -k 1 healthy_vs_unhealthy_de.csv) <(sort RBH.csv) > output.txt

However everytime, every time I run this prompt it only writes the first row to output.

Anyone know why my code is running like this and not actually merging the two files based on the GOP ID?

I have two .csv files that I need to match based on column 1.

The two file structures look like this.

FILE1

gopAga1_00004004-RA,1122.825534,    -2.497919969,   0.411529843

gopAga1_00010932-RA,440.485381, 1.769511316,    0.312853434 

gopAga1_00007012-RA, 13.37565185,   -1.973108929,   0.380227982

etc...

FILE2

gopAga1_00004004-RA,    ENSACAP00000013845

gopAga1_00009937-RA,    ENSACAP00000000905

gopAga1_00010932-RA,    ENSACAP00000003279

gopAga1_00000875-RA,    ENSACAP00000000296

gopAga1_00010837-RA,    ENSACAP00000011919

gopAga1_00007012-RA,    ENSACAP00000012682

gopAga1_00017831-RA,    ENSACAP00000016147

gopAga1_00005588-RA,    ENSACAP00000011117

etc..

This is my current command that I am running using join:

This is formatted from what I have also read on the following threads here

join -1 1 -2 1 -t , -a 1 -e "NA" -o "2.2,1.1,1.2,1.3" <(sort -k 1 healthy_vs_unhealthy_de.csv) <(sort RBH.csv) > output.txt

However everytime I run this prompt it only writes the first row to output.

Anyone know why my code is running like this and not actually merging the two files based on the GOP ID?

I have two .csv files that I need to match based on column 1.

The two file structures look like this.

FILE1

gopAga1_00004004-RA,1122.825534,    -2.497919969,   0.411529843

gopAga1_00010932-RA,440.485381, 1.769511316,    0.312853434 

gopAga1_00007012-RA, 13.37565185,   -1.973108929,   0.380227982

etc...

FILE2

gopAga1_00004004-RA,    ENSACAP00000013845

gopAga1_00009937-RA,    ENSACAP00000000905

gopAga1_00010932-RA,    ENSACAP00000003279

gopAga1_00000875-RA,    ENSACAP00000000296

gopAga1_00010837-RA,    ENSACAP00000011919

gopAga1_00007012-RA,    ENSACAP00000012682

gopAga1_00017831-RA,    ENSACAP00000016147

gopAga1_00005588-RA,    ENSACAP00000011117

etc..

This is my current command that I am running using join:

This is formatted from what I have also read on the following threads here

join -1 1 -2 1 -t , -a 1 -e "NA" -o "2.2,1.1,1.2,1.3" <(sort -k 1 healthy_vs_unhealthy_de.csv) <(sort RBH.csv) > output.txt

However, every time I run this prompt it only writes the first row to output.

Anyone know why my code is running like this and not actually merging the two files based on the GOP ID?

csv join

formatting

Source Link

edit approved Jun 26, 2018 at 20:01

Siva

9.3k
9
60
88

I have two .csv files that I need to match based on column 1.

The two file structures look like this.

FILE1

gopAga1_00004004-RA,1122.825534, -2.497919969, 0.411529843

gopAga1_00010932-RA,440.485381, 1.769511316, 0.312853434

gopAga1_00007012-RA, 13.37565185, -1.973108929, 0.380227982

etc...

gopAga1_00004004-RA,1122.825534,    -2.497919969,   0.411529843

gopAga1_00010932-RA,440.485381, 1.769511316,    0.312853434 

gopAga1_00007012-RA, 13.37565185,   -1.973108929,   0.380227982

etc...

FILE2

gopAga1_00004004-RA, ENSACAP00000013845

gopAga1_00009937-RA, ENSACAP00000000905

gopAga1_00010932-RA, ENSACAP00000003279

gopAga1_00000875-RA, ENSACAP00000000296

gopAga1_00010837-RA, ENSACAP00000011919

gopAga1_00007012-RA, ENSACAP00000012682

gopAga1_00017831-RA, ENSACAP00000016147

gopAga1_00005588-RA, ENSACAP00000011117

etc..

gopAga1_00004004-RA,    ENSACAP00000013845

gopAga1_00009937-RA,    ENSACAP00000000905

gopAga1_00010932-RA,    ENSACAP00000003279

gopAga1_00000875-RA,    ENSACAP00000000296

gopAga1_00010837-RA,    ENSACAP00000011919

gopAga1_00007012-RA,    ENSACAP00000012682

gopAga1_00017831-RA,    ENSACAP00000016147

gopAga1_00005588-RA,    ENSACAP00000011117

etc..

This is my current command that I am running using join:

This is formatted from what I havhave also read on the following threads here

join -1 1 -2 1 -t , -a 1 -e "NA" -o "2.2,1.1,1.2,1.3" <(sort -k 1 healthy_vs_unhealthy_de.csv) <(sort RBH.csv) > output.txt

However everytime I run this prompt it only writes the first row to output.

Anyone know why my code is running like this and not actually merging the two files based on the gopGOP ID?

I have two .csv files that I need to match based on column 1.

The two file structures look like this.

FILE1

gopAga1_00004004-RA,1122.825534, -2.497919969, 0.411529843

gopAga1_00010932-RA,440.485381, 1.769511316, 0.312853434

gopAga1_00007012-RA, 13.37565185, -1.973108929, 0.380227982

etc...

FILE2

gopAga1_00004004-RA, ENSACAP00000013845

gopAga1_00009937-RA, ENSACAP00000000905

gopAga1_00010932-RA, ENSACAP00000003279

gopAga1_00000875-RA, ENSACAP00000000296

gopAga1_00010837-RA, ENSACAP00000011919

gopAga1_00007012-RA, ENSACAP00000012682

gopAga1_00017831-RA, ENSACAP00000016147

gopAga1_00005588-RA, ENSACAP00000011117

etc..

This is my current command that I am running using join:

This is formatted from what I hav also read on the following threads here

join -1 1 -2 1 -t , -a 1 -e "NA" -o "2.2,1.1,1.2,1.3" <(sort -k 1 healthy_vs_unhealthy_de.csv) <(sort RBH.csv) > output.txt

However everytime I run this prompt it only writes the first row to output.

Anyone know why my code is running like this and not actually merging the two files based on the gop ID?

I have two .csv files that I need to match based on column 1.

The two file structures look like this.

FILE1

gopAga1_00004004-RA,1122.825534,    -2.497919969,   0.411529843

gopAga1_00010932-RA,440.485381, 1.769511316,    0.312853434 

gopAga1_00007012-RA, 13.37565185,   -1.973108929,   0.380227982

etc...

FILE2

gopAga1_00004004-RA,    ENSACAP00000013845

gopAga1_00009937-RA,    ENSACAP00000000905

gopAga1_00010932-RA,    ENSACAP00000003279

gopAga1_00000875-RA,    ENSACAP00000000296

gopAga1_00010837-RA,    ENSACAP00000011919

gopAga1_00007012-RA,    ENSACAP00000012682

gopAga1_00017831-RA,    ENSACAP00000016147

gopAga1_00005588-RA,    ENSACAP00000011117

etc..

This is my current command that I am running using join:

This is formatted from what I have also read on the following threads here

join -1 1 -2 1 -t , -a 1 -e "NA" -o "2.2,1.1,1.2,1.3" <(sort -k 1 healthy_vs_unhealthy_de.csv) <(sort RBH.csv) > output.txt

However everytime I run this prompt it only writes the first row to output.

Anyone know why my code is running like this and not actually merging the two files based on the GOP ID?

Source Link

asked Jun 26, 2018 at 19:54

cdxun

11
1
3

Join two csv files by matching columns, join command

I have two .csv files that I need to match based on column 1.

The two file structures look like this.

FILE1

gopAga1_00004004-RA,1122.825534, -2.497919969, 0.411529843

gopAga1_00010932-RA,440.485381, 1.769511316, 0.312853434

gopAga1_00007012-RA, 13.37565185, -1.973108929, 0.380227982

etc...

FILE2

gopAga1_00004004-RA, ENSACAP00000013845

gopAga1_00009937-RA, ENSACAP00000000905

gopAga1_00010932-RA, ENSACAP00000003279

gopAga1_00000875-RA, ENSACAP00000000296

gopAga1_00010837-RA, ENSACAP00000011919

gopAga1_00007012-RA, ENSACAP00000012682

gopAga1_00017831-RA, ENSACAP00000016147

gopAga1_00005588-RA, ENSACAP00000011117

etc..

This is my current command that I am running using join:

This is formatted from what I hav also read on the following threads here

join -1 1 -2 1 -t , -a 1 -e "NA" -o "2.2,1.1,1.2,1.3" <(sort -k 1 healthy_vs_unhealthy_de.csv) <(sort RBH.csv) > output.txt

However everytime I run this prompt it only writes the first row to output.

Anyone know why my code is running like this and not actually merging the two files based on the gop ID?

join

Stack Exchange Network

Return to Question

Join two csv files by matching columns, join command