Skip to content

Instantly share code, notes, and snippets.

View jupihes's full-sized avatar

Hesam jupihes

View GitHub Profile

4G CELL ID logic

ECI = eNodeBID * $$2^{28-22}$$ + CellID

5G CELL ID logic

  • NCI(NR Cell Identity)gNB ID + CI
    • Length: 36bit
  • Range: 0 to 68719476735

Question from deepseek

Is it possible to use polars to connect with trino and write data with more speed? provide me detailed explanation, comparison, python code to do so and proper URL links to read more on this.

Answer

Yes, you can use Polars to connect with Trino for efficient data writing. Below is a detailed explanation, performance comparison, Python code, and resources for optimization.

to get repetitive exact pattern

regex_pattern = r'MKT_WHITELIST_POOL_\d{8}_([^_]+)(?:_\1)?(?:_(?:part|Part|pART|PART|)\d{1})\.csv'

sample_list = [
MKT_WHITELIST_POOL_20250723_PO4189OLG_1.csv
MKT_WHITELIST_POOL_20250723_PO4189OLG_PO4189OLG_1.csv
MKT_WHITELIST_POOL_20250723_PO4189OLG_PO4189OLG_Part1.csv