Skip to content

Instantly share code, notes, and snippets.

View Zidcov's full-sized avatar

mr_zidcov Zidcov

1 follower · 13 following
View GitHub Profile
@Zidcov
Zidcov / Rename files' name.ps
Created January 1, 2024 16:12
Get-ChildItem -Path 'C:\Your\Directory\Here\' -Filter '*old*' | Rename-Item -NewName { $_.name -replace 'old','new' }
@Zidcov
Zidcov / CalendarGenerator.m
Created June 13, 2022 20:13 — forked from aaronsteers/CalendarGenerator.m
Power BI Calendar Function
# Step 1: Create a CalendarGenerator() function and paste the contents below into the Advanced Editor
let CreateDateTable = (StartDate as date, EndDate as date, optional Culture as nullable text) as table =>
let
DayCount = Duration.Days(Duration.From(EndDate - StartDate)),
Source = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),
TableFromList = Table.FromList(Source, Splitter.SplitByNothing()),
ChangedType = Table.TransformColumnTypes(TableFromList,{{"Column1", type date}}),
RenamedColumns = Table.RenameColumns(ChangedType,{{"Column1", "Date"}}),
InsertYear = Table.AddColumn(RenamedColumns, "Year", each Date.Year([Date])),
InsertQuarter = Table.AddColumn(InsertYear, "Quarter Number", each Date.QuarterOfYear([Date])),
@Zidcov
Zidcov / dbt.sh
Created April 9, 2022 12:45 — forked from kzzzr/dbt.sh
DE - DWH - Data Build Tool
# install dbt: https://docs.getdbt.com/dbt-cli/installation
pip install dbt==0.19.0
# clone repo
git clone https://github.com/dbt-labs/jaffle_shop
# create ~/.dbt/profiles.yml
# ensure profile setup
dbt debug
@Zidcov
Zidcov / assignment.md
Created April 8, 2022 18:36 — forked from kzzzr/assignment.md
Data Vault 2.0 + Greenplum + dbtVault assignment
@Zidcov
Zidcov / _assignment.md
Created April 1, 2022 20:04 — forked from kzzzr/_assignment.md
Analytics Engineer – dbt + Clickhouse Assignment
@Zidcov
Zidcov / ex_regex.py
Last active May 17, 2021 12:37
reqexp on python regular expressions
'''
https://habr.com/ru/post/349860/
Функция Её смысл
re.search(pattern, string) Найти в строке string первую строчку, подходящую под шаблон pattern;
re.fullmatch(pattern, string) Проверить, подходит ли строка string под шаблон pattern;
re.split(pattern, string, maxsplit=0) Аналог str.split(), только разделение происходит по подстрокам, подходящим под шаблон pattern;
re.findall(pattern, string) Найти в строке string все непересекающиеся шаблоны pattern;
re.finditer(pattern, string) Итератор всем непересекающимся шаблонам pattern в строке string (выдаются match-объекты);
re.sub(pattern, repl, string, count=0) Заменить в строке string все непересекающиеся шаблоны pattern на repl;
@Zidcov
Zidcov / transform xls xlsb files to csv.py
Created April 24, 2021 16:44
transform xls xlsb files to csv
def transform_xls_to_csv(path, dir_src, dir_res, replace=False):
'''
transform xls xlsb files to csv
:param path: of file
:param dir_src: directory of sourth file
:param dir_res: directory to save new file
:param replace: replace file if it exists
:return: nothing
'''
@Zidcov
Zidcov / Random sorting in T-SQL query
Created November 11, 2020 06:29
select *
from tab
order by NewID()
@Zidcov
Zidcov / PyLearnPJ_.idea_.gitignore
Created October 2, 2020 10:52
python with db mssql connect and CRUD
# Default ignored files
/shelf/
/workspace.xml
@Zidcov
Zidcov / gist:2608f5abc43e0ace8550f36b8a11bb36
Created April 26, 2020 18:21 — forked from simplesasha/gist:73005e8e08065d8c360dba09dc86626b
Интеграция Python 3 в Sublime Text 3 (простая и интерактивная консоль REPL)
1. Открываем Sublime Text -> Tools -> Build System -> New Build System
2. Вставляем в открывшийся файл следующие строки, чтобы получилось вот так:
{
"cmd": ["python3", "-i", "-u", "$file"],
"file_regex": "^[ ]File \"(...?)\", line ([0-9]*)",
"selector": "source.python"
}
3. Сохраняем файл с названием python3.sublime-build и не меняем путь предложенный редактором