This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def read_timeout_handler(func, url, timeout, retries=None, params={}, **kw): | |
"Retries on read timeout" | |
if not hasattr(timeout, '__iter__'): | |
timeout = [timeout] * (retries or 1) | |
elif retries is not None: | |
raise ValueError("retries specified along with list of timeouts") | |
for retry, tm in enumerate(timeout): | |
try: | |
r = None # init | |
r = func(url, params=params, timeout=tm, **kw) |
Scenario (general):
1.1 Start code-server:
WORKON_HOME=~ code-server --cert --cert-host 172.30.15.137 --disable-telemetry --disable-update-check ~/_railcars
2.1 Open https://172.30.15.137:8080 in Google Chrome
3.1 Open Untitled.ipynb
, run three cells: import pandas, create DataFrame, sum dataframe values
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# https://dimosr.github.io/kafka-docker/ | |
version: '3.4' | |
services: | |
zookeeper: | |
image: 'bitnami/zookeeper:3.8' | |
ports: | |
- '2181:2181' | |
environment: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# r = read_timeout_handler(self.session.get, self.url_card, params=params, timeout=[10, 20, 30]) | |
def read_timeout_handler(func, url, timeout, retries=None, params={}, **kw): | |
"Retries on read timeout" | |
if not hasattr(timeout, '__iter__'): | |
timeout = [timeout] * (retries or 1) | |
elif retries is not None: | |
raise ValueError("retries specified along with list of timeouts") | |
for retry, tm in enumerate(timeout): | |
try: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
""" | |
https://stackoverflow.com/questions/68708477/repartition-large-parquet-dataset-by-ranges-of-values | |
""" | |
import pyarrow as pa | |
import pyarrow.dataset as ds | |
import pyarrow.compute as pc | |
import pyarrow.parquet as pq | |
from pathlib import Path |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub compare() | |
Dim sh1 As Worksheet, sh2 As Worksheet | |
Set wb1 = ThisWorkbook | |
Set wb2 = Workbooks("Map B00 XP__20210617_.XLSX") | |
For Each sh1 In wb1.Worksheets | |
Set sh2 = wb2.Worksheets(sh1.Name) | |
If sh1.UsedRange.Address <> sh2.UsedRange.Address Then | |
Debug.Print sh1.Name | |
Else | |
For Each c In sh1.UsedRange |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub tableSplitWithHeaders() | |
'https://stackoverflow.com/questions/8668311/current-row-in-vba-word | |
'https://www.tek-tips.com/viewthread.cfm?qid=1610014 | |
'https://stackoverflow.com/questions/37999841/how-can-i-determine-the-page-number-of-a-table-in-ms-word-macro | |
'https://learn.microsoft.com/en-us/office/vba/api/word.selection.insertbreak | |
Const TITLE_CONTINUE As String = "Продолжение таблицы" | |
Const TITLE_END As String = "Окончание таблицы" | |
Dim t As Table, t2 As Table, r As row |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import typer | |
def main( | |
hello: int = typer.Option(None), | |
there: int = typer.Option(None), | |
infinite: bool = typer.Option(False), | |
) -> None: | |
print(hello, there, infinite) | |
if __name__=='__main__': |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import os | |
def Main(): | |
x = os.getpid() | |
print(f"{x=}") | |
if __name__ == '__main__': | |
Main() |