You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hivemall.apache.org by my...@apache.org on 2016/10/22 19:23:14 UTC
[24/51] [partial] incubator-hivemall-site git commit: Added the user
guide
http://git-wip-us.apache.org/repos/asf/incubator-hivemall-site/blob/30afb6e4/userguide/ft_engineering/tfidf.html
----------------------------------------------------------------------
diff --git a/userguide/ft_engineering/tfidf.html b/userguide/ft_engineering/tfidf.html
new file mode 100644
index 0000000..7c6eb3a
--- /dev/null
+++ b/userguide/ft_engineering/tfidf.html
@@ -0,0 +1,1869 @@
+
+<!DOCTYPE HTML>
+<html lang="" >
+ <head>
+ <meta charset="UTF-8">
+ <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
+ <title>TF-IDF calculation � Hivemall User Manual</title>
+ <meta http-equiv="X-UA-Compatible" content="IE=edge" />
+ <meta name="description" content="">
+ <meta name="generator" content="GitBook 3.2.2">
+
+
+
+
+ <link rel="stylesheet" href="../gitbook/style.css">
+
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-splitter/splitter.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-etoc/plugin.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-callouts/plugin.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-toggle-chapters/toggle.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-codeblock-filename/block.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-expandable-chapters/expandable-chapters.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-multipart/multipart.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-katex/katex.min.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-emphasize/plugin.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-highlight/website.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-search/search.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-fontsettings/website.css">
+
+
+
+ <link rel="stylesheet" href="../gitbook/gitbook-plugin-theme-api/theme-api.css">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <meta name="HandheldFriendly" content="true"/>
+ <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
+ <meta name="apple-mobile-web-app-capable" content="yes">
+ <meta name="apple-mobile-web-app-status-bar-style" content="black">
+ <link rel="apple-touch-icon-precomposed" sizes="152x152" href="../gitbook/images/apple-touch-icon-precomposed-152.png">
+ <link rel="shortcut icon" href="../gitbook/images/favicon.ico" type="image/x-icon">
+
+
+ <link rel="next" href="ft_trans.html" />
+
+
+ <link rel="prev" href="hashing.html" />
+
+
+ </head>
+ <body>
+
+<div class="book">
+ <div class="book-summary">
+
+
+<div id="book-search-input" role="search">
+ <input type="text" placeholder="Type to search" />
+</div>
+
+
+ <nav role="navigation">
+
+
+
+<ul class="summary">
+
+
+
+
+ <li>
+ <a href="http://hivemall.incubator.apache.org/" target="_blank" class="custom-link"><i class="fa fa-home"></i> Home</a>
+ </li>
+
+
+
+
+ <li class="divider"></li>
+
+
+
+
+ <li class="header">TABLE OF CONTENTS</li>
+
+
+
+ <li class="chapter " data-level="1.1" data-path="../">
+
+ <a href="../">
+
+
+ <b>1.1.</b>
+
+ Introduction
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.2" data-path="../getting_started/">
+
+ <a href="../getting_started/">
+
+
+ <b>1.2.</b>
+
+ Getting Started
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="1.2.1" data-path="../getting_started/installation.html">
+
+ <a href="../getting_started/installation.html">
+
+
+ <b>1.2.1.</b>
+
+ Installation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.2.2" data-path="../getting_started/permanent-functions.html">
+
+ <a href="../getting_started/permanent-functions.html">
+
+
+ <b>1.2.2.</b>
+
+ Install as permanent functions
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.2.3" data-path="../getting_started/input-format.html">
+
+ <a href="../getting_started/input-format.html">
+
+
+ <b>1.2.3.</b>
+
+ Input Format
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="1.3" data-path="../tips/">
+
+ <a href="../tips/">
+
+
+ <b>1.3.</b>
+
+ Tips for Effective Hivemall
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="1.3.1" data-path="../tips/addbias.html">
+
+ <a href="../tips/addbias.html">
+
+
+ <b>1.3.1.</b>
+
+ Explicit addBias() for better prediction
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.3.2" data-path="../tips/rand_amplify.html">
+
+ <a href="../tips/rand_amplify.html">
+
+
+ <b>1.3.2.</b>
+
+ Use rand_amplify() to better prediction results
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.3.3" data-path="../tips/rt_prediction.html">
+
+ <a href="../tips/rt_prediction.html">
+
+
+ <b>1.3.3.</b>
+
+ Real-time Prediction on RDBMS
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.3.4" data-path="../tips/ensemble_learning.html">
+
+ <a href="../tips/ensemble_learning.html">
+
+
+ <b>1.3.4.</b>
+
+ Ensemble learning for stable prediction
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.3.5" data-path="../tips/mixserver.html">
+
+ <a href="../tips/mixserver.html">
+
+
+ <b>1.3.5.</b>
+
+ Mixing models for a better prediction convergence (MIX server)
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.3.6" data-path="../tips/emr.html">
+
+ <a href="../tips/emr.html">
+
+
+ <b>1.3.6.</b>
+
+ Run Hivemall on Amazon Elastic MapReduce
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="1.4" data-path="../tips/general_tips.html">
+
+ <a href="../tips/general_tips.html">
+
+
+ <b>1.4.</b>
+
+ General Hive/Hadoop tips
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="1.4.1" data-path="../tips/rowid.html">
+
+ <a href="../tips/rowid.html">
+
+
+ <b>1.4.1.</b>
+
+ Adding rowid for each row
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.4.2" data-path="../tips/hadoop_tuning.html">
+
+ <a href="../tips/hadoop_tuning.html">
+
+
+ <b>1.4.2.</b>
+
+ Hadoop tuning for Hivemall
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="1.5" data-path="../troubleshooting/">
+
+ <a href="../troubleshooting/">
+
+
+ <b>1.5.</b>
+
+ Troubleshooting
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="1.5.1" data-path="../troubleshooting/oom.html">
+
+ <a href="../troubleshooting/oom.html">
+
+
+ <b>1.5.1.</b>
+
+ OutOfMemoryError in training
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.5.2" data-path="../troubleshooting/mapjoin_task_error.html">
+
+ <a href="../troubleshooting/mapjoin_task_error.html">
+
+
+ <b>1.5.2.</b>
+
+ SemanticException Generate Map Join Task Error: Cannot serialize object
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.5.3" data-path="../troubleshooting/asterisk.html">
+
+ <a href="../troubleshooting/asterisk.html">
+
+
+ <b>1.5.3.</b>
+
+ Asterisk argument for UDTF does not work
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.5.4" data-path="../troubleshooting/num_mappers.html">
+
+ <a href="../troubleshooting/num_mappers.html">
+
+
+ <b>1.5.4.</b>
+
+ The number of mappers is less than input splits in Hadoop 2.x
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="1.5.5" data-path="../troubleshooting/mapjoin_classcastex.html">
+
+ <a href="../troubleshooting/mapjoin_classcastex.html">
+
+
+ <b>1.5.5.</b>
+
+ Map-side Join causes ClassCastException on Tez
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+
+
+
+ <li class="header">Part II - Generic Features</li>
+
+
+
+ <li class="chapter " data-level="2.1" data-path="../misc/generic_funcs.html">
+
+ <a href="../misc/generic_funcs.html">
+
+
+ <b>2.1.</b>
+
+ List of generic Hivemall functions
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="2.2" data-path="../misc/topk.html">
+
+ <a href="../misc/topk.html">
+
+
+ <b>2.2.</b>
+
+ Efficient Top-K query processing
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="2.3" data-path="../misc/tokenizer.html">
+
+ <a href="../misc/tokenizer.html">
+
+
+ <b>2.3.</b>
+
+ English/Japanese Text Tokenizer
+
+ </a>
+
+
+
+ </li>
+
+
+
+
+ <li class="header">Part III - Feature Engineering</li>
+
+
+
+ <li class="chapter " data-level="3.1" data-path="scaling.html">
+
+ <a href="scaling.html">
+
+
+ <b>3.1.</b>
+
+ Feature Scaling
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="3.2" data-path="hashing.html">
+
+ <a href="hashing.html">
+
+
+ <b>3.2.</b>
+
+ Feature Hashing
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter active" data-level="3.3" data-path="tfidf.html">
+
+ <a href="tfidf.html">
+
+
+ <b>3.3.</b>
+
+ TF-IDF calculation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="3.4" data-path="ft_trans.html">
+
+ <a href="ft_trans.html">
+
+
+ <b>3.4.</b>
+
+ FEATURE TRANSFORMATION
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="3.4.1" data-path="vectorizer.html">
+
+ <a href="vectorizer.html">
+
+
+ <b>3.4.1.</b>
+
+ Vectorize Features
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="3.4.2" data-path="quantify.html">
+
+ <a href="quantify.html">
+
+
+ <b>3.4.2.</b>
+
+ Quantify non-number features
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+
+
+
+ <li class="header">Part IV - Evaluation</li>
+
+
+
+ <li class="chapter " data-level="4.1" data-path="../eval/stat_eval.html">
+
+ <a href="../eval/stat_eval.html">
+
+
+ <b>4.1.</b>
+
+ Statistical evaluation of a prediction model
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="4.2" data-path="../eval/datagen.html">
+
+ <a href="../eval/datagen.html">
+
+
+ <b>4.2.</b>
+
+ Data Generation
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="4.2.1" data-path="../eval/lr_datagen.html">
+
+ <a href="../eval/lr_datagen.html">
+
+
+ <b>4.2.1.</b>
+
+ Logistic Regression data generation
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+
+
+
+ <li class="header">Part V - Binary classification</li>
+
+
+
+ <li class="chapter " data-level="5.1" data-path="../binaryclass/a9a.html">
+
+ <a href="../binaryclass/a9a.html">
+
+
+ <b>5.1.</b>
+
+ a9a Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="5.1.1" data-path="../binaryclass/a9a_dataset.html">
+
+ <a href="../binaryclass/a9a_dataset.html">
+
+
+ <b>5.1.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="5.1.2" data-path="../binaryclass/a9a_lr.html">
+
+ <a href="../binaryclass/a9a_lr.html">
+
+
+ <b>5.1.2.</b>
+
+ Logistic Regression
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="5.1.3" data-path="../binaryclass/a9a_minibatch.html">
+
+ <a href="../binaryclass/a9a_minibatch.html">
+
+
+ <b>5.1.3.</b>
+
+ Mini-batch Gradient Descent
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="5.2" data-path="../binaryclass/news20.html">
+
+ <a href="../binaryclass/news20.html">
+
+
+ <b>5.2.</b>
+
+ News20 Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="5.2.1" data-path="../binaryclass/news20_dataset.html">
+
+ <a href="../binaryclass/news20_dataset.html">
+
+
+ <b>5.2.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="5.2.2" data-path="../binaryclass/news20_pa.html">
+
+ <a href="../binaryclass/news20_pa.html">
+
+
+ <b>5.2.2.</b>
+
+ Perceptron, Passive Aggressive
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="5.2.3" data-path="../binaryclass/news20_scw.html">
+
+ <a href="../binaryclass/news20_scw.html">
+
+
+ <b>5.2.3.</b>
+
+ CW, AROW, SCW
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="5.2.4" data-path="../binaryclass/news20_adagrad.html">
+
+ <a href="../binaryclass/news20_adagrad.html">
+
+
+ <b>5.2.4.</b>
+
+ AdaGradRDA, AdaGrad, AdaDelta
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="5.3" data-path="../binaryclass/kdd2010a.html">
+
+ <a href="../binaryclass/kdd2010a.html">
+
+
+ <b>5.3.</b>
+
+ KDD2010a Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="5.3.1" data-path="../binaryclass/kdd2010a_dataset.html">
+
+ <a href="../binaryclass/kdd2010a_dataset.html">
+
+
+ <b>5.3.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="5.3.2" data-path="../binaryclass/kdd2010a_scw.html">
+
+ <a href="../binaryclass/kdd2010a_scw.html">
+
+
+ <b>5.3.2.</b>
+
+ PA, CW, AROW, SCW
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="5.4" data-path="../binaryclass/kdd2010b.html">
+
+ <a href="../binaryclass/kdd2010b.html">
+
+
+ <b>5.4.</b>
+
+ KDD2010b Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="5.4.1" data-path="../binaryclass/kdd2010b_dataset.html">
+
+ <a href="../binaryclass/kdd2010b_dataset.html">
+
+
+ <b>5.4.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="5.4.2" data-path="../binaryclass/kdd2010b_arow.html">
+
+ <a href="../binaryclass/kdd2010b_arow.html">
+
+
+ <b>5.4.2.</b>
+
+ AROW
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="5.5" data-path="../binaryclass/webspam.html">
+
+ <a href="../binaryclass/webspam.html">
+
+
+ <b>5.5.</b>
+
+ Webspam Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="5.5.1" data-path="../binaryclass/webspam_dataset.html">
+
+ <a href="../binaryclass/webspam_dataset.html">
+
+
+ <b>5.5.1.</b>
+
+ Data pareparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="5.5.2" data-path="../binaryclass/webspam_scw.html">
+
+ <a href="../binaryclass/webspam_scw.html">
+
+
+ <b>5.5.2.</b>
+
+ PA1, AROW, SCW
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+
+
+
+ <li class="header">Part VI - Multiclass classification</li>
+
+
+
+ <li class="chapter " data-level="6.1" data-path="../multiclass/news20.html">
+
+ <a href="../multiclass/news20.html">
+
+
+ <b>6.1.</b>
+
+ News20 Multiclass Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="6.1.1" data-path="../multiclass/news20_dataset.html">
+
+ <a href="../multiclass/news20_dataset.html">
+
+
+ <b>6.1.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="6.1.2" data-path="../multiclass/news20_one-vs-the-rest_dataset.html">
+
+ <a href="../multiclass/news20_one-vs-the-rest_dataset.html">
+
+
+ <b>6.1.2.</b>
+
+ Data preparation for one-vs-the-rest classifiers
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="6.1.3" data-path="../multiclass/news20_pa.html">
+
+ <a href="../multiclass/news20_pa.html">
+
+
+ <b>6.1.3.</b>
+
+ PA
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="6.1.4" data-path="../multiclass/news20_scw.html">
+
+ <a href="../multiclass/news20_scw.html">
+
+
+ <b>6.1.4.</b>
+
+ CW, AROW, SCW
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="6.1.5" data-path="../multiclass/news20_ensemble.html">
+
+ <a href="../multiclass/news20_ensemble.html">
+
+
+ <b>6.1.5.</b>
+
+ Ensemble learning
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="6.1.6" data-path="../multiclass/news20_one-vs-the-rest.html">
+
+ <a href="../multiclass/news20_one-vs-the-rest.html">
+
+
+ <b>6.1.6.</b>
+
+ one-vs-the-rest classifier
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="6.2" data-path="../multiclass/iris.html">
+
+ <a href="../multiclass/iris.html">
+
+
+ <b>6.2.</b>
+
+ Iris Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="6.2.1" data-path="../multiclass/iris_dataset.html">
+
+ <a href="../multiclass/iris_dataset.html">
+
+
+ <b>6.2.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="6.2.2" data-path="../multiclass/iris_scw.html">
+
+ <a href="../multiclass/iris_scw.html">
+
+
+ <b>6.2.2.</b>
+
+ SCW
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="6.2.3" data-path="../multiclass/iris_randomforest.html">
+
+ <a href="../multiclass/iris_randomforest.html">
+
+
+ <b>6.2.3.</b>
+
+ RandomForest
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+
+
+
+ <li class="header">Part VII - Regression</li>
+
+
+
+ <li class="chapter " data-level="7.1" data-path="../regression/e2006.html">
+
+ <a href="../regression/e2006.html">
+
+
+ <b>7.1.</b>
+
+ E2006-tfidf regression Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="7.1.1" data-path="../regression/e2006_dataset.html">
+
+ <a href="../regression/e2006_dataset.html">
+
+
+ <b>7.1.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="7.1.2" data-path="../regression/e2006_arow.html">
+
+ <a href="../regression/e2006_arow.html">
+
+
+ <b>7.1.2.</b>
+
+ Passive Aggressive, AROW
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="7.2" data-path="../regression/kddcup12tr2.html">
+
+ <a href="../regression/kddcup12tr2.html">
+
+
+ <b>7.2.</b>
+
+ KDDCup 2012 track 2 CTR prediction Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="7.2.1" data-path="../regression/kddcup12tr2_dataset.html">
+
+ <a href="../regression/kddcup12tr2_dataset.html">
+
+
+ <b>7.2.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="7.2.2" data-path="../regression/kddcup12tr2_lr.html">
+
+ <a href="../regression/kddcup12tr2_lr.html">
+
+
+ <b>7.2.2.</b>
+
+ Logistic Regression, Passive Aggressive
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="7.2.3" data-path="../regression/kddcup12tr2_lr_amplify.html">
+
+ <a href="../regression/kddcup12tr2_lr_amplify.html">
+
+
+ <b>7.2.3.</b>
+
+ Logistic Regression with Amplifier
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="7.2.4" data-path="../regression/kddcup12tr2_adagrad.html">
+
+ <a href="../regression/kddcup12tr2_adagrad.html">
+
+
+ <b>7.2.4.</b>
+
+ AdaGrad, AdaDelta
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+
+
+
+ <li class="header">Part VIII - Recommendation</li>
+
+
+
+ <li class="chapter " data-level="8.1" data-path="../recommend/cf.html">
+
+ <a href="../recommend/cf.html">
+
+
+ <b>8.1.</b>
+
+ Collaborative Filtering
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="8.1.1" data-path="../recommend/item_based_cf.html">
+
+ <a href="../recommend/item_based_cf.html">
+
+
+ <b>8.1.1.</b>
+
+ Item-based Collaborative Filtering
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="8.2" data-path="../recommend/news20.html">
+
+ <a href="../recommend/news20.html">
+
+
+ <b>8.2.</b>
+
+ News20 related article recommendation Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="8.2.1" data-path="../multiclass/news20_dataset.html">
+
+ <a href="../multiclass/news20_dataset.html">
+
+
+ <b>8.2.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="8.2.2" data-path="../recommend/news20_jaccard.html">
+
+ <a href="../recommend/news20_jaccard.html">
+
+
+ <b>8.2.2.</b>
+
+ LSH/Minhash and Jaccard Similarity
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="8.2.3" data-path="../recommend/news20_knn.html">
+
+ <a href="../recommend/news20_knn.html">
+
+
+ <b>8.2.3.</b>
+
+ LSH/Minhash and Brute-Force Search
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="8.2.4" data-path="../recommend/news20_bbit_minhash.html">
+
+ <a href="../recommend/news20_bbit_minhash.html">
+
+
+ <b>8.2.4.</b>
+
+ kNN search using b-Bits Minhash
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+ <li class="chapter " data-level="8.3" data-path="../recommend/movielens.html">
+
+ <a href="../recommend/movielens.html">
+
+
+ <b>8.3.</b>
+
+ MovieLens movie recommendation Tutorial
+
+ </a>
+
+
+
+ <ul class="articles">
+
+
+ <li class="chapter " data-level="8.3.1" data-path="../recommend/movielens_dataset.html">
+
+ <a href="../recommend/movielens_dataset.html">
+
+
+ <b>8.3.1.</b>
+
+ Data preparation
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="8.3.2" data-path="../recommend/movielens_mf.html">
+
+ <a href="../recommend/movielens_mf.html">
+
+
+ <b>8.3.2.</b>
+
+ Matrix Factorization
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="8.3.3" data-path="../recommend/movielens_fm.html">
+
+ <a href="../recommend/movielens_fm.html">
+
+
+ <b>8.3.3.</b>
+
+ Factorization Machine
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="8.3.4" data-path="../recommend/movielens_cv.html">
+
+ <a href="../recommend/movielens_cv.html">
+
+
+ <b>8.3.4.</b>
+
+ 10-fold Cross Validation (Matrix Factorization)
+
+ </a>
+
+
+
+ </li>
+
+
+ </ul>
+
+ </li>
+
+
+
+
+ <li class="header">Part IX - Anomaly Detection</li>
+
+
+
+ <li class="chapter " data-level="9.1" data-path="../anomaly/lof.html">
+
+ <a href="../anomaly/lof.html">
+
+
+ <b>9.1.</b>
+
+ Outlier Detection using Local Outlier Factor (LOF)
+
+ </a>
+
+
+
+ </li>
+
+
+
+
+ <li class="header">Part X - External References</li>
+
+
+
+ <li class="chapter " data-level="10.1" >
+
+ <a target="_blank" href="https://github.com/maropu/hivemall-spark">
+
+
+ <b>10.1.</b>
+
+ Hivemall on Apache Spark
+
+ </a>
+
+
+
+ </li>
+
+ <li class="chapter " data-level="10.2" >
+
+ <a target="_blank" href="https://github.com/daijyc/hivemall/wiki/PigHome">
+
+
+ <b>10.2.</b>
+
+ Hivemall on Apache Pig
+
+ </a>
+
+
+
+ </li>
+
+
+
+
+ <li class="divider"></li>
+
+ <li>
+ <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
+ Published with GitBook
+ </a>
+ </li>
+</ul>
+
+
+ </nav>
+
+
+ </div>
+
+ <div class="book-body">
+
+ <div class="body-inner">
+
+
+
+<div class="book-header" role="navigation">
+
+
+ <!-- Title -->
+ <h1>
+ <i class="fa fa-circle-o-notch fa-spin"></i>
+ <a href=".." >TF-IDF calculation</a>
+ </h1>
+</div>
+
+
+
+
+ <div class="page-wrapper" tabindex="-1" role="main">
+ <div class="page-inner">
+
+<div id="book-search-results">
+ <div class="search-noresults">
+
+ <section class="normal markdown-section">
+
+ <p>This document explains how to compute <a href="http://en.wikipedia.org/wiki/Tf%E2%80%93idf" target="_blank">TF-IDF</a> with Apache Hive/Hivemall.</p>
+<p>What you need to compute TF-IDF is a table/view composing (docid, word) pair, 2 views, and 1 query.</p>
+<p><em>Note that this feature is supported since Hivemall v0.3-beta3 or later. Macro is supported since Hive 0.12 or later.</em></p>
+<h1 id="define-macros-used-in-the-tf-idf-computation">Define macros used in the TF-IDF computation</h1>
+<pre><code class="lang-sql"><span class="hljs-keyword">create</span> <span class="hljs-keyword">temporary</span> macro max2(x <span class="hljs-built_in">INT</span>, y <span class="hljs-built_in">INT</span>)
+<span class="hljs-keyword">if</span>(x>y,x,y);
+
+<span class="hljs-comment">-- create temporary macro idf(df_t INT, n_docs INT)</span>
+<span class="hljs-comment">-- (log(10, CAST(n_docs as FLOAT)/max2(1,df_t)) + 1.0);</span>
+
+<span class="hljs-keyword">create</span> <span class="hljs-keyword">temporary</span> macro tfidf(tf <span class="hljs-built_in">FLOAT</span>, df_t <span class="hljs-built_in">INT</span>, n_docs <span class="hljs-built_in">INT</span>)
+tf * (<span class="hljs-keyword">log</span>(<span class="hljs-number">10</span>, <span class="hljs-keyword">CAST</span>(n_docs <span class="hljs-keyword">as</span> <span class="hljs-built_in">FLOAT</span>)/max2(<span class="hljs-number">1</span>,df_t)) + <span class="hljs-number">1.0</span>);
+</code></pre>
+<h1 id="data-preparation">Data preparation</h1>
+<p>To calculate TF-IDF, you need to prepare a relation consists of (docid,word) tuples.</p>
+<pre><code class="lang-sql"><span class="hljs-keyword">create</span> <span class="hljs-keyword">external</span> <span class="hljs-keyword">table</span> wikipage (
+ docid <span class="hljs-built_in">int</span>,
+ page <span class="hljs-keyword">string</span>
+)
+<span class="hljs-keyword">ROW</span> <span class="hljs-keyword">FORMAT</span> <span class="hljs-keyword">DELIMITED</span> <span class="hljs-keyword">FIELDS</span> <span class="hljs-keyword">TERMINATED</span> <span class="hljs-keyword">BY</span> <span class="hljs-string">'|'</span>
+<span class="hljs-keyword">STORED</span> <span class="hljs-keyword">AS</span> TEXTFILE;
+
+cd ~/tmp
+wget https://gist.githubusercontent.com/myui/190b91a3a792ccfceda0/raw/327acd192da4f96da8276dcdff01b19947a4373c/tfidf_test.tsv
+
+<span class="hljs-keyword">LOAD</span> <span class="hljs-keyword">DATA</span> <span class="hljs-keyword">LOCAL</span> INPATH <span class="hljs-string">'/home/myui/tmp/tfidf_test.tsv'</span> <span class="hljs-keyword">INTO</span> <span class="hljs-keyword">TABLE</span> wikipage;
+
+<span class="hljs-keyword">create</span> <span class="hljs-keyword">or</span> <span class="hljs-keyword">replace</span> <span class="hljs-keyword">view</span> wikipage_exploded
+<span class="hljs-keyword">as</span>
+<span class="hljs-keyword">select</span>
+ docid,
+ word
+<span class="hljs-keyword">from</span>
+ wikipage LATERAL <span class="hljs-keyword">VIEW</span> explode(tokenize(page,<span class="hljs-literal">true</span>)) t <span class="hljs-keyword">as</span> word
+<span class="hljs-keyword">where</span>
+ <span class="hljs-keyword">not</span> is_stopword(word);
+</code></pre>
+<p>You can download the data of the wikipage table from <a href="https://gist.githubusercontent.com/myui/190b91a3a792ccfceda0/raw/327acd192da4f96da8276dcdff01b19947a4373c/tfidf_test.tsv" target="_blank">this link</a>.</p>
+<h1 id="define-views-of-tfdf">Define views of TF/DF</h1>
+<pre><code class="lang-sql"><span class="hljs-keyword">create</span> <span class="hljs-keyword">or</span> <span class="hljs-keyword">replace</span> <span class="hljs-keyword">view</span> term_frequency
+<span class="hljs-keyword">as</span>
+<span class="hljs-keyword">select</span>
+ docid,
+ word,
+ freq
+<span class="hljs-keyword">from</span> (
+<span class="hljs-keyword">select</span>
+ docid,
+ tf(word) <span class="hljs-keyword">as</span> word2freq
+<span class="hljs-keyword">from</span>
+ wikipage_exploded
+<span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span>
+ docid
+) t
+LATERAL <span class="hljs-keyword">VIEW</span> explode(word2freq) t2 <span class="hljs-keyword">as</span> word, freq;
+
+<span class="hljs-keyword">create</span> <span class="hljs-keyword">or</span> <span class="hljs-keyword">replace</span> <span class="hljs-keyword">view</span> document_frequency
+<span class="hljs-keyword">as</span>
+<span class="hljs-keyword">select</span>
+ word,
+ <span class="hljs-keyword">count</span>(<span class="hljs-keyword">distinct</span> docid) docs
+<span class="hljs-keyword">from</span>
+ wikipage_exploded
+<span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span>
+ word;
+</code></pre>
+<h1 id="tf-idf-calculation-for-each-docidword-pair">TF-IDF calculation for each docid/word pair</h1>
+<pre><code class="lang-sql"><span class="hljs-comment">-- set the total number of documents</span>
+<span class="hljs-keyword">select</span> <span class="hljs-keyword">count</span>(<span class="hljs-keyword">distinct</span> docid) <span class="hljs-keyword">from</span> wikipage;
+<span class="hljs-keyword">set</span> hivevar:n_docs=<span class="hljs-number">3</span>;
+
+<span class="hljs-keyword">create</span> <span class="hljs-keyword">or</span> <span class="hljs-keyword">replace</span> <span class="hljs-keyword">view</span> tfidf
+<span class="hljs-keyword">as</span>
+<span class="hljs-keyword">select</span>
+ tf.docid,
+ tf.word,
+ <span class="hljs-comment">-- tf.freq * (log(10, CAST(${n_docs} as FLOAT)/max2(1,df.docs)) + 1.0) as tfidf</span>
+ tfidf(tf.freq, df.docs, ${n_docs}) <span class="hljs-keyword">as</span> tfidf
+<span class="hljs-keyword">from</span>
+ term_frequency tf
+ <span class="hljs-keyword">JOIN</span> document_frequency df <span class="hljs-keyword">ON</span> (tf.word = df.word)
+<span class="hljs-keyword">order</span> <span class="hljs-keyword">by</span>
+ tfidf <span class="hljs-keyword">desc</span>;
+</code></pre>
+<p>The result will be as follows:</p>
+<pre><code>docid word tfidf
+1 justice 0.1641245850805637
+3 knowledge 0.09484606645205085
+2 action 0.07033910867777095
+1 law 0.06564983513276658
+1 found 0.06564983513276658
+1 religion 0.06564983513276658
+1 discussion 0.06564983513276658
+ ...
+ ...
+2 act 0.017584777169442737
+2 virtues 0.017584777169442737
+2 well 0.017584777169442737
+2 willingness 0.017584777169442737
+2 find 0.017584777169442737
+2 1 0.014001086678120098
+2 experience 0.014001086678120098
+2 often 0.014001086678120098
+</code></pre><p>The above result is considered to be appropriate as docid 1, 2, and 3 are the Wikipedia entries of Justice, Wisdom, and Knowledge, respectively.</p>
+<h1 id="feature-vector-with-tf-idf-values">Feature Vector with TF-IDF values</h1>
+<pre><code class="lang-sql"><span class="hljs-keyword">select</span>
+ docid,
+ <span class="hljs-comment">-- collect_list(concat(word, ":", tfidf)) as features -- Hive 0.13 or later</span>
+ collect_list(feature(word, tfidf)) <span class="hljs-keyword">as</span> features <span class="hljs-comment">-- Hivemall v0.3.4 & Hive 0.13 or later</span>
+ <span class="hljs-comment">-- collect_all(concat(word, ":", tfidf)) as features -- before Hive 0.13</span>
+<span class="hljs-keyword">from</span>
+ tfidf
+<span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span>
+ docid;
+</code></pre>
+<pre><code>1 ["justice:0.1641245850805637","found:0.06564983513276658","discussion:0.06564983513276658","law:0.065
+64983513276658","based:0.06564983513276658","religion:0.06564983513276658","viewpoints:0.03282491756638329","
+rationality:0.03282491756638329","including:0.03282491756638329","context:0.03282491756638329","concept:0.032
+82491756638329","rightness:0.03282491756638329","general:0.03282491756638329","many:0.03282491756638329","dif
+fering:0.03282491756638329","fairness:0.03282491756638329","social:0.03282491756638329","broadest:0.032824917
+56638329","equity:0.03282491756638329","includes:0.03282491756638329","theology:0.03282491756638329","ethics:
+0.03282491756638329","moral:0.03282491756638329","numerous:0.03282491756638329","philosophical:0.032824917566
+38329","application:0.03282491756638329","perspectives:0.03282491756638329","procedural:0.03282491756638329",
+"realm:0.03282491756638329","divided:0.03282491756638329","concepts:0.03282491756638329","attainment:0.032824
+91756638329","fields:0.03282491756638329","often:0.026135361945200226","philosophy:0.026135361945200226","stu
+dy:0.026135361945200226"]
+2 ["action:0.07033910867777095","wisdom:0.05275433288400458","one:0.05275433288400458","understanding:0
+.04200326112968063","judgement:0.035169554338885474","apply:0.035169554338885474","disposition:0.035169554338
+885474","given:0.035169554338885474"
+...
+</code></pre>
+
+ </section>
+
+ </div>
+ <div class="search-results">
+ <div class="has-results">
+
+ <h1 class="search-results-title"><span class='search-results-count'></span> results matching "<span class='search-query'></span>"</h1>
+ <ul class="search-results-list"></ul>
+
+ </div>
+ <div class="no-results">
+
+ <h1 class="search-results-title">No results matching "<span class='search-query'></span>"</h1>
+
+ </div>
+ </div>
+</div>
+
+ </div>
+ </div>
+
+ </div>
+
+
+
+
+ </div>
+
+ <script>
+ var gitbook = gitbook || [];
+ gitbook.push(function() {
+ gitbook.page.hasChanged({"page":{"title":"TF-IDF calculation","level":"3.3","depth":1,"next":{"title":"FEATURE TRANSFORMATION","level":"3.4","depth":1,"path":"ft_engineering/ft_trans.md","ref":"ft_engineering/ft_trans.md","articles":[{"title":"Vectorize Features","level":"3.4.1","depth":2,"path":"ft_engineering/vectorizer.md","ref":"ft_engineering/vectorizer.md","articles":[]},{"title":"Quantify non-number features","level":"3.4.2","depth":2,"path":"ft_engineering/quantify.md","ref":"ft_engineering/quantify.md","articles":[]}]},"previous":{"title":"Feature Hashing","level":"3.2","depth":1,"path":"ft_engineering/hashing.md","ref":"ft_engineering/hashing.md","articles":[]},"dir":"ltr"},"config":{"plugins":["theme-api","edit-link","github","splitter","sitemap","etoc","callouts","toggle-chapters","anchorjs","codeblock-filename","expandable-chapters","multipart","codeblock-filename","katex","emphasize"],"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"s
tyles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"pluginsConfig":{"emphasize":{},"callouts":{},"etoc":{"maxdepth":3,"mindepth":1,"notoc":true},"github":{"url":"https://github.com/apache/incubator-hivemall/"},"splitter":{},"search":{},"downloadpdf":{"base":"https://github.com/apache/incubator-hivemall/docs/gitbook","label":"PDF","multilingual":false},"multipart":{},"lunr":{"maxIndexSize":1000000,"ignoreSpecialCharacters":false},"katex":{},"fontsettings":{"theme":"white","family":"sans","size":2,"font":"sans"},"highlight":{},"codeblock-filename":{},"sitemap":{"hostname":"http://hivemall.incubator.apache.org/"},"theme-api":{"languages":[],"split":false,"theme":"dark"},"sharing":{"facebook":true,"twitter":true,"google":false,"weibo":false,"instapaper":false,"vk":false,"all":["facebook","google","twitter","weibo","instapaper"]},"edit-link":{"label":"Edit","base":"https://github.com/apache/incubator-hivemall/docs/gitbook"},"theme-default":{"s
tyles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":true},"anchorjs":{"selector":"h1,h2,h3,*:not(.callout) > h4,h5"},"toggle-chapters":{},"expandable-chapters":{}},"theme":"default","pdf":{"pageNumbers":true,"fontSize":12,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":62,"left":62,"top":56,"bottom":56}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"variables":{},"title":"Hivemall User Manual","links":{"sidebar":{"<i class=\"fa fa-home\"></i> Home":"http://hivemall.incubator.apache.org/"}},"gitbook":"3.x.x","description":"User Manual for Apache Hivemall"},"file":{"path":"ft_engineering/tfidf.md","mtime":"2016-10-22T16:45:00.000Z","type":"markdown"},"gitbook":{"version":"3.2.2","time":"2016-10-22T19:10:36.585Z"},"basePath":"..","book":{"language":
""}});
+ });
+ </script>
+</div>
+
+
+ <script src="../gitbook/gitbook.js"></script>
+ <script src="../gitbook/theme.js"></script>
+
+
+ <script src="../gitbook/gitbook-plugin-edit-link/plugin.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-github/plugin.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-splitter/splitter.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-etoc/plugin.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-toggle-chapters/toggle.js"></script>
+
+
+
+ <script src="https://cdnjs.cloudflare.com/ajax/libs/anchor-js/3.1.1/anchor.min.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-anchorjs/anchor-style.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-expandable-chapters/expandable-chapters.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-search/search-engine.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-search/search.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-lunr/lunr.min.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-lunr/search-lunr.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-sharing/buttons.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>
+
+
+
+ <script src="../gitbook/gitbook-plugin-theme-api/theme-api.js"></script>
+
+
+
+ </body>
+</html>
+