Create a Dual Color Axis in Tableau - InterWorks
With Tableau 8, users gained the ability to color marks by multiple dimensions on a single axis with some automatic combined field magic. What happens though, when you want color by a dimension and a measure? In the past, I have separated out members of a dimension and allowed the specific measure I needed with a calculated field: Western Region Sales = IF [Region] = ‘West’ THEN [Sales] END This d
Pythonã§ç«¶æŠ€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ï¼ˆãƒ—ãƒã‚³ãƒ³ï¼‰ - åˆå¾Œã‹ã‚‰â†’オーãƒãƒ¼ã‚¯ãƒãƒƒã‚¯
今更ã§ã¯ã‚ã‚‹ãŒä»Šå¾ŒAtCoderã®å•é¡Œã‚’解ã上ã§ä½¿ã£ãŸãƒ©ã‚¤ãƒ–ラリã¨ã‹æ‰‹æ³•ã¨ã‹ã‚’ ã“ã“ã«ã¾ã¨ã‚ã¦ã„ã“ã†ã¨æ€ã†ã€‚pythoné™å®šã€‚ 入出力 基本 i = input() x,y = map(int,raw_input().split()) 応用 複数行を一気ã«èªã‚“ã§ã€å…¥å‡ºåŠ›ã®ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã‚’ç„¡ãã›ã‚‹ã€‚ （行数ãŒå¤šã„時ã€ç¨€ã«ã“れをã—ãªã„ã¨TLEã«ãªã‚‹ã€‚） lines = sys.stdin.readlines() å› ã¿ã«ãƒãƒ¼ã‚«ãƒ«ã§å®Ÿè¡Œã™ã‚‹ã¨ãã¯<ctrl-d>ã¨ã‹ã§EOFを検知ã•ã›ã‚‹å¿…è¦ãŒæœ‰ã‚‹ã€‚ ãƒãƒ¼ã‚«ãƒ«ã§ã®å®Ÿè¡Œ クリップボードã«ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ï¼ˆãƒ†ã‚スト）コピーã—ãŸã‚ã¨ã€ 以下ã§ç°¡å˜ã«å®Ÿè¡Œã§ãる。 pbpaste| python test.py å•é¡ŒãŒé›£ã—ãã¦ã€ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’何回も使ã„ãã†ã ã¨æ€ã£ãŸå ´åˆã¯ã€ ファイルã«æ›¸ã出ã—ã¦ãŠã。 pbpaste > dataset1 pbpaste > da
The Best Data Visualization Projects of 2014
It’s always tough to pick my favorite visualization projects. I mean, it’s a challenge to pick and rank your favorite anything really. So much depends on what you feel like at the time, and there’s a lot of good work out there. Nevertheless, I gave it a go. These are my favorites for the year, roughly in order of favorite on down and based on use of data, design, and being useful. Mostly though, m
Hiveクエリãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ¡ãƒ¢ - 科å¦ã¨éžç§‘å¦ã®è¿·å®®
Hadoop本2版を買ã£ãŸãã®ä¸€é€±é–“後ã«Deals of the day ã§åŠé¡ã‚»ãƒ¼ãƒ«ã‚„られã¦æ»ã«ãŸããªã£ãŸã®ã§è…¹ã„ã›ã«æ›¸ã ã¯ã˜ã‚ã« ã“ã“ã«æ›¸ã„ã¦ã‚ã‚‹ã®ã¯å…¨éƒ¨å‚考リンク・文献ã‹ã‚‰ã²ã£ã±ã£ã¦ããŸã ã‘ã§ã€ã»ã¨ã‚“ã©å…¨éƒ¨æ¤œè¨¼ã—ã¦ãªã„。間é•ã„ãŒã‚ã‚Œã°ãªã‚‹ã¹ãæ—©ã‚ã«æ›´æ–°ã™ã‚‹ã‚ˆã†åŠªåŠ›ã¯ã™ã‚‹ãŒã€éµœå‘‘ã¿ã«ã—ã¦ä½•ãŒèµ·ãã¦ã‚‚自己責任ã§ã€‚ Hive ã®ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹ãƒ¡ãƒ¢æ›¸ãã§ã‚る。以下ã®ã“ã¨ã¯ã€Œæ›¸ã„ã¦ã„ãªã„〠Hadoop自体ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° Hive ã®ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ä»¥å¤–ã®è©± 例ãˆã°ã€åœ§ç¸®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ Hive 上ã§æ‰±ã†ã«ã¯ã©ã†ã™ã‚‹ã‹ã¨ã‹ JOIN 一番左ã®ãƒ†ãƒ¼ãƒ–ルã«æœ€ã‚‚大ããªãƒ†ãƒ¼ãƒ–ルをæŒã£ã¦ãã‚‹ 一番左ã®ãƒ†ãƒ¼ãƒ–ルãŒMRã§ã„ã†å…¥åŠ›ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦æµã‚Œã‚‹ã€‚インナーテーブルã®ãƒ‡ãƒ¼ã‚¿ã¯ãƒ¡ãƒ¢ãƒªã«ä¿æŒã•ã‚Œã‚‹ã€‚ åŒä¸€ JOIN ã‚ー 通常㯠1 JOIN = 1 MR ジョブã ãŒã€åŒä¸€ã® JOIN ã‚ーを使ã£ã¦ã„
ã€01Blog】フード系スタートアップãŒç†±ã„？ | Open Meetup Inc.
フード系ã®StartupãŒç†±ã„？ æ—¢ã«ã‚る程度盛り上ãŒã£ã¦ãã¦ã„ã‚‹ã¨ã¯æ€ã„ã¾ã™ãŒã€‚ アクセララレータã¨ã—ã¦ã¯Fresh Startupsãªã©ãŒé¢ç™½ã„ã§ã™ã。ã¾ãšã€ãƒ•ãƒ¼ãƒ‰ç³»ã¸ã®æŠ•è³‡ã¯å¢—ãˆã¦ã„ã¾ã™ã。 投資先ã¯ä¸‹è¨˜ã«ãƒžãƒƒãƒ—ãŒæœ‰ã‚Šã¾ã™ã€‚ é¢ç™½ã„スタートアップも多ã„ã¨æ€ã„ã¾ã™ãŒã€ã“ã¡ã‚‰ã«ã„ãã¤ã‹ã®ä¾‹ãŒFood2.0ã¨ã„ã†ã“ã¨ã§å–り上ã’られã¦ãŠã‚Šã¾ã™ã€‚é¢ç™½ã„モノãŒå¤šã„ã§ã™ã。æ¤ç‰©ã§åµã‚’ç½®ãæ›ãˆã‚‹ãªã©ã€‚ Food Tech＆Mediaã®MapãŒã‚ã‚Šã¾ã™ã®ã§ä¸‹è¨˜ã€å‚考ã«ã€‚食料ä¸è¶³ã‚‚ã‚ã‚Šã¾ã™ã—ã€ãƒãƒ©ãƒ¼ãƒ«ã®è©±ã‚‚ã‚ã‚Šã€ä»Šå¾ŒãŒæ¥½ã—ã¿ãªåˆ†é‡Žã§ã™ã。
Hiveã®joinã®æœ€é©åŒ– - wyukawa's diary
å…ƒãƒã‚¿ã¯ã“ã¡ã‚‰ Join Optimization in Apache Hive Hiveã¯0.7ã‹ã‚‰joinãŒæœ€é©åŒ–ã•ã‚Œã¦ã„ã¾ã™ã€‚ã©ã®ã‚ˆã†ã«æœ€é©åŒ–ã•ã‚ŒãŸã®ã‹ä¸Šè¨˜ã®è³‡æ–™ã‚’ã²ã‚‚ã¨ã„ã¦ã¿ã¾ã™ã€‚ ã„ã¾ã¾ã§ã®join ã„ã¾ã¾ã§ã®joinã¯ã„ã‚ゆるソートマージジョインã§ã™ã€‚ mapフェーズã§ãƒ†ãƒ¼ãƒ–ルã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚“ã§joinã‚ーã€joinãƒãƒªãƒ¥ãƒ¼ã‚’出力ã—ã€shuffleフェーズã§ã‚½ãƒ¼ãƒˆã€reduceフェーズã§joinã¨ã„ã†æµã‚Œã§ã™ã€‚ ã“ã®å ´åˆshuffleフェーズã®ã‚½ãƒ¼ãƒˆå‡¦ç†ãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ã¾ã—ãŸã€‚ ãã“ã§ç™»å ´ã™ã‚‹ã®ãŒMap Joinã§ã™ã€‚ joinã®ç‰‡æ–¹ã®ãƒ†ãƒ¼ãƒ–ルã®ã‚µã‚¤ã‚ºãŒãƒ¡ãƒ¢ãƒªã«åŽã¾ã‚‹ã»ã©å°ã•ã„ã®ã§ã‚ã‚Œã°ã€mapperã®ãƒ¡ãƒ¢ãƒªã«èªã¿è¾¼ã‚“ã§mapフェーズã ã‘ã§joinã—ã¾ã™ã€‚ ã“ã‚“ãªæ„Ÿã˜ã®æ§‹æ–‡ã§æ›¸ãã¾ã™ã€‚ select /*+mapjoin(a)*/ * from src1 x join
SQL感覚ã§HiveQLを書ãã¨ç—›ã„ç›®ã«ã‚ã†ä¾‹ - still deeper
Hadoop Advent Calendar 2013 4日目ã®è¨˜äº‹ã§ã™ tl;dr explainã¨job historyã‚’èªã‚ 1 reducerã¯æ‚ª data skewã¯æ‚ª å‰æ›¸ã ã¿ã‚“ãªå¤§å¥½ãSQLã§Hadoop上ã§ã®å‡¦ç†ã‚’実行ã§ãã‚‹Hiveã«ã¯ã¿ãªã•ã‚“普段ã‹ã‚‰ãŠä¸–話ã«ãªã£ã¦ã„ã‚‹ã“ã¨ã§ã—ょã†ã€‚ã¡ã‚‡ã£ã¨èª¿ã¹ç‰©ã§ã‚°ã‚°ã‚‹åº¦ã«ç›®ã«å…¥ã‚‹æ„›ã‚‰ã„ã—ã„マスコットãŒã€è’ã‚“ã 心ã«æ¸…涼ãªé¢¨ã‚’ã¯ã“ã‚“ã§ãã‚Œã¾ã™ã€‚ ã§ã™ãŒHiveã®ã‚¯ã‚¨ãƒªè¨€èªžã¯SQLã§ã¯ãªãHiveQLã§ã™ã—ã€å®Ÿè¡Œã‚¨ãƒ³ã‚¸ãƒ³ã‚‚RDBã®ãã‚Œã¨ã¯å…¨ãç•°ãªã‚‹MapReduceã§ã™ã€‚SQLã®ã¤ã‚‚ã‚Šã§HiveQLを書ã„ã¦ã„ã‚‹ã¨åœ°é›·ã‚’è¸ã‚“ã§ã—ã¾ã†ã“ã¨ãŒã¾ã‚Œã«ã‚ˆãã‚ã‚Šã¾ã™ã€‚本エントリã§ã¯é™¥ã‚ŠãŒã¡ãªHiveQLã®è½ã¨ã—ç©´ã‚’2ã¤ç´¹ä»‹ã—ã¾ã™ã€‚ 例1 SELECT count(DISTINCT user_id) FROM access_log SQLã«æ…£ã‚ŒãŸæ–¹ã§ã‚ã‚Œ
The New Digital Ad Ecosystem | AdExchanger
“Data-Driven Thinking†is written by members of the media community and contains fresh ideas on the digital revolution in media. Today’s column is written by Eric Picard, CEO at Rare Crowds. There has been a quiet shift in the digital ad ecosystem over the past few years, although it isn’t clear to many people working in the space. When we think about the ecosystem these days, we typically look at
Query Realtime SF Bus Locations With GeoFire 2.0
powered by Firebase What is GeoFire? GeoFire is a set of open-source libraries for JavaScript, Objective-C, and Java that allow you to store and query a set of items based on their geographic location. GeoFire uses the Firebase database for data storage, allowing query results to be updated in realtime as they change. GeoFire does more than just measure the distance between locations; it selective
Facebookã«ãƒã‚°ã‚¤ãƒ³ | Facebook
Facebookã«ãƒã‚°ã‚¤ãƒ³ã—ã¦ã€å‹é”や家æ—ã¨å†™çœŸã‚„è¿‘æ³ã‚’シェアã—ã¾ã—ょã†ã€‚
Marketing Technology Landscape Supergraphic (2012)
UPDATE: The 2020 Marketing Technology Landscape is now available. Marketing is in a whirlwind of technological innovation. It’s thrilling, inspiring, and a little dizzying. Last year, I made the first version of a marketing technology landscape infographic to try to glimpse the “big picture†of this broad field. I’m pleased to now share with you the all-new 2012 version of this supergraphic above
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Data Visualization in Python - theDevMasters
MapCarte 284/365: Pizza Geography by Nathan Yau, 2013 | Commission on Map Design
Home | Power BI
https://www.theinformationlab.co.uk/2013/12/02/tableau-file-types-and-extensions/
I Love You in 130 Languages — Cool Infographics
Map flap exposes soft spot in Apple strategy
https://jp.techcrunch.com/2012/12/13/jp20121213iphone-google-maps/
TechCrunch
https://jp.techcrunch.com/2012/08/03/20120802google-brings-street-view-to-kennedy-space-center/
{{#tags}}- {{label}}
{{/tags}}