May 17

Covid-19 Experience

well, I’m survived Disclaimer This article is personal experience can not refer to anyone’s symptom. If you have contacted with Covid-19, please go see the doctor instead using this article as a behavioral example. Caught On the 2nd April 2022, my mother-in-law went out of town. The driver later found that he…

Covid 19

2 min read

Apr 27

Frequently use Pandas methods/functions

I have no counter-argument about why don’t we use something else beside import pandas as pd Import Data pd.read_csv(csvfile) and above that I mostly use file=r'c:\datasets\csvfile.csv' because I put ipynb in Git. pd.read_excel(excelfile) to work with excel file. pd.read_sql(query, connection_object) not frequently use today since Power BI or Tableau is more faster…

Pandas

2 min read

Apr 27

My perspective on POCO F4 GT

I’ve been touching tons of mobile phone to test and benchmark against the company standard and my deeds. Here is my perspective for heart-beating new mobile phone in early 2022 After tested tons of phone, I found myself suitable one, Samsung S21 5G replacing my swelled battery Xiaomi Black Shark…

Mobile Phone

4 min read

Apr 27

[365Gist] Force shut down GCP project — Shell

I am an OCD. Some times I created Google Cloud Product Projects for some purposes, later I found that quite disordered. And I really really need to delete unused projects but struggling with awaiting projects to be deleted or can not delete because I pair with firebase or something. Here’s how to force shut down. Step 1.) go to GCP console and activate cloud shell Step 2.) get your lien_name Step 3.) Goodbye roger.

Shell

1 min read

[365Gist] Force shut down GCP project — Shell

Here’s how to force shut down.

Step 1.) go to GCP console and activate cloud shell

Step 2.) get your lien_name

Step 3.) Goodbye roger.

As shown in Gist, you need 2 things, the project_id and lien_name which the project_id comes from dashboard page and the lien comes from code in line 2.

That’s it, my OCD is fulfilled.

Apr 26

[365Gist] easy auto refresh with condition by Selenium — Python

Naive way to buy PS5 from Sony Store Thailand. Sony announced that PS5 will be on sale on 22th Apr 11:00 (GMT+7) so that I tried many ways to beat the bots because last time just kept refreshing the page can’t even see the product shown on page. …

Selenium

1 min read

Apr 25

[365Gist] Repeating session via Cookies — Selenium (Python)

Using Selenium automation is cool, but struggling at login screen every run is not cool at all. We will login once and use that cookie until the session expired. Let’s go easy in Python. (can applied yo your fav language) The code working in this order: Step 1.) using Chrome…

Python

2 min read

Apr 21

[365Gist] select 2nd highest, again? — SQL

This SQL problem is quite popular among those who called themselves ‘beginner’ and ‘advance’ The approach is somewhat easy — SELECT someinteger FROM sometable ORDER BY someinteger DESC LIMIT 1 OFFSET 1; Here you go, the second highest value of ‘someinteger’ BUT..! What if it’s a trap!? Some table fools…

Sql

2 min read

[365Gist] select 2nd highest, again? — SQL

Apr 20

How FF gets massive hit in last 4 years, how I operate the high-performance team from scratch

this FF game ain’t Fin — Fan — y. It’s more likely well-known as PU-G copycat. Building a high-performance team requires effort from every-single-one in the team. We growth from 4 to 40 headcounts in 2 years of operation. We had been through chaos of miscommunications and misdirection. Therefore, with…

Management

6 min read

How FF gets massive hit in last 4 years, how I operate the high-performance team from scratch

Apr 20

[365Gist] always on top — SQL

Trying to sort something always on top and others are in ascending order as usual. I called this method, a custom sorting, using when you want to prioritize some sort of data. For an example, you are living in Thailand wanting to compare the population against others countries in Asia…

Sql

1 min read

Apr 9

Frustrating on Conda package update?

if you’re an OCD, like me, update packages is a-must even it demolished some past projects Even I mostly done my data analysis projects on VSCode but sometimes missing packages can ruin my day. For an example, I’m scrapping the website using BeautifulSoup4 as usual but this time I want lxml as a parser. so I go for soup = BeautifulSoup(html, 'lxml') it throws error, and I realize that I have to `pip install lxml` but for Conda (or Jupyter) the lxml is already there!

Conda

2 min read

Frustrating on Conda package update?

if you’re an OCD, like me, update packages is a-must even it demolished some past projects

Even I mostly done my data analysis projects on VSCode but sometimes missing packages can ruin my day. For an example, I’m scrapping the website using BeautifulSoup4 as usual but this time I want lxml as a parser.

so I go for

soup = BeautifulSoup(html, 'lxml')

it throws error, and I realize that I have to `pip install lxml`
but for Conda (or Jupyter) the lxml is already there!

Covid-19 Experience

Frequently use Pandas methods/functions

My perspective on POCO F4 GT

[365Gist] Force shut down GCP project — Shell

[365Gist] Force shut down GCP project — Shell

[365Gist] easy auto refresh with condition by Selenium — Python

[365Gist] Repeating session via Cookies — Selenium (Python)

[365Gist] select 2nd highest, again? — SQL

How FF gets massive hit in last 4 years, how I operate the high-performance team from scratch

[365Gist] always on top — SQL

Frustrating on Conda package update?

Frustrating on Conda package update?

Thongchan Thananate