StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14616121
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-01-30T23:55:58.327
FavoriteCount
0
LastActivityDate
2013-01-31T00:12:23.490
LastEditDate
2013-01-31T00:12:23.490
LastEditorUserId
110026
OwnerUserId
110026
ParentId
14615355
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
The second of the following two little functions can get what you want done: <pre><code>def resample_up(t, x, r) : return x[np.argmax(r[:, None] <= t, axis=1)] def resample_down(t, x, r) : return x[::-1][np.argmax(r[:, None] >= t[::-1], axis=1)] >>> resample_up(t, x, r) array([10, 12, 13, 14]) >>> resample_down(t, x, r) array([10, 11, 12, 14]) </code></pre> If you find it hard to figure out what's going on, the following may help: <pre><code>>>> r[:, None] <= t array([[ True, True, True, True, True], [False, False, True, True, True], [False, False, False, True, True], [False, False, False, False, True]], dtype=bool) >>> r[:, None] >= t[::-1] array([[False, False, False, False, True], [False, False, False, True, True], [False, False, True, True, True], [ True, True, True, True, True]], dtype=bool) </code></pre> and then <code>np.argmax</code> is returning the index of the first occurrence of <code>True</code> in every row. EDIT IT is hard to get it shorter than a single line of code, but for large arrays performance will suffer, because the index finding never breaks out early of loops. So for very large arrays, scanning through the array with python loops may turn out to be faster. For smaller ones it does not: <pre><code>In [2]: %timeit resample_up(t, x, r) 100000 loops, best of 3: 7.32 us per loop In [3]: %timeit resample_down(t, x, r) 100000 loops, best of 3: 8.44 us per loop In [4]: %timeit resample(t, x, r) # modified version of the OP's taking also x 100000 loops, best of 3: 13.7 us per loop </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POIndices of resampled array in scipy
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJaime
UserOwnerUserId
1. USJaime
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POIndices of resampled array in scipy
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. CONice, it uses syntax I did not know for indexing arrays!
 singulars
 PostPostId
 PO
 UserUserId
 USAkiRoss

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.