Skip to content

Instantly share code, notes, and snippets.

View kiang's full-sized avatar

kiang kiang

View GitHub Profile
31:07.258 --> 31:15.058
好 出席委員已經
31:15.248 --> 31:17.488
主法令人數 現在開會
31:17.488 --> 31:20.848
請議事人員宣讀上次會議議事錄
31:20.848 --> 31:25.888
@kiang
kiang / captions.srt
Last active May 17, 2023 00:03
2023-05-16《POP大國民》黃國昌 專訪 柯文哲 談 「柯文哲期許自己帶給臺灣什麼樣的選擇?」 字幕 - https://www.youtube.com/watch?v=jMsaHaqucB8
1
00:00:00,000 --> 00:00:01,600
POP大國民
2
00:00:01,600 --> 00:00:03,200
今天輪到你
3
00:00:04,784 --> 00:00:08,284
@kiang
kiang / YldaAc96HGY.srt
Created May 13, 2023 19:06
subtitles generated using whisper model for https://www.youtube.com/watch?v=YldaAc96HGY
1
00:00:00,000 --> 00:00:02,000
You
2
00:00:07,226 --> 00:00:14,266
Being a streamer is my calling because you know being suck at everything is
actually just really good content
3
This file has been truncated, but you can view the full file.
SPDXVersion: SPDX-2.2
DataLicense: CC0-1.0
SPDXID: SPDXRef-DOCUMENT
DocumentName: MODA
DocumentNamespace: http://spdx.org/spdxpackages/MODA-bf279ea0-4511-4509-8b45-07b63c204ad6
Creator: Tool: spdx-sbom-generator-v0.0.10
Created: 2023-05-12T08:05:42Z
##### Package representing the MODA
@kiang
kiang / extract.php
Last active April 9, 2023 15:13
to extract data as json
<?php
$mysqli = new mysqli("localhost", "root", "password", "member_db");
$targetPath = __DIR__ . '/member';
if (!file_exists($targetPath)) {
mkdir($targetPath, 0777, true);
}
// Check connection
if ($mysqli->connect_errno) {
@kiang
kiang / points.csv
Created March 25, 2023 05:44
points.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 25 columns, instead of 15. in line 4.
編號,銀行代號,分行代號,所屬銀行簡稱,裝設型態,裝設地點類別,裝設地點,所屬縣市,鄉鎮縣市別,地址,英文地址,區碼,聯絡電話,服務型態,符合輪椅使用,視障語音,符合輪椅使用、環境亦符合,視障語音、環境亦符合,備註,X,Y,FULL_ADDR,CODEBASE,CODE1,CODE2
2,004,0037,臺銀營業部,1,,營業部(一),台北市,中正區,重慶南路一段120號,"No.120, Sec. 1, Chongqing S. Rd., Zhongzheng Dist., Taipei City 10007, Taiwan (R.O.C.)",02,23493456,N,V,V,V,V,銀行營業時間開放,121.512912,25.041467,臺北市中正區建國里1鄰重慶南路一段120號,A6305-0124-00,A6305-07-009,A6305-07
3,004,0037,臺銀營業部,1,,營業部(一),台北市,中正區,重慶南路一段120號,"No.120, Sec. 1, Chongqing S. Rd., Zhongzheng Dist., Taipei City 10007, Taiwan (R.O.C.)",02,23493456,N,V,,V,,銀行營業時間開放,121.512912,25.041467,臺北市中正區建國里1鄰重慶南路一段120號,A6305-0124-00,A6305-07-009,A6305-07
4,004,0037,臺銀營業部,1,,營業部(一),台北市,中正區,重慶南路一段120號,"No.120, Sec. 1, Chongqing S. Rd., Zhongzheng Dist., Taipei City 10007, Taiwan (R.O.C.)",02,23493456,N,V,,V,,銀行營業時間開放,121.512912,25.041467,臺北市中正區建國里1鄰重慶南路一段120號,A6305-0124-00,A6305-07-009,A6305-07
5,004,0037,臺銀營業部,1,,營業部(一),台北市,中正區,重慶南路一段120號,"No.120, Sec. 1, Chongqing S. Rd., Zhongzheng Dist., Taipei City 10007, Taiwan (R.O.C.)",02,23493456,N,V
SPDXVersion: SPDX-2.2
DataLicense: CC0-1.0
SPDXID: SPDXRef-DOCUMENT
DocumentName: platform-1.0.0+no-version-set
DocumentNamespace: http://spdx.org/spdxpackages/platform-1.0.0+no-version-set-475ae069-76f7-4e89-8a63-cfe118096fe8
Creator: Tool: spdx-sbom-generator-v0.0.10
Created: 2023-03-07T06:40:38Z
##### Package representing the platform
@kiang
kiang / draft.csv
Last active November 29, 2022 05:45
draft
area cunli 2020 rate 2022 rate 2020 votes 2022 votes
東區 育賢里 15.37% 16.56% 105 100
東區 親仁里 18.56% 13.42% 129 142
東區 榮光里 14.37% 17.16% 103 23
東區 東門里 12.01% 9.91% 49 32
東區 成功里 12.19% 11.28% 54 38
東區 中正里 17.31% 11.46% 72 40
東區 錦華里 16.68% 14.6% 223 157
東區 文華里 15.96% 14.77% 537 386
東區 復中里 14.45% 15.2% 447 360
@kiang
kiang / game.php
Last active April 25, 2022 12:45
get random gift
<?php
$fh = fopen(__DIR__ . '/gift.csv', 'r');
fgetcsv($fh, 2048);
fgetcsv($fh, 2048);
$pool = [];
$count = 0;
while ($line = fgetcsv($fh, 2048)) {
if (!empty($line[0])) {
$pool[$line[0]] = $line[1];
$count += $line[1];
@kiang
kiang / zones.csv
Created January 25, 2022 09:28
zones 2022
city zone areas name party
連江縣 09007-01 南竿鄉
連江縣 09007-02 北竿鄉
連江縣 09007-03 莒光鄉
連江縣 09007-04 東引鄉
金門縣 09020-01 金城鎮/金寧鄉/烏坵鄉
金門縣 09020-02 金沙鎮/金湖鎮
金門縣 09020-03 烈嶼鄉
宜蘭縣 10002-01 宜蘭市
宜蘭縣 10002-02 頭城鎮