aaronbassett

Socials

• https://twitch.tv/aaronbassettdev
• https://twitter.com/aaronbassett
• https://github.com/aaronbassett

Source

• https://github.com/aaronbassett/FARM-starter

datagy

import openpyxl

files = [] # Insert paths to files here

for file in files:
    wb = openpyxl.load_workbook(file)
    sheet = wb['Sheet1']
    sheet['F9'] = '=SUM(F5:F8)'
    sheet['F9'].style = 'Currency'
    wb.save(file)

datagy

# Section 1
import openpyxl

files = [] #include paths to your files here
values = []

# Section 2
for file in files:
    wb = openpyxl.load_workbook(file)
    sheet = wb['Sheet1']

datagy

# Section 1
import pandas as pd
files = ['https://github.com/datagy/mediumdata/raw/master/january.xlsx', 'https://github.com/datagy/mediumdata/raw/master/february.xlsx', 'https://github.com/datagy/mediumdata/raw/master/march.xlsx']
combined = pd.DataFrame()

# Section 2
for file in files:
  df = pd.read_excel(file, skiprows = 3)
  combined = combined.append(df, ignore_index = True)
  

kentcdodds

const duplicates = filesAndHashes.filter((file1, index1, array) => {
  return array.some(
    (file2, index2) => index1 !== index2 && file1.hash === file2.hash,
  )
})

const groups = duplicates.reduce((groups, {filepath, hash}) => {
  groups[hash] = groups[hash] || []
  groups[hash].push(filepath)
  return groups

reinvanoyen

Add Git Branch Name to Terminal Prompt (zsh)

Updated for MacOS with zsh

• Catalina
• Big Sur
• Monterey
• Ventura
• Sonoma

CodingDoug

Building an assistant (chatbot) that translates languages, integrated with Slack

If you're trying to do this, you came to the right place!

See this code in action here: https://twitter.com/CodingDoug/status/953031540811825152

Setup

1. Create a Firebase project at the Firebase Console

ffranr

Resources For Learning Python

Links to free resources for learning Python. Please report (via comments) broken links or if a resource is no longer free.

Inspiration

Title	Link	Comments
Official Python Brochure		- PDF - Used by Google, Mozilla, NASA, Finance (Two Sigma, JPM, BAML), Animation (Blender)
Official Python Jobs Board		- Jobs specifically targetted at Python developers

bbengfort

import os
import time
import string
import pickle

from operator import itemgetter

from nltk.corpus import stopwords as sw
from nltk.corpus import wordnet as wn
from nltk import wordpunct_tokenize

andrawaag

  library(SPARQL)
  library(ggplot2)
  library(rworldmap)
  
  wdqs <- "https://query.wikidata.org/bigdata/namespace/wdq/sparql"
  query <- "PREFIX wd: <http://www.wikidata.org/entity/>
  PREFIX wdt: <http://www.wikidata.org/prop/direct/>
  PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  PREFIX p: <http://www.wikidata.org/prop/>
  PREFIX v: <http://www.wikidata.org/prop/statement/>