{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "from datetime import date as dt\n", "import re " ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Page | \n", "2016-01-01 00:00:00 | \n", "2016-01-02 00:00:00 | \n", "2016-01-03 00:00:00 | \n", "2016-01-04 00:00:00 | \n", "2016-01-05 00:00:00 | \n", "2016-01-06 00:00:00 | \n", "2016-01-07 00:00:00 | \n", "2016-01-08 00:00:00 | \n", "2016-01-09 00:00:00 | \n", "... | \n", "2016-12-22 00:00:00 | \n", "2016-12-23 00:00:00 | \n", "2016-12-24 00:00:00 | \n", "2016-12-25 00:00:00 | \n", "2016-12-26 00:00:00 | \n", "2016-12-27 00:00:00 | \n", "2016-12-28 00:00:00 | \n", "2016-12-29 00:00:00 | \n", "2016-12-30 00:00:00 | \n", "2016-12-31 00:00:00 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "7089 | \n", "7592 | \n", "7436 | \n", "7032 | \n", "6498 | \n", "6887 | \n", "7209 | \n", "7022 | \n", "7194 | \n", "... | \n", "4931.0 | \n", "4034.0 | \n", "5204.0 | \n", "4331.0 | \n", "4572.0 | \n", "4509.0 | \n", "5392.0 | \n", "4950.0 | \n", "2931.0 | \n", "4101.0 | \n", "
1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "6182 | \n", "6447 | \n", "6437 | \n", "5912 | \n", "5205 | \n", "5770 | \n", "5998 | \n", "5948 | \n", "6165 | \n", "... | \n", "4617.0 | \n", "3663.0 | \n", "4882.0 | \n", "4028.0 | \n", "4263.0 | \n", "4176.0 | \n", "5068.0 | \n", "4539.0 | \n", "2666.0 | \n", "3754.0 | \n", "
2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "20 | \n", "49 | \n", "33 | \n", "49 | \n", "34 | \n", "26 | \n", "66 | \n", "28 | \n", "18 | \n", "... | \n", "26.0 | \n", "20.0 | \n", "19.0 | \n", "43.0 | \n", "24.0 | \n", "41.0 | \n", "39.0 | \n", "39.0 | \n", "31.0 | \n", "31.0 | \n", "
3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "5363 | \n", "6280 | \n", "6297 | \n", "6288 | \n", "6052 | \n", "6200 | \n", "5935 | \n", "5958 | \n", "6200 | \n", "... | \n", "3356.0 | \n", "3366.0 | \n", "2912.0 | \n", "2850.0 | \n", "3140.0 | \n", "3379.0 | \n", "3497.0 | \n", "3338.0 | \n", "3329.0 | \n", "3550.0 | \n", "
4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "3186 | \n", "3784 | \n", "3832 | \n", "4059 | \n", "4022 | \n", "4213 | \n", "3985 | \n", "3823 | \n", "3794 | \n", "... | \n", "1719.0 | \n", "1593.0 | \n", "1255.0 | \n", "1160.0 | \n", "1311.0 | \n", "1468.0 | \n", "1728.0 | \n", "1494.0 | \n", "1515.0 | \n", "1464.0 | \n", "
5 rows × 367 columns
\n", "\n", " | Page | \n", "Date | \n", "Visits | \n", "
---|---|---|---|
0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "
1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "
2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "2016-01-01 | \n", "20.0 | \n", "
3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "
4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "
548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "
548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "
548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "
548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "
549000 rows × 3 columns
\n", "\n", " | Page | \n", "Date | \n", "Visits | \n", "Weekday | \n", "Month | \n", "
---|---|---|---|---|---|
0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "Friday | \n", "January | \n", "
1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "Friday | \n", "January | \n", "
2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "2016-01-01 | \n", "20.0 | \n", "Friday | \n", "January | \n", "
3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "Friday | \n", "January | \n", "
4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "Friday | \n", "January | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "Saturday | \n", "December | \n", "
548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "Saturday | \n", "December | \n", "
548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "Saturday | \n", "December | \n", "
548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "Saturday | \n", "December | \n", "
548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "Saturday | \n", "December | \n", "
549000 rows × 5 columns
\n", "\n", " | Page | \n", "Date | \n", "Visits | \n", "Weekday | \n", "Month | \n", "Language_Codes | \n", "
---|---|---|---|---|---|---|
0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "
1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "
2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "2016-01-01 | \n", "20.0 | \n", "Friday | \n", "January | \n", "_de. | \n", "
3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "
4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "
548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "
548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "
548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "
548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "
549000 rows × 6 columns
\n", "\n", " | Page | \n", "Date | \n", "Visits | \n", "Weekday | \n", "Month | \n", "Language_Codes | \n", "Language_Names | \n", "
---|---|---|---|---|---|---|---|
0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "
1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "
2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "2016-01-01 | \n", "20.0 | \n", "Friday | \n", "January | \n", "_de. | \n", "German | \n", "
3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "
4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "
548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "
548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "
548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "
548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "
549000 rows × 7 columns
\n", "\n", " | Page | \n", "Date | \n", "Visits | \n", "Weekday | \n", "Month | \n", "Language_Codes | \n", "Language_Names | \n", "Title | \n", "Device | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "all-access_all-agents | \n", "
1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "mobile-web_all-agents | \n", "
2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "2016-01-01 | \n", "20.0 | \n", "Friday | \n", "January | \n", "_de. | \n", "German | \n", "1._Juli_de.wikipedia | \n", "desktop_all-agents | \n", "
3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "all-access_all-agents | \n", "
4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "desktop_all-agents | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zac_Efron_en.wikipedia | \n", "all-access_all-agents | \n", "
548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zayn_Malik_en.wikipedia | \n", "all-access_all-agents | \n", "
548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "all-access_all-agents | \n", "
548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "mobile-web_all-agents | \n", "
548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zodiac_Killer_en.wikipedia | \n", "all-access_all-agents | \n", "
549000 rows × 9 columns
\n", "\n", " | Page | \n", "Date | \n", "Visits | \n", "Weekday | \n", "Month | \n", "Language_Codes | \n", "Language_Names | \n", "Title | \n", "Device | \n", "Device_Type | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "2016-01-01 | \n", "20.0 | \n", "Friday | \n", "January | \n", "_de. | \n", "German | \n", "1._Juli_de.wikipedia | \n", "desktop_all-agents | \n", "Desktop | \n", "
3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "desktop_all-agents | \n", "Desktop | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zac_Efron_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zayn_Malik_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zodiac_Killer_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
549000 rows × 10 columns
\n", "\n", " | Page | \n", "Date | \n", "Visits | \n", "Weekday | \n", "Month | \n", "Language_Codes | \n", "Language_Names | \n", "Title | \n", "Device | \n", "Device_Type | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "2016-01-01 | \n", "20.0 | \n", "Friday | \n", "January | \n", "_de. | \n", "German | \n", "1._Juli_de.wikipedia | \n", "desktop_all-agents | \n", "Desktop | \n", "
3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "desktop_all-agents | \n", "Desktop | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zac_Efron_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zayn_Malik_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zodiac_Killer_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
542778 rows × 10 columns
\n", "\n", " | index | \n", "Page | \n", "Date | \n", "Visits | \n", "Weekday | \n", "Month | \n", "Language_Codes | \n", "Language_Names | \n", "Title | \n", "Device | \n", "Device_Type | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
1 | \n", "1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
2 | \n", "2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "2016-01-01 | \n", "20.0 | \n", "Friday | \n", "January | \n", "_de. | \n", "German | \n", "1._Juli_de.wikipedia | \n", "desktop_all-agents | \n", "Desktop | \n", "
3 | \n", "3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
4 | \n", "4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "desktop_all-agents | \n", "Desktop | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
542773 | \n", "548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zac_Efron_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
542774 | \n", "548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zayn_Malik_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
542775 | \n", "548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
542776 | \n", "548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
542777 | \n", "548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zodiac_Killer_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
542778 rows × 11 columns
\n", "\n", " | index | \n", "Page | \n", "Date | \n", "Visits | \n", "Weekday | \n", "Month | \n", "Language_Codes | \n", "Language_Names | \n", "Title | \n", "Device | \n", "Device_Type | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
Row | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
0 | \n", "0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
1 | \n", "1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
2 | \n", "2 | \n", "1._Juli_de.wikipedia.org_desktop_all-agents | \n", "2016-01-01 | \n", "20.0 | \n", "Friday | \n", "January | \n", "_de. | \n", "German | \n", "1._Juli_de.wikipedia | \n", "desktop_all-agents | \n", "Desktop | \n", "
3 | \n", "3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
4 | \n", "4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "desktop_all-agents | \n", "Desktop | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
542773 | \n", "548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zac_Efron_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
542774 | \n", "548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zayn_Malik_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
542775 | \n", "548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
542776 | \n", "548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
542777 | \n", "548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zodiac_Killer_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
542778 rows × 11 columns
\n", "\n", " | Page | \n", "Date | \n", "Visits | \n", "Weekday | \n", "Month | \n", "Language_Codes | \n", "Language_Names | \n", "Title | \n", "Device | \n", "Device_Type | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", ".xxx_en.wikipedia.org_all-access_all-agents | \n", "2016-01-01 | \n", "7089.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
1 | \n", ".xxx_en.wikipedia.org_mobile-web_all-agents | \n", "2016-01-01 | \n", "6182.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", ".xxx_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
3 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_all-acces... | \n", "2016-01-01 | \n", "5363.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
4 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_desktop_a... | \n", "2016-01-01 | \n", "3186.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "desktop_all-agents | \n", "Desktop | \n", "
5 | \n", "2014_FIFA_World_Cup_en.wikipedia.org_mobile-we... | \n", "2016-01-01 | \n", "2136.0 | \n", "Friday | \n", "January | \n", "_en. | \n", "English | \n", "2014_FIFA_World_Cup_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
548995 | \n", "Zac_Efron_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "13146.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zac_Efron_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
548996 | \n", "Zayn_Malik_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "12597.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zayn_Malik_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
548997 | \n", "Zendaya_en.wikipedia.org_all-access_all-agents | \n", "2016-12-31 | \n", "6217.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
548998 | \n", "Zendaya_en.wikipedia.org_mobile-web_all-agents | \n", "2016-12-31 | \n", "4650.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zendaya_en.wikipedia | \n", "mobile-web_all-agents | \n", "Mobile | \n", "
548999 | \n", "Zodiac_Killer_en.wikipedia.org_all-access_all-... | \n", "2016-12-31 | \n", "6659.0 | \n", "Saturday | \n", "December | \n", "_en. | \n", "English | \n", "Zodiac_Killer_en.wikipedia | \n", "all-access_all-agents | \n", "All Access | \n", "
418338 rows × 10 columns
\n", "