Skip to content

Instantly share code, notes, and snippets.

💭
I want to make the world better

Maxim Uvarov maxim-uvarov

💭
I want to make the world better
Block or report user

Report or block maxim-uvarov

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View gist:5b416b48b193b118f6ed59409ee9ee85
┌──────────────────────────────────────────────────┐
│ +-+-+-+-+ +-+-+-+-+-+ +-+-+ +-+-+-+-+-+-+-+-+ │
│ |S|o|m|e| |d|a|n|c|e| |t|o| |r|e|m|e|m|b|e|r| │
│ +-+-+-+-+ +-+-+-+-+-+ +-+-+ +-+-+-+-+-+-+-+-+ │
│ +-+-+-+-+ +-+-+-+-+-+ +-+-+ +-+-+-+-+-+-+ │
│ |S|o|m|e| |d|a|n|c|e| |t|o| |f|o|r|g|e|t| │
│ +-+-+-+-+ +-+-+-+-+-+ +-+-+ +-+-+-+-+-+-+ │
│ │
└──────────────────────────────────────────────────┘
@maxim-uvarov
maxim-uvarov / gist:666fc5c10eaa68f556123f401cf452d6
Created Nov 19, 2018
извлечение плохоструктурированных данных
View gist:666fc5c10eaa68f556123f401cf452d6
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NYsxCoAgFECvIk461IXEu1QQLZ2gzYZmCQSj8gzv3ygd2h6P95zT7BROogyGreJNloUko0xVFyWz4iDxElWnCFUXMg+lJbJaQ2gh17/YXnv/AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Inserted Text Before Delimiter" = Table.AddColumn(#"Changed Type", "Товар", each Text.BeforeDelimiter([Column1], "("), type text),
#"Inserted Text Between Delimiters" = Table.AddColumn(#"Inserted Text Before Delimiter", "Количество", each Text.BetweenDelimiters([Column1], "(", "х"), type text),
#"Inserted Text Between Delimiters1" = Table.AddColumn(#"Inserted Text Between Delimiters", "Цена", each Text.BetweenDelimiters([Column1], "х", "-"), type text),
#"Inserted Text Between Delimiters2" = Table.AddColumn(#"Inserted Text Between Delimiters1", "Стоимость", each Text.BetweenDelimiters([Col
@maxim-uvarov
maxim-uvarov / PrettySourcesDateTableRu.m
Created Nov 14, 2018 — forked from DmitriyVlasov/PrettySourcesDateTableRu.m
функция в Power Query (язык M) создает таблицу с датами. Дополняет ее различными столбцами, включая данные о государственных выходных дня в РФ.
View PrettySourcesDateTableRu.m
// killerDateTableRu
// функция killerDateTableRu создает таблицу с датами. Дополняет ее различными полезными для Time Intelligence столбцами.
// В случае, если четвертый аргумент принимает Дни 1, то функция добавляет столбец с выходными.
// Оригинальная идея philbritton https://gist.github.com/philbritton/9677152
// пример: killerDateTableRu(#date(2017, 2, 1), #date(2017, 2, 4), "RU-ru", 1)
// Описание полей результирующей таблицы:
// ===================================================
// Date - дата
// Year - год
View bigquery.txt
SELECT
REGEXP_EXTRACT(hits.page.pagePath, r'([^?&#]*)')AS landing_Page,
trafficSource.medium AS medium,
trafficSource.source AS source,
device.deviceCategory AS deviceCategory,
hits.contentGroup.contentGroup1 as contentGroup1,
date,
(SELECT x.value FROM UNNEST(hits.customDimensions) x WHERE x.index = 4) as type,
COUNT(totals.bounces) AS Bounces,
Count(totals.transactions) as transactions,
@maxim-uvarov
maxim-uvarov / gist:7092a96912b97cd4366f68e390c363e8
Created Aug 24, 2018
mera описания студентов
View gist:7092a96912b97cd4366f68e390c363e8
p1 =
var FlagOneSelected = HASONEVALUE ( membersTable[Имя] )
var flagEndOfCourse = [_Урок Последний Выполненный Студентом] = [_уроков в курсе количество]
var name1 = membersTable[Имя чистое]
var sbj = membersTable[Subject]
var Beggining = name1 & " - cтудент курса " & sbj & " в NeedForData.ru."
@maxim-uvarov
maxim-uvarov / gist:f9f124ae2c2d059ba2b4f3777af75793
Created Mar 23, 2018
Bash help for google drive links converting
View gist:f9f124ae2c2d059ba2b4f3777af75793
Други, а помогите на bash скрипт написать, который бы из строчки
https://drive.google.com/file/d/16fiSG_ZRLilxKvPUDxbD4k1A2PCVEcdW/view?usp=drivesdk
Делал бы строчку:
https://drive.google.com/uc?export=download&id=16fiSG_ZRLilxKvPUDxbD4k1A2PCVEcdW
View gist:a1fe19115e5dc8974b6cbd883d6d1b50
### Keybase proof
I hereby claim:
* I am maxim-uvarov on github.
* I am maxim_uvarov (https://keybase.io/maxim_uvarov) on keybase.
* I have a public key ASDa1AAiTST5fj8TXGkHvzgV9BKGi_iSgEJRip8qxpN0rgo
To claim this, I am signing this object:
View layout3.json
{
"title": "select_input_source example (available since Karabiner-Elements 11.1.9)",
"rules": [
{
"description": "Change input source to U.S. by left_command, RussianWin by right_command. (available since Karabiner-Elements 11.1.9)",
"manipulators": [
{
"type": "basic",
"from": {
"key_code": "left_command",
View layout.json
{
"title": "select_input_source example (available since Karabiner-Elements 11.1.9)",
"rules": [
{
"description": "Change input source to U.S. by left_command, RussianWin by right_command. (available since Karabiner-Elements 11.1.9)",
"manipulators": [
{
"type": "basic",
"from": {
"key_code": "left_command",
View uri.parts.safe.pq
each try Uri.Parts(_) otherwise [Host=_]
You can’t perform that action at this time.