Skip to content

Instantly share code, notes, and snippets.

View maxcraftsman's full-sized avatar
🎯
Focusing

Maxim Tatarinov maxcraftsman

🎯
Focusing
View GitHub Profile
$APPLICATION->SetTitle("Ваш титл");
<style>
.catalog-list {
font-family: Arial;
float: left;
width: 33%;
list-style: none;
padding: 0;
margin: 20px 0 35px;
padding-left: 65px;
position: relative;
@maxcraftsman
maxcraftsman / script.py
Created July 7, 2020 11:46
Example of date column replace by function and change depending of the conditions [dirty]
import csv
import pandas as pd
import shutil
import pymysql
import sys
import re
from urllib.request import urlopen
from bs4 import BeautifulSoup
import sqlalchemy as sa
import pytz
@maxcraftsman
maxcraftsman / pd_to_sql.py
Last active July 7, 2020 12:07
Save pandas to sqlite [dirty]
import pandas as pd
import sqlalchemy as sa
e = sa.create_engine(r'sqlite:////path/to/file/database.db', echo=True) # LINUX
e = sa.create_engine(r'sqlite:///C:\\path\\to\\database.db', echo=True) # WINDOWS
df.to_sql("deskykt", e, if_exists="append", index=False)
@maxcraftsman
maxcraftsman / dategen.py
Created July 20, 2020 04:54
Date array generator
from datetime import date, datetime, timedelta
from calendar import monthrange
import pytz
dateRange = []
curTime = datetime.now()
def generateRange(start,end):
for y in range(start,end):
for m in range(1,13):
@maxcraftsman
maxcraftsman / date_gen.py
Last active January 25, 2025 15:13
Python cookbook
from datetime import date, datetime, timedelta
from calendar import monthrange
import pytz
dateRange = []
curTime = datetime.now()
def generateRange(start,end):
for y in range(start,end):
for m in range(1,13):
@maxcraftsman
maxcraftsman / tools.py
Last active March 28, 2021 00:28
Usefull tools
#loger
with open("/pavuki/doska/files/desk.log", "a", encoding='utf-8') as d:
d.write("Was runned at " + timenow.strftime("%d.%m.%Y %H:%M:%S"))
d.write('\n')
#generate array of dates
def generateRange(start,end):
global dateRange
dateRange = []