You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Query:
select agegroup, count(*) as total from dfs./Users/hammer/data.csv.gz GROUP BY age group
Output:
Converting the results of the above query to a pandas data frame using to_dataframe() produces the columns in the reverse order (total, agegroup). Switching the order in the query has no effect either as it still creates a dataframe with columns in reverse order (total, agegroup). Select queries without GROUP BY clause produces the correct order.