ilyasahsan123

#!/usr/bin/env python
# encoding: utf-8

import tweepy #https://github.com/tweepy/tweepy
import csv

#Twitter API credentials
consumer_key = ""
consumer_secret = ""
access_key = ""

ilyasahsan123

import	request
import	json

# get top artist with last.fm api
# search on google last.fm api please

def	get_artist_name(URL):
	data	=	request.get(URL).text
	data	=	json.loads(data)
	top_artist	=	data["topartists"]["artist"][0]["name"]

ilyasahsan123

First Step

Requirement of laravel

• PHP >= 5.6.4
• OpenSSL PHP Extension
• PDO PHP Extension
• Mbstring PHP Extension
• Tokenizer PHP Extension
• XML PHP Extension

ilyasahsan123

# import algoritma logistic regression pada scikit learn
from sklearn.linear_model import LogisticRegression

# membuat variable classifier dengan algoritma logistic regression
clf = LogisticRegression()

# properti yang dibutuhkan pada aplikasi ini mempunyai sebuah array dengan value sebagai berikut
# index 0 : Jarak rumah dalam KM
# index 1 : Level bau ketek (1 - 10)
# index 2 : Jenis kendaraan denga properti 0 = angkot, 1 = motor, 2 = mobil

ilyasahsan123

mysqldump -u [user] -p[user_password] [nama_database] > [nama_file].sql

ilyasahsan123

import datetime
import os
import glob

now = datetime.datetime.now().strftime("%d-%m-%y")
date = now.split("-")
date_of_today = date[0]

db_user = "user"
db_user_password = "user_password"

ilyasahsan123

* 12 * * * cd [python script directory] && /usr/bin/python [python script directory]/backup_database.py

example:
* 12 * * * cd var/www/backup_db/ && /usr/bin/python var/www/backup_db/backup_database.py

ilyasahsan123

ilyasahsan123

select u.display_name
 ,s.amount
 ,u.location
from [bigquery-public-data:stackoverflow.users] u
join (
 select s.owner_user_id,
 count(*) amount
 from [bigquery-public-data:stackoverflow.posts_questions] s 
 group by s.owner_user_id
) s

ilyasahsan123

select tag
 ,count(*) number
from(
  select SPLIT(q.tags, '|') tag
  from [bigquery-public-data:stackoverflow.posts_questions] q
  join [bigquery-public-data:stackoverflow.users] u
  on q.owner_user_id = u.id
  where REGEXP_MATCH(u.location, '(?i)indonesia')
)
group by tag