Kdtyjb

In the world of The Matrix, what is "popping"?

How spaceships determine each other mass in space?

Why do phishing e-mails use faked e-mail addresses instead of the real one?

How will Occam's Razor principle work in Machine learning

Is there a frame of reference in which I was born before I was conceived?

Is there any relevance to Thor getting his hair cut other than comedic value?

What is brightness?

Misplaced tyre lever - alternatives?

Learning to quickly identify valid fingering for piano?

Rationale to prefer local variables over instance variables?

School performs periodic password audits. Is my password compromised?

Did Amazon pay $0 in taxes last year?

Why won't the strings command stop?

Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?

If nine coins are tossed, what is the probability that the number of heads is even?

“I had a flat in the centre of town, but I didn’t like living there, so …”

Was it really inappropriate to write a pull request for the company I interviewed with?

Number of folds to form a cube , using a square paper?

Why are special aircraft used for the carriers in the United States Navy?

Convert an array of objects to array of the objects' values

Ahoy, Ye Traveler!

The reduction of NAD+

What can I do if someone tampers with my SSH public key?

Where is the fallacy here?

pgfplots: by row, ranking particular column

pgfplots particular legendplotting two time series with boundschange font size of particular columnpgfplots linear regression for the wrong columnpgfplots: addplot3 color particular planesPlot data row-wise with pgfplotsCompute average value of a column with pgfplotsPGFPlots: pgfplotstableread with string columncreate header row and index column pgfplotstableColumn width and row height with pgfplotstable

0

1

I have a dataset in which rows indicate years and columns firms. For each year, I want to plot the 1st firm's rank against the others.

In the example below, 2013 is tied for 5th (if this is too tricky, I can break the rounding) as cells 1 to 8 (ex. cell 0) in the 2013 row are ordered: 0.67 (F3; 1st) > 0.54 (F6; 2nd) > 0.48 (F2; 3rd) > 0.46 (F8; 4th) > 0.38 (F1 & F4; joint 5th). In years 2014 onwards, F1 is ranked 6th.

documentclass{article}

usepackage{pgfplotstable}

usepackage{tikz}

usepackage{pgfplots}

pgfplotsset{compat=newest}



begin{document}



pgfplotstableread[col sep=tab,row sep=\,header=false]{

  % year    F1      F2      F3      F4      F5      F6      F7      F8

  2013  0.38    0.48    0.67    0.38    0.34    0.54    0.32    0.46 \

  2014  0.37    0.48    0.70    0.39    0.34    0.54    0.31    0.50 \

  2015  0.35    0.44    0.68    0.38    0.30    0.53    0.28    0.49 \

  2016  0.33    0.43    0.67    0.35    0.29    0.51    0.29    0.47 \

}datatable



begin{tikzpicture}

  begin{axis}[

    ylabel = rank, y dir = reverse,

  ]



  addplot table [x expr=coordindex, y expr= % what goes here? 

    ] {datatable};



  end{axis}

end{tikzpicture}



end{document}

A hand-coded version of the result I want is below.

pgfplots pgfplotstable

share|improve this question

edited 4 hours ago

Colin Rowat

asked yesterday

Colin RowatColin Rowat

475

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  For me it is still unclear how the resulting plot should look like. Could you add a sketch of the result. Then I think we will be able to provide a solution without multiple iterations because the question is "unclear".
  
  – Stefan Pinnow
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks Stefan. I've added a plot and tried to clarify the text.
  
  – Colin Rowat
  4 hours ago
  

  
  
  
  

add a comment | 

0

1

I have a dataset in which rows indicate years and columns firms. For each year, I want to plot the 1st firm's rank against the others.

In the example below, 2013 is tied for 5th (if this is too tricky, I can break the rounding) as cells 1 to 8 (ex. cell 0) in the 2013 row are ordered: 0.67 (F3; 1st) > 0.54 (F6; 2nd) > 0.48 (F2; 3rd) > 0.46 (F8; 4th) > 0.38 (F1 & F4; joint 5th). In years 2014 onwards, F1 is ranked 6th.

documentclass{article}

usepackage{pgfplotstable}

usepackage{tikz}

usepackage{pgfplots}

pgfplotsset{compat=newest}



begin{document}



pgfplotstableread[col sep=tab,row sep=\,header=false]{

  % year    F1      F2      F3      F4      F5      F6      F7      F8

  2013  0.38    0.48    0.67    0.38    0.34    0.54    0.32    0.46 \

  2014  0.37    0.48    0.70    0.39    0.34    0.54    0.31    0.50 \

  2015  0.35    0.44    0.68    0.38    0.30    0.53    0.28    0.49 \

  2016  0.33    0.43    0.67    0.35    0.29    0.51    0.29    0.47 \

}datatable



begin{tikzpicture}

  begin{axis}[

    ylabel = rank, y dir = reverse,

  ]



  addplot table [x expr=coordindex, y expr= % what goes here? 

    ] {datatable};



  end{axis}

end{tikzpicture}



end{document}

A hand-coded version of the result I want is below.

pgfplots pgfplotstable

share|improve this question

edited 4 hours ago

Colin Rowat

asked yesterday

Colin RowatColin Rowat

475

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  For me it is still unclear how the resulting plot should look like. Could you add a sketch of the result. Then I think we will be able to provide a solution without multiple iterations because the question is "unclear".
  
  – Stefan Pinnow
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks Stefan. I've added a plot and tried to clarify the text.
  
  – Colin Rowat
  4 hours ago
  

  
  
  
  

add a comment | 

I have a dataset in which rows indicate years and columns firms. For each year, I want to plot the 1st firm's rank against the others.

In the example below, 2013 is tied for 5th (if this is too tricky, I can break the rounding) as cells 1 to 8 (ex. cell 0) in the 2013 row are ordered: 0.67 (F3; 1st) > 0.54 (F6; 2nd) > 0.48 (F2; 3rd) > 0.46 (F8; 4th) > 0.38 (F1 & F4; joint 5th). In years 2014 onwards, F1 is ranked 6th.

documentclass{article}

usepackage{pgfplotstable}

usepackage{tikz}

usepackage{pgfplots}

pgfplotsset{compat=newest}



begin{document}



pgfplotstableread[col sep=tab,row sep=\,header=false]{

  % year    F1      F2      F3      F4      F5      F6      F7      F8

  2013  0.38    0.48    0.67    0.38    0.34    0.54    0.32    0.46 \

  2014  0.37    0.48    0.70    0.39    0.34    0.54    0.31    0.50 \

  2015  0.35    0.44    0.68    0.38    0.30    0.53    0.28    0.49 \

  2016  0.33    0.43    0.67    0.35    0.29    0.51    0.29    0.47 \

}datatable



begin{tikzpicture}

  begin{axis}[

    ylabel = rank, y dir = reverse,

  ]



  addplot table [x expr=coordindex, y expr= % what goes here? 

    ] {datatable};



  end{axis}

end{tikzpicture}



end{document}

A hand-coded version of the result I want is below.

pgfplots pgfplotstable

share|improve this question

edited 4 hours ago

Colin Rowat

asked yesterday

Colin RowatColin Rowat

475

documentclass{article}

usepackage{pgfplotstable}

usepackage{tikz}

usepackage{pgfplots}

pgfplotsset{compat=newest}



begin{document}



pgfplotstableread[col sep=tab,row sep=\,header=false]{

  % year    F1      F2      F3      F4      F5      F6      F7      F8

  2013  0.38    0.48    0.67    0.38    0.34    0.54    0.32    0.46 \

  2014  0.37    0.48    0.70    0.39    0.34    0.54    0.31    0.50 \

  2015  0.35    0.44    0.68    0.38    0.30    0.53    0.28    0.49 \

  2016  0.33    0.43    0.67    0.35    0.29    0.51    0.29    0.47 \

}datatable



begin{tikzpicture}

  begin{axis}[

    ylabel = rank, y dir = reverse,

  ]



  addplot table [x expr=coordindex, y expr= % what goes here? 

    ] {datatable};



  end{axis}

end{tikzpicture}



end{document}

share|improve this question

edited 4 hours ago

Colin Rowat

asked yesterday

Colin RowatColin Rowat

475

share|improve this question

edited 4 hours ago

Colin Rowat

asked yesterday

Colin RowatColin Rowat

475

asked yesterday

Colin RowatColin Rowat

475

asked yesterday

Colin RowatColin Rowat

475