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 / sampling_api_yametrica.py
Created April 28, 2026 13:29
sampling in api yametrica
import os
import json
import time
import requests
import pandas as pd
from datetime import datetime, timedelta
from dotenv import load_dotenv
from io import StringIO
# Настройки
@MikyPo
MikyPo / file_upload_stat.py
Created April 27, 2026 16:33
File upload statistics in YaMetrics
# Импорт и инициализация
import locale
import os
import pandas as pd
import plotly.express as px
import plotly.graph_objects as go
import requests
import time
from requests.exceptions import RequestException, Timeout, ConnectionError
@MikyPo
MikyPo / sound_gen.py
Last active April 21, 2026 11:35
sound_gen
# Установка библиотек
!pip install -q edge-tts librosa soundfile numpy
import asyncio
import edge_tts
import librosa
import soundfile as sf
from IPython.display import Audio, display
import os
@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