markwhat1

##Date and Time

=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))

##Date

=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))

##Time

Useful Pandas Snippets

A personal diary of DataFrame munging over the years.

Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)

	import json
	import requests
	import subprocess

	home = requests.get("https://content.services.pbskids.org/v2/kidspbsorg/home/").text
	home = json.loads(home)

	shows = {}
	episodes = {}

	// Variables used by Scriptable.
	// These must be at the very top of the file. Do not edit.
	// icon-color: blue; icon-glyph: laptop-code;
	// share-sheet-inputs: url;
	/*******************************************
	* *
	* /\ *
	* / \ _ __ _ __ *
	* / /\ \ \| '_ \\| '_ \ *
	* / ____ \\| \|_) \| \|_) \| *

	// Variables used by Scriptable.
	// These must be at the very top of the file. Do not edit.
	// icon-color: yellow; icon-glyph: download;
	// share-sheet-inputs: url;
	/********************************************
	* *
	* Import Script from Gist *
	* *
	* This script imports files from a Github *
	* Gist. *

	#facebook marketplace
	from selenium import webdriver
	from time import sleep
	from selenium.webdriver.common.keys import Keys
	from selenium.webdriver.support.ui import WebDriverWait
	from selenium.webdriver.common.by import By
	from selenium.webdriver.support import expected_conditions as EC
	from pymongo import MongoClient

	class App:

	#!/usr/bin/python

	import datetime
	import json
	import re
	import requests
	import time

	USER_AGENT_HEADER = {'User-Agent': 'nfl-fast-tweets/1.0'}

	# coding: utf-8
	from objc_util import *
	import console
	import urllib
	import dialogs

	WKWebView = ObjCClass('WKWebView')
	UIViewController = ObjCClass('UIViewController')
	UIBarButtonItem = ObjCClass('UIBarButtonItem')
	NSURLRequest = ObjCClass('NSURLRequest')

	# Link: http://www.reddit.com/r/PowerShell/comments/1khn9o/a_fun_script_for_friday_make_your_friends/
	# A fun script for Friday - make your friend's computer start talking to him/her (self.PowerShell)
	# submitted 1 year ago * by Sinisterly
	# A co-worker of mine stumbled upon this nifty blog article on how to make a text-to-speech call using PowerShell.
	# The article gives two examples:
	# - Call the SAPI.SPVoice COM object
	# - Load the reference to System.Speech
	# Where can this come in fun? Well, if you throw PSRemoting in, of course! In my testing, if you use the second method (or the pared down script below) you can make your victim's computer start talking to him or her. Here's how you do it:
	# 1. Provide a distraction so that your victim leaves their computer unlocked, and make yourself administrator on their workstation (only needed if you aren't already an admin!)
	# 2. Enable PSRemoting on their workstation. A method for doing this would be using PSExec:

	# Markdown to PDF Conversion
	#
	# This script converts Markdown markup to PDF directly on your iOS device.
	#
	# Please see the "Requirements" section in the docstring below for required
	# dependencies and the "Installation" section for instructions on how to
	# install them.
	#
	# Run this script directly or put it into the Pythonista editor action menu
	# with one of the following options as the first and sole argument: