Zipping two dataframes in c# Deedle

Question

would anyone be able to provide me with a working example of dataframe zipping in C#? I am bit lost in the operation. Thanks!

Please go through [How do I ask a good question?](http://stackoverflow.com/help/how-to-ask) — Prudhvi, Apr 17 '15 at 16:47

score 0 · Answer 1 · answered Apr 25 '15 at 00:57

The frame.Zip operation is the same thing as zipAlign in the more documented F# API, so have a look at zipAlign in this section of the documentation.

Given a frame df1:

     A 
1 -> 1 
2 -> 2

And a frame df2:

     A 
2 -> 2 
3 -> 3

When you call df1.Zip(df2, (int a, int b) -> a + b), you get:

     A         
1 -> <missing> 
2 -> 4         
3 -> <missing>

That is, for cells where both frames contain a value, a + b is calculated. For all other cells, you get a missing value. Note that you need type annotations in the lambda function - this has to match the type of values in the frame (for not matching types, the function just returns the values from the first frame unchanged).

Is there a way to handle 1 -> this condition? – Manvinder Singh Jan 14 '21 at 07:27 — Manvinder Singh, Jan 14 '21 at 07:27

Zipping two dataframes in c# Deedle

1 Answers1