 

Hello,

I’d like to do next, see if you could help me please:
I have a csv called “datuak” with a id called “calee_id” and a colunm called “poids”.

I have another csv called “datuak2” with the same id called “calee_id”, (although there are “calee_id” that are in “datuak” but not in “datuak2” and inverse), and a column called “kg_totales” in which the values are repeteated for each calee_id because are the sum of the colum “kg” for each row.

 

I show you the table “datuak” and “datuak2”:

 

Datuak (in the example the calee_id is the same, but there are a lot):

 

	poids

calee_id

maree_id

	10

1.27E+12

0.3013157

	20

1.27E+12

0.05726046

	20

1.27E+12

0.73631699

	25

1.27E+12

0.74492002

	3

1.27E+12

0.74492002

	27

1.27E+12

0.31776439

	43

1.27E+12

0.31776439

 

 

Datuak2:

 

           calee_id          maree_id      kg_totales  effectif

1     1.33959e+12 0.782835873      129.7             30  

2     1.33959e+12 0.782835873      129.7             40

3     1.33959e+12 0.782835873      129.7             10

4     1.33959e+12 0.782835873      129.7              5

5     1.33959e+12 0.782835873      129.7            1.7

6     1.33959e+12 0.782835873      129.7             20

7     1.33959e+12 0.782835873      129.7             20

8     1.33959e+12 0.782835873      129.7              1

9     1.33959e+12 0.782835873      129.7              2

I would like to identify in the csv “datuak2” the corresponding “calee_id” that also are in “datuak”, and create a new column in “datuak” with the values for each “calee_id” from “kg_totales”, and not repeat them.

So the final table would be “datuak”, with “calee_id”, “poids”, and the new column “kg_totales” with its corresponding value for each row.

 

Thank you very much, 

Nerea




 

--

 


	[[alternative HTML version deleted]]

