Reputation
3,302
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
7 32
Newest
 Yearling
Impact
~50k people reached

Apr
13
revised How can I join some values in rows to be value columns in a dataset/association
added 104 characters in body
Apr
13
comment How can I join some values in rows to be value columns in a dataset/association
@Kuba [a date+a period time], if just last day, then a date is enough
Apr
13
revised How can I join some values in rows to be value columns in a dataset/association
added 104 characters in body
Apr
13
comment How can I join some values in rows to be value columns in a dataset/association
@Xavier hi, GatherBy/GroupBy just split is a thread, and then should filter by dates, and to join the results. See my updated picture. consider the situation, there are 10 dates, and for a specific date, I just want the right part is the last date's data in the right part.
Apr
13
comment How can I join some values in rows to be value columns in a dataset/association
There is a problem to join two dataset into one, I've update my pic.
Apr
13
revised How can I join some values in rows to be value columns in a dataset/association
edited body
Apr
12
accepted How can I change some elements in dataset by related column and row
Apr
12
comment How can I change some elements in dataset by related column and row
Anyway, thanks, I find the answer, via WReach's answer.
Apr
12
comment How can I change some elements in dataset by related column and row
ha, I find it , thanks. dataset[All,<|#,"B"->If[#type=="row_5",#A,#B]|>&]
Apr
12
revised How can I change some elements in dataset by related column and row
edited title
Apr
12
comment How can I change some elements in dataset by related column and row
yes, that's the real purpose, better if could do a check, if value of [row_5,B] is 0, then replaced by [row_5,A]
Apr
12
comment How can I change some elements in dataset by related column and row
Hi, yes, but sometimes, it's not 0. but 1.15*10^100, and maybe not so easy to type it rightly, since the table is large,some rows are hidden, and If some 0.0 is not in type=row_5, I don't want it to be replaced.
Apr
12
revised How can I change some elements in dataset by related column and row
added 92 characters in body
Apr
12
revised How can I change some elements in dataset by related column and row
added 242 characters in body
Apr
12
comment How can I change some elements in dataset by related column and row
sorry, I changed the dataset and make the problem clearer
Apr
12
revised How can I change some elements in dataset by related column and row
added 350 characters in body
Apr
12
revised How can I join some values in rows to be value columns in a dataset/association
deleted 1 character in body
Apr
12
revised How can I change some elements in dataset by related column and row
added 58 characters in body
Apr
12
revised How can I join some values in rows to be value columns in a dataset/association
added 176 characters in body; edited tags
Apr
12
asked How can I join some values in rows to be value columns in a dataset/association