| 3.9.13 | |
| 3.10.9 | |
| 3.8.10 |
| import os | |
| def Main(): | |
| x = os.getpid() | |
| print(f"{x=}") | |
| if __name__ == '__main__': | |
| Main() |
| 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__': |
| import locale | |
| import struct | |
| def __readLink(path): | |
| # http://stackoverflow.com/a/28952464/1119602 | |
| with open(path, 'rb') as stream: | |
| content = stream.read() | |
| # skip first 20 bytes (HeaderSize and LinkCLSID) | |
| # read the LinkFlags structure (4 bytes) | |
| lflags = struct.unpack('I', content[0x14:0x18])[0] |
| 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 |
| 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 |
| """ | |
| 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 |
| # 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: |
| # https://dimosr.github.io/kafka-docker/ | |
| version: '3.4' | |
| services: | |
| zookeeper: | |
| image: 'bitnami/zookeeper:3.8' | |
| ports: | |
| - '2181:2181' | |
| environment: |
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
