equivalentideas

2018-02-05 Working with spreadsheets, Free Class at Frontyard Projects

Session Outline

• What is data?
  • Things and their attributes
  • How do spreadsheets present data? Rows and columns, things and attributes
  • Example, plants? Coconut tree, fig tree, parsley, strawberry, silver beat
  • Why use a spreadsheet to work with this data? Graphic and usable way to build and organise data
• Quick and powerful analysis tool

equivalentideas

# Put this script in the root directory of a Slack data export
# Run `bundle install` and then `bundle exec ruby slack_reactions_from_export.rb`
# This will create a file called `reactions.txt` with rows like this:
#
# 2017-04-09  9:56 in #general: 😀
# 2017-04-10  9:45 in #tech-discussions: ⚽️
# 2017-04-19 15:45 in #general: 💖
# 2017-04-20 11:59 in #general: :hugging_face:
# 2017-04-20 22:35 in #general: 🤕
# 2017-04-30 21:38 in #most17: ❤️❤️

equivalentideas

Rebooting the production morph.io server

1. Log into Linode and go to the page for morph.io
2. Go to the Remote Access tab and to Console Access at the bottom of that page
3. There’s a command there called ‘Lish via SSH’
4. Copy that to your local shell and run it. You should now see the output of the machine, processes running, dying etc.
5. In another shell session ssh to root@morph.io
6. Try the light touch first, run reboot there
   • If you switch to the lish session, you will see processes start shutting down in the linode console access session

• after a minute that may become stuck on a command

equivalentideas

line_count=$(cat emails.txt | wc -l)
file_count=0

while [ $file_count -lt $line_count ]
do
  echo "creating file emails_$file_count.csv"
  tail -n+$file_count emails.txt | head -n2000 >> emails_$file_count.csv
  file_count=$[$file_count+2000]
done

equivalentideas

# Run these commands on the production Rails console
# This creates a markdown file with the comments in the format:
# 
# From: Luke Bacon
# Date of Submission: 6 April 2017
#
# Comment text bla bla bla
#
# * * *
# 

equivalentideas

find . -name '*.mp3' | sed s/.mp3// | sed 's/.*/&.mp3 &.aiff/' | xargs -n 2 ffmpeg -i

equivalentideas

Keybase proof

I hereby claim:

• I am equivalentideas on github.
• I am equivalentideas (https://keybase.io/equivalentideas) on keybase.
• I have a public key ASCRtEsTIc-fZIAknASnMfiXEtN623R8LzctenDt90zoTQo

To claim this, I am signing this object:

equivalentideas

Dear <Organisation with the information>,

Could you please send through <documents with the information you want>.

If possible, please treat this as an administrative/informal request. Otherwise please proceed with my request as a formal information request under the Act.

Yours faithfully,

``

equivalentideas

CSV.open("./tmp/#{Date.today.to_s}_hidden_requests.csv", "wb") do |csv|
  # Make headers
  csv << [
    "id",
    "title",
    "url",
    "public_body_name",
    "jurisdiction",
    "created_at",
    "requester_name",

equivalentideas