apsvvfb的专栏

https://www.theinformationlab.co.uk/2015/06/16/showing-a-nested-top-n-with-other-in-tableau/Showing a Nested Top N with “Other” in TableauOne of my favourite parts of my job as a Tableau Consultant is receiving questions via our support desk which get the

logintabcmd login -s https://online.tableau.com -t agooptest -u ${EMAIL} -p ${PW}publishtabcmd publish "${DIR}/${NAME}.twb" -o --parent-project-path 06_test/${PROJECT} --db-username ${DB_USER} --db-password ${DB_PW} --save-db-password --tabbed

import slackwebslack = slackweb.Slack( url="??????")# 方法1attachments = []attachment = { "pretext": "Email Validation failed", "title": "Email address:", "text": "apsvvfb",}attachments.append(attachment)# 方法2attachments = [ {.

update test1 t1set itemname=t2.itemnamefrom test2 t2where t2.itemcode=t1.itemcode;update test1set col2=test2.col2from test2 join test1 caton test2.col1=cat.col1;

所得税+住民税的计算方法????????中文（所得税）五张图教你看懂日本“个人所得税”所得金额=税前收入 - 给与所得控除课税所得=所得金额 - 所得控除所得控除: 抚养38*2，社会保险，寄付金，基础控除38寄附金：捐赠额-2000　????网址ふるさと納税在计算所得税的时候是属于所得控除的“寄除金”部分的。　????网址平成21年度から市民税・県民税の寄附金控除が所得控除から税額控除に変更になりまし...

import psycopg2hostname=xxxxxpw=xxxxxcon=psycopg2.connect(dbname='dynamicpop', host=hostname,port='15439', user='root', password=pw)#con=psycopg2.connect(dbname='dynamicpop', host='localhost',port...

https://www.jianshu.com/p/522f43ce8535find ./ -name "*.py" | xargs grep "psycopg2" -l.//2018/20181121_congestion/git_backlog/huff_model/dynamicpop.py.//20190722_自動化graph/time/main_thread.py.//201...

#-*-coding:utf-8-*-import matplotlib.font_manager as fmfonts = fm.findSystemFonts()i=0print(fonts)print("")for f in fonts: font = fm.FontProperties(fname=f) print(i) print(fonts[i])...

翻知乎还有各种谷歌，大概总结了一下。統計：　▶︎ 3sigma　▶︎ grubbs　▶︎ boxplot　▶︎ z-scoreclusterneighborhood密度isolation forestskylinehttps://earthgecko-skyline.readthedocs.io/en/latest/overview.htmlhttps://www.dig...

awscli 里不能直接使用“*”aws s3 rm s3://s3://log-provision/08_nhk/mesh/temp/*/*/ver3/*这样是不行的，需要使用--recursive和--exclude、--include.在--exclude、--include里使用“*”。--exclude是表示删除文件时，不可以删除的部分。--include是表示删除文件时，需...

splitting bumpy array based on valuehttps://stackoverflow.com/questions/38277182/splitting-numpy-array-based-on-valueimport numpy as npfrom itertools import groupbyb = np.array([ 1, 1, 100, 1...

http://www.vizzingdata.com/advanced-charting-rank-charts/https://public.tableau.com/profile/na7074#!/vizhome/rank_Chart/Sheet1?publish=yes

https://mc.bbbike.org/mc/https://interworks.com/blog/zgorman/2015/05/11/bringing-custom-map-tableau-10-minutes-or-less?utm_content=buffere1f1d&utm_medium=social&utm_source=twitter.com&utm...

起因是我的~/.ssh/config里有这样几行：Host D1 HostName 35.161.xx.xxx Port 222 User na.xxxx IdentityFile ~/.ssh/id_rsa LocalForward 15439 redshift-db.xxxx.amazonaws.c...

tableau新版本里的action里添加了参数功能（？）我按着视频教程实现了一下，还有twitter上一个人发的也做了一下。https://twitter.com/thoang1000/status/1108813668387561472然后发到了tableau public上。https://public.tableau.com/profile/na7074#!/vizhome/par...

今天查了下，可是没有搞太清楚，暂时先记录一下。hivehive是基于Hadoop的一个数据仓库工具，可以将结构化的数据文件映射为一张数据库表，并提供简单的sql查询功能，可以将sql语句转换为MapReduce任务进行运行。 其优点是学习成本低，可以通过类SQL语句快速实现简单的MapReduce统计，不必开发专门的MapReduce应用，十分适合数据仓库的统计分析。Hive是建立在 ...

参考：https://dev.classmethod.jp/business/business-analytics/tableau-tabcmd-mac/先下载需要的软件下载个解压的软件https://theunarchiver.com下载java（别下最新版本，下8那个版本)https://www.oracle.com/technetwork/java/javase/download...

https://playfairdata.com/tableau-201-make-dynamic-dual-axis-bump-charts/Database: SuperStonebump graphCreate Calculated Filed : (Sales_Rank)RANK(sum(Sales))Columns: MONTH(Order Data)Rows: S...

读csv文件test1.csvmesh,pop1,2002,3003,400test2.csv1,2002,3003,400import pandas as pd#会从第一行开始读数据df = pd.read_csv('test2.csv', header=None,names=["mesh","pop"])#会把csv的第一行认为是header,数据从第二行开始d...

https://community.tableau.com/thread/211365create calculated field:(top5)IF RANK(SUM(factor)) <= 5 THEN ATTR([p_lodging]) END然后把它拖进“label”那里，右击 -> “computing using" -> p_lodging...