blogs - aminboutarfi.com

Amin
Boutarfi

Search what you are looking for

python sort and sorted

<img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' class='avatar avatar-128 photo' height='128' width='128' decoding='async'/>

Difference between sort and sorted in python

January 27, 2023

SQL for Data Analyst

<img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' class='avatar avatar-128 photo' height='128' width='128' decoding='async'/>

Why Data Analysts Must Learn and Master SQL

January 15, 2023

Data engineer - SQL

<img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' class='avatar avatar-128 photo' height='128' width='128' decoding='async'/>

Why every data engineer must learn and master SQL

January 9, 2023

python scraping cryptocurrency using Playwright and save it to PostgreSQL

<img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' class='avatar avatar-128 photo' height='128' width='128' decoding='async'/>

How to Scrape Cryptocurrency Data Using Playwright and save it in PostgreSQL using Python

August 29, 2022

Python Excel Chart Automation - Openpyxl

<img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' class='avatar avatar-128 photo' height='128' width='128' decoding='async'/>

Excel charts Automation using Python and Openpyxl

August 21, 2022

<img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' data-srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' height='128' width='128' decoding='async' data-src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' class='avatar avatar-128 photo lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img alt='mr.amineboutarfi@gmail.com' src='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=128&d=mm&r=g' srcset='https://secure.gravatar.com/avatar/fe7d139cbfca9ae37d021b5e674be327?s=256&d=mm&r=g 2x' class='avatar avatar-128 photo' height='128' width='128' decoding='async'/>

Views vs Materialized Views in RDBMS – which one to use in your SQL code

August 20, 2022

Stay in Touch

Subscribe to my email list to get notified when anything interesting pops up! Don’t worry, I never scam.

© Amin Boutarfi 2023