Skip to content

Instantly share code, notes, and snippets.

View jupihes's full-sized avatar

Hesam jupihes

View GitHub Profile

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

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.

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

Installing Python Packages

pip vs. conda

# Install a pip package in the current Jupyter kernel

MobaXterm session export data extraction

Below regex pattern help to extract needful information from Portable export of SSH sessions. Although not complete, can help data extraction from export file.

SSH_pattern = r'(?<Servername>[\w. ()]+)=#(?<Type>\d+)#0%(?<IP>[\w.]+)%(?<port>\d+)%%%([\w.-]+)%([\d-]+)%%%([\w.-]+)%%\d%([\w.-]+)%([\w

Local local linux repo

Modification in .repo files as

  • Comment mirrorlist line
  • Uncomment baseurl line and add local address

Check https://iranrepo.ir/

Question

image

Answer

import pandas as pd
@jupihes
jupihes / 4C.svg
Last active September 17, 2022 19:01
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
import datetime
import jdatetime
from pandas import to_datetime
#def p_to_g(d, splitter='/'):
# '''
# Persian date instance to Gregorian date instance converstion assuming input date format to be format="%Y/%m/%d"
# and provide output in same format.
# '''
# d = d.split(splitter)