Pandas & Seaborn - A guide to handle & visualize data elegantly - Tryolabs Blog

Pandas offers some methods to get information of a data structure: info, index, columns, axes, where you can see the memory usage of the data, information about the axes such as the data types involved, and the number of not-null values. To make a boolean query, you need to pass the DataFrame a True/False Series whose index aligns with the DataFrame being queried's index. Merging is another way of combining DataFrames, but unlike concat it combines them looking for matching values in columns of said DataFrames (you can merge by index too). The main method to perform merging in Pandas is merge which lives both in the main pandas namespace and in the DataFrame namespace (unlike concat).