This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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'] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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) | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
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
- Create a Firebase project at the Firebase Console
Links to free resources for learning Python. Please report (via comments) broken links or if a resource is no longer free.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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/> |
NewerOlder