Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #10628 > unrolled thread

Re: Combining Two Lists

Started bychristopher arthur <chris.arthur1@gmail.com>
First post2012-06-25 08:03 +0000
Last post2012-06-25 08:03 +0000
Articles 1 — 1 participant

Back to article view | Back to comp.soft-sys.math.mathematica

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.


Contents

  Re: Combining Two Lists christopher arthur <chris.arthur1@gmail.com> - 2012-06-25 08:03 +0000

#10628 — Re: Combining Two Lists

Fromchristopher arthur <chris.arthur1@gmail.com>
Date2012-06-25 08:03 +0000
SubjectRe: Combining Two Lists
Message-ID<js95vq$f3l$1@smc.vnet.net>
look at DataManipulation

Hershel Lackey a écrit :
> Hi,
>
> I'm having a little difficulty in combining two lists.  These lists
> contain individual sets of data and then particular items within the
> set.  On one list the first column is the set the data is in and the
> second column is the particular item, and this is followed by 5
> properties of that item.  The second list starts the same, where the
> first column is the set the data is in and the second column is the
> item, but instead of having the properties listed out in individual
> columns the data set repeats itself listing the properties A,B,C,D,E,F
> all in the same column.   Below is a representative example of the two
> list.
>
> List 1
> Data Set	Item #	Property 1	Property 2	Property 3	Property 4	Property 5
> Q1	           1	            6.78	     25.61	   30.90	  48.90	 0.61
> Q1	           2	           12.57	    23.44	    5.22	  37.20	6.90
> Q2	           8	          18.78	  21.17	11.37  	2.54	        0.82
> Q2	           2	          34.81	14.87	15.04	36.78	4.54
> Q2	          10     	22.75	10.34	16.61	23.49	3.86
> Q3	           5	         47.15	7.23	        11.23	        40.01	3.53
> Q3	          8	        28.71	12.41	18.40	49.17	5.99
>
> List 2
>
> Data Set	Item#	Property 6	Measure %
> Q1	          1	              A	     0
> Q1	          1	              B	     5
> Q1	          1	              C	    15
> Q1	          1	              D	    80
> Q1	          1	              E	     0
> Q1	          1	              F	     0
> Q1	          2	              A	    80
> Q1	          2	              B	    10
> Q1	          2	              C	    10
> Q1	          2	              D	     0
> Q1	          2	              E	     0
> Q1	          2	              F	     0
> Q2	          2		      A	     5
> Q2	          2		      B	     5
> Q2	          2		      C	     0
> Q2	          2		      D	     15
> Q2	          2		      E	     0
> Q2		  2		      F	     0
> Q2		  8		      A	     0
> Q2		  8		      B	     0
> Q2		  8		      C	     65
> Q2		  8		      D	     15
> Q2		  8		      E	     0
> Q2		  8		      F	     20
> Q2		  10		      A	     5
> Q2		  10		      B	     5
> Q2		  10		      C	     85
> Q2		  10		      D	     0
> Q2		  10		      E	     0
> Q2		  10		      F	     0
> Q3		  5		      A	     8
> Q3		  5		      B	     0
> Q3		  5		      C	     85
> Q3		  5		      D	     7
> Q3		  5		      E	     0
> Q3		  5		      F	     0
> Q3		  8		      A	     12
> Q3		  8		     B		     3
> Q3		  8		     C		     60
> Q3		  8		     D		     15
> Q3		  8		     E		     0
> Q3		  8		     F		     0
>
> Note that the item # are repeat between different data sets, and data
> sets are different sizes.
>
> What I would like to do is combine the two lists matching the first
> two columns, to give groups like {Q1, 1, 6.7, 25.61, 30.90, 48.90,
> 0.61,{0,5,15,80,0,0}} for each individual.  I have used Cases to
> identify matching data sets and item numbers in the two lists.  It is
> then possible to append the two portions of the list to give part of
> the desired data set.  However, this was laborious in typing in every
> data set and then item # into Cases, and impractical for large data
> sets.  I'm sure there is a way to Map Cases or Select over the list,
> and append the appropriate data when data set and item # match, but I
> haven't figured out how to do that.  Also it seems possible to use an
> if then statement; that if the data set and item # match then append,
> else move through the list.  However, I haven't figured out how to
> code for this either.  I appreciate any help.
>
> Thanks,
>
> Hershel
>
>
>   
L

[toc] | [standalone]


Back to top | Article view | comp.soft-sys.math.mathematica


csiph-web