Skip to content

Instantly share code, notes, and snippets.

View MikyPo's full-sized avatar
💭
Data-analytic 🔋

MikyPo MikyPo

💭
Data-analytic 🔋
View GitHub Profile
@MikyPo
MikyPo / ya_cloud_func_api_yametrika_load.py
Created February 16, 2026 16:50
Ya-Cloud-Functions_API_YaMetrika_load
# Developed by MikyPo
# More code for DA here: https://dzen.ru/mikypo
# Импорт библиотек
import os
import requests
from datetime import datetime, timedelta, timezone
import time
import json
@MikyPo
MikyPo / brainvita_solution.py
Created February 8, 2026 13:41
Brainvita_solution
from collections import deque
import sys
sys.setrecursionlimit(10000)
class Solitaire:
def __init__(self):
# Определяем валидные позиции на поле 7x7
self.valid_positions = [
(0, 2), (0, 3), (0, 4),
(1, 2), (1, 3), (1, 4),
@MikyPo
MikyPo / api_yametrika_referer_trafic.py
Last active February 3, 2026 17:30
loading data from api yametrika referer trafic
# Developed by MikyPo
# More code for DA here: https://dzen.ru/mikypo
# === 1. 📥 Импорт библиотек
import locale
import os
import pandas as pd
import requests
from datetime import datetime, timedelta
from dotenv import load_dotenv
@MikyPo
MikyPo / sd-xl-base-1.0_in_GoogleColab.py
Created January 22, 2026 09:46
stable-diffusion-xl-base-1.0_in_GoogleColab
# Developed by MikyPo
# More code for DA here: https://dzen.ru/mikypo
# Установка необходимых библиотек
!pip install -q diffusers accelerate transformers pillow safetensors
# Импорт библиотеки torch
import torch
# Проверяем доступность CUDA
@MikyPo
MikyPo / rfm_analytics.py
Created November 14, 2025 11:19
rfm_analytics
# Developed by MikyPo
# More code for DA here: https://dzen.ru/mikypo
# Импорт библиотек
import pandas as pd
import numpy as np
import openpyxl
import plotly.express as px
import plotly.graph_objects as go
import warnings
@MikyPo
MikyPo / SQL_Syntax.py
Created October 27, 2025 12:13
Синтаксис SQL запросов в Jupyter Notebook
# Developed by MikyPo
# More code for DA here: https://dzen.ru/mikypo
# Импорт нужных библиотек
import duckdb
import pandas as pd
import numpy as np
# Для вывода подсвеченного кода SQL
from rich.console import Console
@MikyPo
MikyPo / conn_2_postgresql_railway_host.py
Created October 10, 2025 13:58
conn_2_postgresql_railway_host
# Developed by MikyPo
# More code for DA here: https://dzen.ru/mikypo
"""
Подключение к БД PostgreSQL на Railway hosting
"""
!pip install psycopg2-binary --quiet # Ставим psycopg, если ещё не установлено
# 1. Ставим нужные библиотеки
import os
@MikyPo
MikyPo / progessbar.py
Last active June 25, 2025 21:25
progress bar loading file
from openpyxl import load_workbook
from tqdm import tqdm
# Путь к файлу
filename = 'data.xlsx'
# Загружаем книгу
wb = load_workbook(filename, read_only=True)
# Возвращает активный (выбранный по умолчанию) лист Excel-файла,
@MikyPo
MikyPo / kandinsky_fusionbrain_api.py
Created June 12, 2025 09:41
kandinsky_fusionbrain_api
import base64
import json
import os
import requests
import time
from io import BytesIO
from dotenv import load_dotenv
from IPython.display import display, Image
@MikyPo
MikyPo / process_bar.py
Created May 18, 2025 10:01
view process bar
import pandas as pd
import numpy as np
from tqdm import tqdm
# 1. Генерация тестовой таблицы (1 000 000 строк)
def generate_test_data(rows=1000000):
data = {
'id': np.arange(1, rows+1),
'value': np.random.rand(rows) * 100,
'category': np.random.choice(['A', 'B', 'C', 'D'], size=rows)