Look for, find and delete/remove any empty column in a dataframe thanks to Python.
# Find the columns where each value is null
empty_cols = [col for col in df.columns if df[col].isnull().all()]
# Drop these columns from the dataframe
df.drop(empty_cols,
axis=1,
inplace=True)
empty_cols = [col for col in df.columns if df[col].isnull().all()]
df.drop(empty_cols, axis=1, inplace=True)
Learn more with the article FAQ
Blog post topic: No topic assigned
Written by Arthur Camberlein
With more than 10 years of experience in Marketing, Web Marketing and SEO, Arthur is specialized in Tech SEO and Data Analysis. He is currently working at Shopify, but all the views on this blog & website are his own.
Whether Parquet files are better than CSV files depends on the specific use case and requirements. And also to who you will send the file! When may .csv files be better than .parquet files? CSV files are a simple and widely used file format for storing tabular data. They are...
Difference between python --version and python -v. These two commands have completely different purposes: python --version Shows the Python interpreter's version number Example output: Python 3.9.7 This is the standard way to check which version of Python you're running It's equivalent to python -V (capital V) python -v Activates verbose...
For Jupyter Notebooks, the modern approach is: %pip install such as %pip install ShopifyAPI. %pip is a magic command The `%pip is called a "magic command" and it is preferred over `!pip` because it ensures the package is installed in the same Python environment that the kernel is using. But...
There are several solutions to extract the list of URLs from an XML sitemap directly in a Google Spreadsheet. Let's see that together, step-by-step.