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...
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.
Through the years, doing SEO work and hanging out on the Internet I became quite Internal Linking Savvy -- I am far from perfect for sure, but I can share a bit of my knowledge with you!
How to leverage Python to fill-out the missing dates on a file? Let's see that together!
This is the REGEX: [^\/]+$ you would like to use to extract the last part of a URL also known as the handle I often use this to compare URLs that are localized and end with the same handle.
Sometimes, when you're reading data in a spreadsheet like Microsoft's Excel, it's simpler to put a formula directly into the spreadsheet than to go to R, Python or any other solution.
To save a .parquet file with Python, you can use the pandas library, which provides a convenient way to read and write data in a variety of formats, including Parquet. Let me share with you an example: ```Python import pandas as pd create a sample DataFrame data = {'name': ['Alice',...
Could the rel=noopener and rel=noreferrer attributes improve both your security and your SEO?
div> I was recently introduced to .parquet extension files. Let me share with you what I learned! Parquet files are popular for storing and processing large datasets in big data environments. Introduction: a few words about the .parquet Parquet file is a columnar storage file format that is commonly used...
Always wanted to quickly extract links on 1 page, from your browser, without using too many tools? This is a quick tip that I "labelled" as SEO because I use it on a regular basis to verify and get the anchor text How to achieve that? The whole process is the following:...
Following my article about parquet files, I thought I could give you some examples of when you might want to prefer .csv files and when you might want to use .parquet. When could we use CSV files? Storing small to medium-sized datasets that can be easily opened and read in...
Did you know about the 'translate' attribute? You should! Let's see together the best way to use it!
Did you know that you can use your Terminal to ping a web address? How to ping a URL or an address? It is as simple as ping {www.domain.tld} for example you could try with google.com ping www.google.com In my case I am using a Mac, on my Terminal &...
Wordpress is well used and versed with SEO, blogs & website. But how to bulk replace links on this CMS?
In this article I am focusing on Wordpress, but you'll see that of these tips could be reused for other platforms.
Let's keep it simple: you have to open several URL at once and you are wondering how to do that: let's find out together!
This import will work if you are using any version of Python (meaning Python 2 or Python 3). How to import a library To import a library, you will have to use import + {the name of your library}. So you could do this to import libraries one by one:...
If you like and enjoy using Notebook for Python (Google Colab, Jupyter, ...), you will be glad that there is a tip that could help you save some time to import files from your computer (or the one from the user of your app/scrip). 2 lines to create a prompt...
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) Find the columns where each value is null...