Tips SEO & Data articles

SEO & Data blog by Arthur Camberlein

Tips articles by Arthur Camberlein. The SEO and Data blog of an North American SEO Specialist in Canada. If you want to know more about me, please go to the About section or the Projects one.

How to fetch & extract XML sitemaps URL in a Google Spreadsheet?

How to fetch & extract XML sitemaps URL in a Go...

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.

How to fetch & extract XML sitemaps URL in a Go...

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.

Interlinking, what is it, how does it works?

Interlinking, what is it, how does it works?

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...

Interlinking, what is it, how does it works?

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...

Find missing date data with Python

Find missing date data with Python

How to leverage Python to fill-out the missing dates on a file? Let's see that together!

Find missing date data with Python

How to leverage Python to fill-out the missing dates on a file? Let's see that together!

Find or extract the handle (last part of a URL) with a REGEX

Find or extract the handle (last part of a URL)...

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...

Find or extract the handle (last part of a URL)...

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...

Remove X characters from a cell in Excel

Remove X characters from a cell in Excel

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.

Remove X characters from a cell in Excel

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.

How to save a .parquet file in Python?

How to save a .parquet file in Python?

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....

How to save a .parquet file in Python?

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....