-
xgroup error in taxi and weather analysis
followed steps until calling xgroup to creat keyed table: grouped_taxi_dates, grouped_taxi_days,grouped_taxi_hours, which are running fine. but the below does not seem to return correct result: I guess the highlighted line is to count how many record/trips in each group of dates, so the print statement I added should not give 1? not sure where is the issue since I cannot access xgroup documentation… does anyone see the same issue here?
Thanks,
-
4 Replies
-
Add .reset_index() when you create the tables to unkey them, then the for loop will run as you expect. For example:
group_taxi_dates = kx.q.xgroup("pickup_date", taxi_tab).reset_index()-
This reply was modified 2 weeks, 6 days ago by rocuinneagain.
-
thanks!
-
This reply was modified 2 weeks, 6 days ago by
-
Thanks for flagging this @lestat-jin , Rian’s correction should work for you.
And I have now updated the notebook so new users will not run into this same issue, to pull the updated notebook you can navigate to Terminal and run git fetch and git pull to get the corrected notebook.
-
Thanks, noticed other places reset_index() is needed for xgroup in order to plot properly in addition to the one reported, code updated manually.
-
Log in to reply.