Google Sheets Copy data from Google Sheets in a view only mode This morning, I came across a Google Sheet in view only mode. I needed the data in an excel for further analysis. Here is a trick that worked. Simple, go to URL and
javascript Show colorful messages in devtools console Ever wondered how those portals (e.g. facebook) show colorful greeting and warning messages when you open devtools? Look no further! ... console_with_styling = function(e) { return console.log(""), console.log(
Install R-Project on Ubuntu 18.04 Again, setting up a new Ubuntu instance on EC2. Install R as follows: # Step 1 — Add GPG Key sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys E298A3A825C0D65DFD57CBB651716619E084DAB9 # Step 2 — Add the R Repository
anaconda Activating conda (anaconda) in bash in Mac OSX (macOS Catalina) I run into this problem every time I setup a new Macbook. In order to add conda to your bash profile, simply run the following commands cd YOUR_PATH_ANACONDA/bin ./conda init
daily coding Downloading a youtube playlist I recently attened a conference that was being presented off youtube but was in off-hours. The video content was available as a youtube playlist that I wanted to archive for offline viewing. After
go Install go on ubuntu Here are steps for installing go on ubuntu # download latest version curl -O https://storage.googleapis.com/golang/go1.14.2.linux-amd64.tar.gz # check sha256sum sha256sum go1.14.2.linux-amd64.tar.gz
daily coding Creating terminal screecast (with audio) Today, I discovered dhobsd/castty: A CLI tool to record audio-enabled screencasts of your terminal, for the web. [https://github.com/dhobsd/castty] Installation Installation was pretty easy on my mac: # install libsoundio
dailycoding Parsing a tab seperated zone file in shell For a research project, I wanted to analyze domain names. I got a copy of a zone file that was tab seperated. Before I could load it into pandas or r, I wanted
daily coding Daily Coding - Downloading videos from Youtube - Parenting mis-tip Let's make this extremely quick again. I've been pretty busy for the last couple of days (coding :) ), and haven't been really doing a good job on the
Visualization Visualize a csv of geo-coded points on Google Maps Quick demo! ;-) * Go to the maps link: https://support.google.com/mymaps/answer/3024454?co=GENIE.Platform%3DDesktop&hl=en * Sign in and get ready to create your map * Demo from
Investing Realizing superior returns through investing in leading growth stocks Lets look at the performance of investing in various companies in the technology space. The companies we have chosen for analysis are among the internet businesses and have a significant impact on our
Visualization Visualization of Tor Servers using IPinfo data Here is a visualization of Tor Servers after ~ 3000 rotations using @ipinfoio and @Mapbox rstats #privacy #anonymity #anonymous #dataprivacy #visualization Europe beats US ... but then strangely Russia isn’t quite in the action
IPinfo Detailed Guide to Geographic Targeting and Personalization using IPinfo.io 01 - What is IPInfo.io? Let's look at what this wonderful service called ipinfo.io is. As the webpage, says IPinfo is one of the most trusted sources of information
Analytics Calling a bash script with parameters | Demo to get IP address of any domain Originally posted at https://blog.mypad.in/calling-a-bash-script-with-parameters-demo-to-get-ip-address-of-any-domain/ In this post, lets look at solving a recurring task of having to launch bash scripts with custom parameters. I'll demonstrate this with
Data Analytics Processing JSON data on the command line Originally posted at: https://blog.mypad.in/processing-json-data-on-the-command-line/ JSON has become the defacto standard of data transfer for a major part of the internet now. Particularly with the ubiquitous usage of mobile apps,
Spider Pro Improve Productivity. Extract YouTube Transcripts using Spider Pro I've been working on trying to get a blog post related to Spider Pro, which is as they say is *one of the easiest ways to scrape the internet, simply start clicking and collect the data you need*.
Ghost Upgrading Ghost and creating a native desktop application on OSX I recently upgraded my installation to the latest version. And I definitely want to move working on my laptop and I use the Ghost desktop application to post content.But unfortunately, the application
MyPad Launch MyPad using Ghost, SQLlite and Isso I've been on working on deploying a new website at MyPad. I need to host a blog along with the site and was planning to use Ghost. Similar to this blog
git Searching commits across repos for particular text I have this terrible problem of having to search across multiple repos for notes that I have made. I have developed a fairly good habit of making notes of everything of interest. However,
Sublime Text Sublime Text Tip - Going to Any Open Window This is pretty cool. I have this recurring problem of having to shift to the right window while working. The primary reason to have so many windows open is to copy and paste
Meteor Custom CSS at a template level in Meteor This is a problem that I am going to face often and hence it is probably a good idea for me to figure out the solution. Problem I lean towards using standard UI
Research Some notes from [Fannie Mae's Doug Duncan explores the future of housing] Some notes from Fannie Mae's Doug Duncan explores the future of housing [https://podcasts.apple.com/us/podcast/fannie-maes-doug-duncan-explores-the-future-of-housing/id1426081802?i=1000448545613] * Demographics factors * Millenials are bigger population than boomers than
Terminal Mount harddrive in Ubuntu in write format I have a harddrive Seagate Backup Plus Drive that I use on Mac. Its a 5TB drive that used to work fine on my Mac Air. But, now I am having a lot