Skip to content

Instantly share code, notes, and snippets.

View shenevol's full-sized avatar

yuting shenevol

0 followers · 1 following
View GitHub Profile
@shenevol
shenevol / clear_script.py
Created April 9, 2020 04:32
trip.com - dash - clear script
import csv,re
with open('wingOn.csv') as f:
with open('wingOn_result.csv', 'w', encoding='utf-8') as output:
reader = csv.DictReader(f)
writer = csv.writer(output)
#writer.writerow(['Date', 'Advertiser', 'Theme', 'Channel', 'Targeting_Type','Campaign', 'Google_Engine_Bid_Strategy', 'Advertiser_Bid_Strategy', 'Bidding_Activated', 'Bidding_Opt', 'Impr', 'Clicks', 'Cost(CNY)', 'RealOrd', 'Trans_Last','Trans','Realord_Rev','Revenue(CNY)','Trans_Last_Revenue'])
writer.writerow(['Date', 'Advertiser', 'Campaign', 'Google_Engine_Bid_Strategy', 'Advertiser_Bid_Strategy', 'Bidding_Activated', 'Bidding_Opt', 'Impr', 'Clicks', 'Cost(HKD)', 'Trans', 'Revenue(HKD)'])
for row in reader:
@shenevol
shenevol / compareWordList.js
Created September 5, 2018 16:03
compareWords
const fs = require('fs');
var file1 = 'test1.csv';
var file2 = 'test2.csv';
var originList = {};
var missWordsList = '';
fs.readFile(file1, 'utf8', (err, fileData)=>{
if(err){
@shenevol
shenevol / test2.csv
Created September 5, 2018 07:09
攜程 銀河 酒店 銀河 酒店 新宿 花 jr 九州 酒店 trip com 優惠 代碼 中 壢 飯店
@shenevol
shenevol / test1.csv
Created September 5, 2018 07:07
test
攜程 銀河 酒店 銀河 酒店 新宿 花 jr 九州 酒店 trip com 優惠 代碼
@shenevol
shenevol / compare.js
Created September 5, 2018 05:56
compare 2 csv files and find str does not exist in file 1
const fs = require('fs');
//const parse = require('csv-parse');
function compareCSV(arr1, arr2){
var missWords = [];
if(arr1.length === 0 || arr2.length === 0){
return console.log('empty compare file');
}
arr1.sort();
@shenevol
shenevol / detect.js
Created May 3, 2017 08:49
520. Detect Capital.
function detectCapitalUse(s){
let str = /^([A-Z]+)([a-z]*)$/g, str2 = /^([a-z]*)$/g;
if(str.test(s)){return true;}
if(str2.test(s)){return true;}
return false;
}
console.log(detectCapitalUse('FlaG'));
console.log(detectCapitalUse('USA'));
console.log(detectCapitalUse('Google'));
@shenevol
shenevol / KMPmapping.js
Created May 2, 2017 14:09
KMPmapping.js
function matching(arr1, arr2){
let x = 0, number = 0;
while(x < arr1.length){
if(arr1[x] === arr2[x]){
number = arr1[x].length;
}
}
return number;
}
@shenevol
shenevol / Pascal's Triangle.js
Created March 22, 2017 13:18
Pascal's Triangle
function pa(num){
if(num == 1){
return [1];
} else{
var prev = pa(num-1);
var result = [1];
var i = 0;
for(;i < prev.length -1 ;i++){
result.push(prev[i]+prev[i+1]);
}
@shenevol
shenevol / .html
Created March 21, 2017 23:56
UIControlBar
<html>
<head>
<title>test</title>
<style>
body {
display: flex;
justify-content: center;
align-items: center;
background-color: palegoldenrod;
font-family: sans-serif;
@shenevol
shenevol / index.js
Last active January 18, 2016 08:44
Teas and joys
var app = angular.module("app",[]);
angular.module('app').constant('AzureMobileServiceClient', {
API_URL : 'http://kiliomobileapi.azure-mobile.net/api/AuthorityManage/Departments',
API_KEY : 'HPTNIXeDbTlKwZnIgmwVBijYmJrLHF82',
});
app.controller("index",function($scope, $http){
var MockData_Department = {
"Deparments":