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!
Saviez-vous que vous pouvez utiliser votre terminal pour envoyer une requête ping à une adresse Web ? Comment pinger une URL ou une adresse ? C'est aussi simple que ping {www.domain.tld} par exemple, vous pouvez essayer avec google.com ping www.google.com Dans mon cas j'utilise un Mac, sur mon Terminal & pour...
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:...
Si vous aimez les Notebook (comme Google Colab ou Jupyter Notebook), vous allez aimer cette astuce pour importer un ou plusieurs fichiers grâce à une fonction. Une fonction, qui crée un bon moyen d'importer les fichiers Vous trouverez ci-dessous la fameuse fonction et ensuite, vous n'aurez plus qu'a cliquer sur...
Rechercher et supprimer des colonnes vides dans le dataframe grâce/via Pandas en Python. # Find the columns where each value is null cols_vides = [col for col in df.columns if df[col].isnull().all()] # Drop these columns from the dataframe df.drop(cols_vides, axis=1, inplace=True) Trouver les columns avec des valeurs 'null' cols_vides =...