Here you’ll see the advanced techniques like Query, Group by aggregation, Pivot Table, Melt, Concat, Append, Merge (Joins) etc. 1. Data Query: There are multiple scenarios and ways to query the data. Let’s assume the below data frame we are using for query. a. Select a column from df.