Jun-06-2018, 01:04 PM
The thred subject seems to oversimplify my query. I have a data set something like below
h t hu
1 3 5
2 4 5
3 10 3
4 2 5
5 10 6
7 9 3
8 10 3
9 11 2
10 11 1
1 3 5
2 4 5
3 10 3
4 2 5
5 10 6
6 1 2
7 9 3
8 10 3
9 11 2
and another file
1
2
3
4
5
6
7
8
9
10
the first colum in first file represent an index, say height and some values for each height(h), say temperature(t) and humidity(hu)
the observation is repeated at some definite interval like after 10 observations, height 1 is started again. The column in the second file represents all the possible heights where measurements can be made
the first file represents some actual observations with some missing values in this case height 6 for first time interval and for second time interval height 10
I want to compare the height at each time interval with the second file containing all the possible heights and find out which heights are missing. Also fill the missing height and corresponding values as blank or NaN values. My aim is to have all time blocks with equal number of rows
Can somebody provide any clues
thanks and regards
nuncio
h t hu
1 3 5
2 4 5
3 10 3
4 2 5
5 10 6
7 9 3
8 10 3
9 11 2
10 11 1
1 3 5
2 4 5
3 10 3
4 2 5
5 10 6
6 1 2
7 9 3
8 10 3
9 11 2
and another file
1
2
3
4
5
6
7
8
9
10
the first colum in first file represent an index, say height and some values for each height(h), say temperature(t) and humidity(hu)
the observation is repeated at some definite interval like after 10 observations, height 1 is started again. The column in the second file represents all the possible heights where measurements can be made
the first file represents some actual observations with some missing values in this case height 6 for first time interval and for second time interval height 10
I want to compare the height at each time interval with the second file containing all the possible heights and find out which heights are missing. Also fill the missing height and corresponding values as blank or NaN values. My aim is to have all time blocks with equal number of rows
Can somebody provide any clues
thanks and regards
nuncio