Mdthbs

Unorthodox way of solving Einstein field equations

What is the best option to connect old computer to modern TV

How should I push back against my job assigning "homework"?

What happens if you do emergency landing on a US base in middle of the ocean?

How do I get a cleat that's stuck in a pedal, detached from the shoe, out?

Should we freeze the number of people coming in to the study for Kaplan-Meier test

Is American Express widely accepted in France?

Story about a toddler with god-like powers, dangerous tantrums

Asking bank to reduce APR instead of increasing credit limit

Pros and cons of writing a book review?

Get value of the passed argument to script importing variables from another script

Unconventional Opposites

Filling region bounded by multiple paths

Sucuri detects malware on wordpress but I can't find the malicious code

Rotated Position of Integers

Is there any Biblical Basis for 400 years of silence between Old and New Testament?

Why does my electric oven present the option of 40A and 50A breakers?

Does Peach's float negate shorthop knockback multipliers?

What if you don't bring your credit card or debit for incidentals?

Is there a rule that prohibits us from using 2 possessives in a row?

Working in the USA for living expenses only; allowed on VWP?

How did rebel fighters get past the Scarif shield?

Is it legal in the UK for politicians to lie to the public for political gain?

Opposite of "Squeaky wheel gets the grease"

How to convert a 3 column csv file into a table (0r Matrix)

How to use awk or sed to convert csv diffs into more readable formatConvert csv to HTML tableConvert from comma to Column (sed)Append a column to a csv file with value from another csv lookup tableHow to split Excel table into CSV files in .doc by Bold text?Convert a column in-place on CSVMerge two tables based on value in first columnConvert data from LDIF file to CSVSorting elements of a CSV fileHow to load a csv file to Redshift having double quotes and comma with in a column data?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

-1

I have an CSV input file format like this, with a nucleotide sequence in field 1, text in field 2, and an integer in field 4:

ATGC,CD3,56

ATGC,CD4,67

ATGC,IgD,126

ATGC,IgM,127

AGTC,CD3,67

AGTC,CD4,78

AGTC,IgD,102

AGTC,IgM,89

TCGA,CD3,334

TCGA,CD4,123

TCGA,IgD,456

TCGA,IgM,80

CGTA,CD3,54

CGTA,CD4,32

CGTA,IgD,82

CGTA,IgM,117

I opened this CSV file using Numbers in Mac it's display as 3 columns format, however, I want to convert it to the table(or Matrix) format (also a CSV file), making the first column, the nucleotide sequences, into a header, and want the result to also look like a table (or Matrix):

     ATGC  AGTC  TCGA  CGTA

CD3  56    67    334   54

CD4  67    78    123   32

IgD  126   102   456   82

IgM  127   89    80    117

How can I do this using Linux text formatting commands?

linux command-line csv text-formatting file-format

share|improve this question

edited 1 hour ago

Wendy Huang

asked 4 hours ago

Wendy HuangWendy Huang

62

New contributor

Wendy Huang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Where are the numbers in columns 2 and higher coming from? Your examples are too small; there's no AGAATAGTCTGATTCT allele example for CD3 in the first sample, for example, for us to extrapolate from. It's also customary here to provide text, not a screenshot, as you've got the text, and asking us to retype it to test with is counterproductive.
  
  – K7AAY
  3 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Also, please do not post pictures of text; instead please just post text.
  
  – DopeGhoti
  3 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @K7AAY I edited the answer, hope it's much clear now.
  
  – Wendy Huang
  1 hour ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @DopeGhoti I changed it to text
  
  – Wendy Huang
  1 hour ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @DudiBoy I edited the answer, hope it's more clear now
  
  – Wendy Huang
  1 hour ago
  

  
  
  
  

 | 
show 3 more comments

-1

I have an CSV input file format like this, with a nucleotide sequence in field 1, text in field 2, and an integer in field 4:

ATGC,CD3,56

ATGC,CD4,67

ATGC,IgD,126

ATGC,IgM,127

AGTC,CD3,67

AGTC,CD4,78

AGTC,IgD,102

AGTC,IgM,89

TCGA,CD3,334

TCGA,CD4,123

TCGA,IgD,456

TCGA,IgM,80

CGTA,CD3,54

CGTA,CD4,32

CGTA,IgD,82

CGTA,IgM,117

I opened this CSV file using Numbers in Mac it's display as 3 columns format, however, I want to convert it to the table(or Matrix) format (also a CSV file), making the first column, the nucleotide sequences, into a header, and want the result to also look like a table (or Matrix):

     ATGC  AGTC  TCGA  CGTA

CD3  56    67    334   54

CD4  67    78    123   32

IgD  126   102   456   82

IgM  127   89    80    117

How can I do this using Linux text formatting commands?

linux command-line csv text-formatting file-format

share|improve this question

edited 1 hour ago

Wendy Huang

asked 4 hours ago

Wendy HuangWendy Huang

62

New contributor

Wendy Huang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Where are the numbers in columns 2 and higher coming from? Your examples are too small; there's no AGAATAGTCTGATTCT allele example for CD3 in the first sample, for example, for us to extrapolate from. It's also customary here to provide text, not a screenshot, as you've got the text, and asking us to retype it to test with is counterproductive.
  
  – K7AAY
  3 hours ago
  
  
  

  
  
  
  


• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Also, please do not post pictures of text; instead please just post text.
  
  – DopeGhoti
  3 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @K7AAY I edited the answer, hope it's much clear now.
  
  – Wendy Huang
  1 hour ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @DopeGhoti I changed it to text
  
  – Wendy Huang
  1 hour ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @DudiBoy I edited the answer, hope it's more clear now
  
  – Wendy Huang
  1 hour ago
  

  
  
  
  

 | 
show 3 more comments

I have an CSV input file format like this, with a nucleotide sequence in field 1, text in field 2, and an integer in field 4:

ATGC,CD3,56

ATGC,CD4,67

ATGC,IgD,126

ATGC,IgM,127

AGTC,CD3,67

AGTC,CD4,78

AGTC,IgD,102

AGTC,IgM,89

TCGA,CD3,334

TCGA,CD4,123

TCGA,IgD,456

TCGA,IgM,80

CGTA,CD3,54

CGTA,CD4,32

CGTA,IgD,82

CGTA,IgM,117

I opened this CSV file using Numbers in Mac it's display as 3 columns format, however, I want to convert it to the table(or Matrix) format (also a CSV file), making the first column, the nucleotide sequences, into a header, and want the result to also look like a table (or Matrix):

     ATGC  AGTC  TCGA  CGTA

CD3  56    67    334   54

CD4  67    78    123   32

IgD  126   102   456   82

IgM  127   89    80    117

How can I do this using Linux text formatting commands?

linux command-line csv text-formatting file-format

share|improve this question

edited 1 hour ago

Wendy Huang

asked 4 hours ago

Wendy HuangWendy Huang

62

New contributor

Wendy Huang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

ATGC,CD3,56

ATGC,CD4,67

ATGC,IgD,126

ATGC,IgM,127

AGTC,CD3,67

AGTC,CD4,78

AGTC,IgD,102

AGTC,IgM,89

TCGA,CD3,334

TCGA,CD4,123

TCGA,IgD,456

TCGA,IgM,80

CGTA,CD3,54

CGTA,CD4,32

CGTA,IgD,82

CGTA,IgM,117

     ATGC  AGTC  TCGA  CGTA

CD3  56    67    334   54

CD4  67    78    123   32

IgD  126   102   456   82

IgM  127   89    80    117

share|improve this question

edited 1 hour ago

Wendy Huang

asked 4 hours ago

Wendy HuangWendy Huang

62

New contributor

Wendy Huang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 1 hour ago

Wendy Huang

asked 4 hours ago

Wendy HuangWendy Huang

62

New contributor

Wendy Huang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 hours ago

Wendy HuangWendy Huang

62

New contributor

Wendy Huang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 hours ago

Wendy HuangWendy Huang

62