Jennifer Zhao | SQL Problems Collection | 2018-02-22 22:14:27
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <title>Music Player</title> | |
| <link rel="stylesheet" href="player.css"> | |
| </head> | |
| <body> | |
| <img src="./assets/images/lemonade.png" id="background" /> | |
| <audio src="./assets/music/beyonce.mp3" id="song"></audio> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import os | |
| import time | |
| import sys | |
| from datetime import date, timedelta | |
| sdate = date(2019, 3, 1) # start date | |
| edate = date(2019, 3, 31) # end date | |
| delta = edate - sdate # as timedelta | |
| date_str = [] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // This example shows how to use row_number and rank to create | |
| // a dataframe of precipitation values associated with a zip and date | |
| // from the closest NOAA station | |
| import org.apache.spark.sql.expressions.Window | |
| import org.apache.spark.sql.functions._ | |
| // mocked NOAA weather station data | |
| case class noaaData(zip:String,station:String,date:Long,value:String=null,distance:Int) | |
| val t = Seq( |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| FROM continuumio/anaconda3 | |
| MAINTAINER muppal | |
| ARG ZEPPELIN_VERSION="0.8.1" | |
| ARG SPARK_VERSION="2.4.1" | |
| ARG HADOOP_VERSION="2.7" | |
| LABEL zeppelin.version=${ZEPPELIN_VERSION} | |
| LABEL spark.version=${SPARK_VERSION} | |
| LABEL hadoop.version=${HADOOP_VERSION} |
##Google Interview Questions: Product Marketing Manager
- Why do you want to join Google? -- Because I want to create tools for others to learn, for free. I didn't have a lot of money when growing up so I didn't get access to the same books, computers and resources that others had which caused money, I want to help ensure that others can learn on the same playing field regardless of their families wealth status or location.
- What do you know about Google’s product and technology? -- A lot actually, I am a beta tester for numerous products, I use most of the Google tools such as: Search, Gmaill, Drive, Reader, Calendar, G+, YouTube, Web Master Tools, Keyword tools, Analytics etc.
- If you are Product Manager for Google’s Adwords, how do you plan to market this?
- What would you say during an AdWords or AdSense product seminar?
- Who are Google’s competitors, and how does Google compete with them? -- Google competes on numerous fields: --- Search: Baidu, Bing, Duck Duck Go
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| %matplotlib inline | |
| %config InlineBackend.figure_format = 'retina' | |
| import matplotlib.pyplot as plt | |
| import seaborn as sns | |
| plt.style.use('ggplot') | |
| plt.rcParams["figure.figsize"] = (20,10) |
We can't make this file beautiful and searchable because it's too large.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| x1,x2,x3,x4,x5,x6,x7,x8,x9,x10,x11,x12,x13,x14,x15,x16,x17,x18,x19,x20,x21,x22,x23,x24,x25,x26,x27,x28,x29,x30,x31,x32,x33,x34,x35,x36,x37,x38,x39,x40,x41,x42,x43,x44,x45,x46,x47,x48,x49,x50,x51,x52,x53,x54,x55,x56,x57,x58,x59,x60,x61,x62,x63,x64,x65,x66,x67,x68,x69,x70,x71,x72,x73,x74,x75,x76,x77,x78,x79,x80,x81,x82,x83,x84,x85,x86,x87,x88,x89,x90,x91,x92,x93,x94,x95,x96,x97,x98,x99,x100,y | |
| 41.2028682586,4.92018352231,81.6538045147,20.9232542472,28.2259442663,34.363037865,93.2720789705,41.3350501051,12.7593744677,76.7414398929,57.1878002974,86.5875573171,97.3957999279,87.5066541712,41.6028115493,69.4553098938,90.0054532601,70.8702565335,25.8988878194,30.3698136448,83.909590161,86.8556886632,91.8432829472,12.4194124198,50.4726583211,58.6317197988,17.9600449113,0.971629272725,48.0760196925,52.0700613409,68.4171850513,98.1265719363,76.4057910108,0.713506768958,7.17199853928,92.3428203815,92.8129934105,46.3556516977,82.6658877852,10.9497189108,10.8098179619,25.1162758828,23.9025466818,80.8245597901,3.57902332403, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Use Gists to store code you would like to remember later on | |
| console.log(window); // log the "window" object to the console |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "fmt" | |
| "time" | |
| ) | |
| // Suggestions from golang-nuts | |
| // http://play.golang.org/p/Ctg3_AQisl |
NewerOlder