| #!/bin/bash | |
| BLIGHT_PATH=$(sudo find /sys -type d -name intel_backlight) | |
| MAX_BRIGHTNESS=$(cat $BLIGHT_PATH/max_brightness) | |
| while [ 1 ]; do | |
| echo "$MAX_BRIGHTNESS*$(fswebcam --png -1 - | convert - -colorspace gray -format "%[fx:mean]" info:)" | \ | |
| bc -l | cut -d '.' -f 1 | \ | |
| sudo tee $BLIGHT_PATH/brightness; |
| <html> | |
| <body> | |
| <div id="react-root"></div> | |
| <script src="https://cdnjs.cloudflare.com/ajax/libs/react/16.0.0/umd/react.production.min.js"></script> | |
| <script src="https://cdnjs.cloudflare.com/ajax/libs/react-dom/16.0.0/umd/react-dom.production.min.js"></script> | |
| <script src="https://cdnjs.cloudflare.com/ajax/libs/babel-standalone/6.26.0/babel.min.js"></script> | |
| <script id="react-app" type="text/template"> | |
| const App = ({name}) => { |
| import pandas as pd | |
| from geopandas import GeoDataFrame | |
| from shapely.geometry import Point | |
| import fiona | |
| df = pd.read_csv('data.csv') | |
| geometry = [Point(xy) for xy in zip(df.x, df.y)] | |
| crs = {'init': 'epsg:2263'} #http://www.spatialreference.org/ref/epsg/2263/ | |
| geo_df = GeoDataFrame(df, crs=crs, geometry=geometry) |
| import urllib,sys,csv; | |
| print reduce(lambda p, new: (p[0] + (new - p[0])/p[1], p[1] + 1), map(float, (x['tip_amount'] for x in csv.DictReader(urllib.urlopen(sys.argv[1])))), (0, 1)) |
What follows is a technical test for this job offer at CARTO: https://boards.greenhouse.io/cartodb/jobs/705852#.WSvORxOGPUI
Build the following and make it run as fast as you possibly can using Python 3 (vanilla). The faster it runs, the more you will impress us!
Your code should:
We're going to use CARTO's builder. Signup for free accounts here: https://carto.com/signup
We're going to explore the space (through PostGIS) and time (native PostgreSQL) in today's workshops using two datasets that have lat/long and timestamps.
| #!/bin/bash | |
| # Author: Ivan Mincik, ivan.mincik@gmail.com | |
| S_PRIMARY="eDP1" | |
| S_OTHER=$(xrandr \ | |
| | grep -v "^$S_PRIMARY" \ | |
| | grep " connected" \ | |
| | awk -F " " '{print $1}') |
| 'use strict'; | |
| var DEFAULTS = { | |
| endpoint: 'https://rochoa.carto.com', | |
| sql: 'select * from airbnb_madrid_oct_2015_listings', | |
| cartocss: `#layer['mapnik::geometry_type'=1] { | |
| marker-width: 7; | |
| marker-fill: #EE4D5A; | |
| marker-fill-opacity: 0.9; | |
| marker-line-color: #FFFFFF; |
| /* | |
| FILE ARCHIVED ON 3:09:27 feb 10, 2005 AND RETRIEVED FROM THE | |
| INTERNET ARCHIVE ON 19:57:07 abr 24, 2016. | |
| JAVASCRIPT APPENDED BY WAYBACK MACHINE, COPYRIGHT INTERNET ARCHIVE. | |
| ALL OTHER CONTENT MAY ALSO BE PROTECTED BY COPYRIGHT (17 U.S.C. | |
| SECTION 108(a)(3)). | |
| */ | |
| // Copyright 2005 Google | |
| function ci(vg, Pf, yh) { |
