Skip to content

Instantly share code, notes, and snippets.

View AgungPambudi's full-sized avatar
😃
Learning by doing

Agung Pambudi AgungPambudi

😃
Learning by doing
68 followers · 50 following
View GitHub Profile
@AgungPambudi
AgungPambudi / panduan-github
Last active August 8, 2022 14:02
Dokumen cara penggunaan Github Data Science Indonesia secara umum
# Panduan Penggunaan Git
## Mengunduh Repository
Unduh repository ke dalam komputer menggunakan perintah `git clone`. Url
repository dapat dilihat di dalam repository yang diinginkan.
```
git clone <url repository> <folder tujuan>
```
@AgungPambudi
AgungPambudi / MySQL Common Table Expression (CTE).sql
Created July 3, 2022 04:27
/*
file: MySQL Common Table Expression (CTE).sql
language: SQL
author: [email protected] Agung Pambudi
description: SQL Advanced Crypto
Enter your query below.
Please append a semicolon ";" at the end of the query
*/
@AgungPambudi
AgungPambudi / Python REST API.py
Last active July 3, 2022 04:14
"""
file: Football Competition Winner's Goals.py
language: python3
author: [email protected] Agung Pambudi
description: REST API: Football Competition Winner's Goals
"""
#!/bin/python3
#
# Complete the 'getWinnerTotalGoals' function below.
@AgungPambudi
AgungPambudi / automatically-create-requirements.txt-on-python
Last active July 21, 2022 19:21
Given the python source code directory is it possible to create requirements.txt automatically from the import section
$ pip3 freeze > requirements.txt # Python3
$ pip freeze > requirements.txt # Python2
# if you want to list only packages used inside a virtualenv use:
$ source <myvenvname>/bin/activate # or in Windows cd <myenvname>\Scripts\ then type activate.bat Enter
$ pip freeze -l > requirements.txt
# install packages using pip according to the requirements.txt file from a local directory
@AgungPambudi
AgungPambudi / python-data-processing-automation-upload-excel-to-firestore.py
Last active December 30, 2021 07:54
data migration scripts that migrates data from excel files to an actual Firestore Collections database
# pip install firebase-admin pandas xlrd==1.2.0
import firebase_admin
from firebase_admin import credentials
from firebase_admin import firestore
from xlrd import open_workbook
credential_info = credentials.Certificate("path/to/service_account.json")
firebase_admin.initialize_app(credential_info)
@AgungPambudi
AgungPambudi / create-table-dari-query-select.sql
Created September 8, 2021 07:01
#author : Agung Pambudi
#email : [email protected]
#version : 0.4
#
#
#==============================================================================
# _ _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_| ___ ___ _____
#| .'| . | | | | . | . | .'| | . | | | . | |_| _| . | |
#|__,|_ |___|_|_|_ | _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
@AgungPambudi
AgungPambudi / mysql-union-menggunakan-query-select.sql
Created September 8, 2021 06:52
#author : Agung Pambudi
#email : [email protected]
#version : 0.2
#
#
#==============================================================================
# _ _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_| ___ ___ _____
#| .'| . | | | | . | . | .'| | . | | | . | |_| _| . | |
#|__,|_ |___|_|_|_ | _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
@AgungPambudi
AgungPambudi / planogram-analysis-looping.php
Last active August 16, 2021 04:33
Simple logic with php loop
#author : Agung Pambudi
#email : [email protected]
#version : 0.2
#
#KyusuMart Planogram Analysis
#==============================================================================
# _ _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_| ___ ___ _____
#| .'| . | | | | . | . | .'| | . | | | . | |_| _| . | |
#|__,|_ |___|_|_|_ | _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
@AgungPambudi
AgungPambudi / planogram-analysis-mysql-subquery-with-alias-table-name.sql
Last active August 16, 2021 03:25
KyusuMart Planogram Analysis
#author : Agung Pambudi
#email : [email protected]
#version : 0.1
#
#KyusuMart Planogram Analysis
#==============================================================================
# _ _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_| ___ ___ _____
#| .'| . | | | | . | . | .'| | . | | | . | |_| _| . | |
#|__,|_ |___|_|_|_ | _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
@AgungPambudi
AgungPambudi / customer-tabulation-query-per-hour.sql
Last active August 10, 2021 06:57
#author : Agung Pambudi
#email : [email protected]
#version : 0.1
#==============================================================================
# _ _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_| ___ ___ _____
#| .'| . | | | | . | . | .'| | . | | | . | |_| _| . | |
#|__,|_ |___|_|_|_ | _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
# |___| |___|_|