hide a column from a data frame

Estimated reading time: 2 minutes

They say there is nowhere to hide, we disagree!
As an addition to How to add a column to a dataframe would you like to learn to go and hide it?! This video has several steps in it; following each one will give you a good introduction.

To start why you would like to hide a column?

• You may not want to reveal its output as it is sensitive information.
• The data in the column is not in the correct format, you will want to repurpose it, so it is the way you want it.
•  The column could be a calculated column. Hence it serves as an intermediary step before your data frame is output.

Finding the best way to hide unwanted data:

In this video, we introduce several concepts to help not show a column:

• Specify the actual columns you want to include in the data frame, by default doing this you are excluding the column or columns you don’t want to see.
•  We use drop, to explicitly tell the data frame not to show a particular column.
•  Also, we display a scenario whereby you have a calculated column but do not want to show its output, based on one of the reasons outlined above.
• Finally, the index of the column can appear in the output, so we have shown through set_index how to hide it from what is displayed.

This latest in the Python Dataframe series looks to build on the knowledge in the previous examples. We hope as you learn python online, it will increase your programming skills.

Thanks for watching and don’t forget to like and share through our social media buttons to the right of this page.

Data Analytics Ireland