reuf’s gists

reuf / DDL.SQL

Last active August 19, 2024 18:05

InterviewQs - Highest grossing items by location, without primary keys

	CREATE TABLE item_prices_by_location (
	`city` VARCHAR(255),
	`item_name` VARCHAR(255),
	`price` INTEGER
	);

	INSERT INTO item_prices_by_location
	(`city`, `item_name`, `price`)
	VALUES
	('New_York', 'Coat', '115'),

reuf / python django git ignore file

Created March 25, 2022 04:51

reuf / AppendHeaders.py

Created February 18, 2022 00:41

	import tabula
	import pandas as pd
	import openpyxl
	import glob, os
	os.chdir("./")

	table1991Census = pd.read_csv('1991CensusNoKB.csv', header=None, encoding = "ISO-8859-1", sep='\t', low_memory=False)
	table1991Census.set_axis(["id", "address_id", "nas", "name", "national_id", "birthdate"], axis=1, inplace=True)
	table1991Census.to_csv('1991CensusNoKB.csv', index=False)

reuf / pandaPDFTableExtractExcelCleanup.py

Created February 17, 2022 20:01

	#import tabula
	#pages=[212,213]
	#df = tabula.read_pdf('Knjiga_mrtvih.pdf', pages = '212')[0]

	#df.columns = df.columns.str.replace('\r', ' ')
	#data = df.dropna()
	#print(df)
	#data.to_excel('data.xlsx')

	from tabula import read_pdf

reuf / ImportExcelIntoMySql.py

Created February 17, 2022 20:01

	from sqlalchemy import create_engine
	import pymysql
	import pandas as pd

	table = pd.read_excel("Sarajevo.xlsx")
	table2 = pd.read_excel("SrebrenicaAll.xlsx")

	tableName = "knjiga_mrtvih_sarajevo"
	tableName2 = "knjiga_mrtvih_srebrenica"

reuf / Block FB, Insta, Twitter, Youtube, News

Last active May 22, 2020 05:41

reuf / gist:3265b9d5918bf70ac4ef7293612e2db8

Last active October 23, 2019 02:34

Blokada satanizirane stoke + FB + Insta + YT

reuf / 73. Write a Python program to calculate midpoints of a line.

Created October 18, 2019 07:58

	# https://www.w3resource.com/python-exercises/python-basic-exercise-73.php
	import math
	x1, y1 = float(input("x1 = ")), float(input("y1 = "))
	x2, y2 = float(input("x2 = ")), float(input("y2 = "))
	p1 = [x1, y1]
	p2 = [x2, y2]

	mid = [(x1+x2)/2, (y1+y2)/2]

	print(mid)

Created October 18, 2019 07:19

	# https://www.w3resource.com/python-exercises/python-basic-exercises.php
	# 68. Write a Python program to calculate the sum of the digits in an integer.

	def sumOfDigsInInt(integer):
	sum = 0

	# Method 1:
	# counter = integer
	# while counter > 0:
	# if int(integer/10) > 0:

reuf / suppliers.txt

Created August 30, 2019 22:19 — forked from antoniocampos/suppliers.txt

DropShipping List

	Here are 30 different suppliers:
	1 – Oberlo verified suppliers or US
	2 – DX .com– A.K.A. Deal Extreme has been around for many years and has some amazing products that you could sell with great margins.
	3 – WholesaleCentral .com– One of the most comprehensive list of free drop shippers which you could find in virtually any niche. They are also free.
	4 – FragranceNet – This is a great source if you are looking to sell perfumes and fragrances.
	5 – Vitabase– A great source to supply vitamins for skin, health and beauty drop shipped products.
	6 – DressLink .com– A great source if you plan on selling dresses with amazing margins.
	7 – Tiny Deal – Similar to DX but you could find unique products as well.
	8 – Milanoo– A great supplier of wedding dresses, prom dresses.
	9 – Dino Direct – Another awesome source for electronic products and gadgets.

Muhamed Halilovic reuf