Mining data dengan spreadsheet

(Comments)

Mining the data dengan Google spreadsheet

Banyak cara untuk menambang data!! salah satunya bahkan bisa dilakukan dengan google spreadsheet

Hal yang akan dirangkum di sini adalah

Google menu di spreadsheet

Fungsi VlookUp

Oke segera saja kita mulai


 

Pertama kita harus persiapkan dulu sebuah google spreadsheet untuk penambangan data ini

 

Answers_Report_Bot__ID__-_Google_Sheets


 

Kemudian setelah itu kita perlu membersiapkan spreadsheet untuk mendapatkan data yang ada dari code-z.dsn.net

Pastikan cell c7 menunjukkan pada response ID yang ingin dilaporkan

Answers_Report_Bot__ID__-_Google_Sheets


 

Setelah kita mendapatkan file nya jangan lupa untuk selalu memeriksa melalui google analytics atau google webmaster bahwa link tersebut tidak termasuk dengan link yang memiliki banyak visitor

Pages_-_Google_Analytics


 

Setelah itu jangan lupa di periksa apakah post yang akan kita hapus memiliki halaman yang rate nya tinggi

Answers_Report_Bot__ID__-_Google_Sheets

 

dengan kode berikut =arrayformula(vlookup(B7:B,GA!A:I,3,false))

dan jangan lupa jadikan subject id sebagai plain text agar bisa dibaca oleh vlookup


 

Setelah selesai kita bisa mencoba me run kodenya

Answers_Report_Bot__ID__-_Google_Sheets

 

Dan berikut hasilnya yang muncul

 

Setidaknya bermanfaat untuk bahan pengingat

Currently unrated

Comments

Riddles

22nd Jul- 2020, by: Editor in Chief
524 Shares 4 Comments
Generic placeholder image
20 Oct- 2019, by: Editor in Chief
524 Shares 4 Comments
Generic placeholder image
20Aug- 2019, by: Editor in Chief
524 Shares 4 Comments
10Aug- 2019, by: Editor in Chief
424 Shares 4 Comments
Generic placeholder image
10Aug- 2015, by: Editor in Chief
424 Shares 4 Comments

More News  »

Sekolah doktor itu bukan hukuman! Yuk atur waktumu!

Recent news
3 days, 1 hour ago

Kenapa sekolah PhD butuh waktu lama!?

Recent news

Kali ini kita akan bahas kenapa sekolah PhD itu lama! Tanpa panjang lebar, berikut cara ngeles gw! Maksudnya berikut alasannya! Hope its relate with you!

read more
3 days, 1 hour ago

Using Vertex AI for zero one and two three AI prediction

Recent news

Here is my documentation after learning the introduction of AI in courserERA.

read more
2 weeks, 6 days ago

Neural network with API for pre-trained API

Recent news

Overview

The Cloud Natural Language API lets you extract entities from text, perform sentiment and syntactic analysis, and classify text into categories.

read more
3 weeks, 1 day ago

what is null result

Recent news

Null result in economic is when the output does not supporting your hypothesis

read more
3 weeks, 3 days ago

Big Query in Google cloud - the first small step to become solution architect

Recent news
3 weeks, 3 days ago

Fixing the issue in assumption of OLS step by step or one by one

Recent news

Hi, I want to raise the issue related to know whether your OLS is ok or not. 

read more
1 month, 2 weeks ago

Meaning of 45 degree in economics chart

Recent news

The **45-degree line** in economics and geometry refers to a line where the values on the x-axis and y-axis are equal at every point. It typically has a slope of 1, meaning that for every unit increase along the horizontal axis (x), there is an equal unit increase along the vertical axis (y). Here are a couple of contexts where the 45-degree line is significant:

read more
2 months, 3 weeks ago

More News »

Generic placeholder image

Collaboratively administrate empowered markets via plug-and-play networks. Dynamically procrastinate B2C users after installed base benefits. Dramatically visualize customer directed convergence without