Skip to content

Instantly share code, notes, and snippets.

View andymithamclarke's full-sized avatar
👋

Andy Clarke andymithamclarke

👋
View GitHub Profile
@andymithamclarke
andymithamclarke / embedding_graphext_project.html
Created January 14, 2021 13:42
HTML snippet to embed a public project in another site
<!-- Insert your published project URL between the " " next to src= EG. src="https://public.graphext.com/myproject" -->
<iframe width="100%" height="600px" style="border: 0px # none;" src="[url]" scrolling="no" frameborder="0" marginheight="0px" marginwidth="0px" allow="fullscreen" allowfullscreen=""></iframe>
<!-- Customise the height and width attributes to fit your needs. -->
@andymithamclarke
andymithamclarke / twitter_query_language.md
Last active February 8, 2023 14:34
Twitter Query Language

🔍 Twitter Query Language

👀

These operators work on Web, Mobile, Tweetdeck.

Adapted from TweetDeck Help, @lucahammer Guide, @eevee Twitter Manual, @pushshift and Twitter / Tweetdeck itself. Contributions / tests, examples welcome!

Class Operator Finds Tweets… Eg:
@andymithamclarke
andymithamclarke / HumanResources.csv
Last active February 4, 2021 16:31
A public dataset of 14999 employees with information about their work
We can't make this file beautiful and searchable because it's too large.
Work Accident,Average Monthly Hours,Last Evaluation,Left,Number of Projects,Promoted in the last 5 years?,salary,Department,Satisfaction Level,Years in the Company
Yes,160,0.51,Yes,2,Yes,low,sales,0.45,3
Yes,223,0.86,Yes,5,No,medium,product_mng,0.76,5
Yes,158,0.62,Yes,4,No,low,technical,0.14,4
Yes,300,0.84,Yes,6,No,low,support,0.11,5
Yes,283,0.84,Yes,6,No,low,technical,0.1,4
Yes,263,0.88,Yes,4,No,low,marketing,0.84,5
Yes,226,0.87,Yes,4,No,medium,technical,0.92,6
Yes,266,0.81,Yes,6,No,medium,sales,0.11,4
Yes,232,0.88,Yes,5,No,medium,accounting,0.88,5
@andymithamclarke
andymithamclarke / Fictional-Employees.csv
Created February 11, 2021 13:08
A dataset of 100 fictional employees and information about their characteristics.
Name Gender Description Coachability Curiosity Work Ethic Intelligence Prior Success Passion Preparation Adaptability to Change Competitiveness Creativity Performance Level
Alex M Hard working and cheeky 6 4 7 9 10 1 7 3 3 7 High
Xavier M Serious and sensible 9 7 1 7 5 9 5 7 1 10 Low
Marc M Diligent and generous 7 5 6 8 5 2 2 6 1 9 Medium
Marta F Amiable and hard working 6 5 1 4 7 3 1 9 2 9 High
Esmeralda F Gregarious and inventive 2 5 8 1 4 8 5 6 8 9 Low
Leah F Inventive and sensible 3 5 5 9 3 5 10 4 8 4 Medium
Celia F Creative and intuitive 10 5 8 8 4 2 5 3 4 8 Low
John M Persistant and amiable 2 6 2 7 1 10 9 4 4 6 Medium
Thomas M Considerate and adventurous 8 10 6 8 1 4 6 7 8 10 High
@andymithamclarke
andymithamclarke / Fictional Employees With Time.csv
Created February 15, 2021 16:36
A dataset of 100 fictional employees alongside information about their characteristics and when they joined the company.
Name Gender Description Coachability Curiosity Work Ethic Intelligence Prior Success Passion Preparation Adaptability to Change Competitiveness Creativity Performance Level Date_joined
Alex M Hard working and cheeky 6 4 7 9 10 1 7 3 3 7 High 01.01.2010
Xavier M Serious and sensible 9 7 1 7 5 9 5 7 1 10 Low 01.01.2010
Marc M Diligent and generous 7 5 6 8 5 2 2 6 1 9 Medium 01.01.2010
Marta F Amiable and hard working 6 5 1 4 7 3 1 9 2 9 High 01.01.2010
Esmeralda F Gregarious and inventive 2 5 8 1 4 8 5 6 8 9 Low 01.01.2010
Leah F Inventive and sensible 3 5 5 9 3 5 10 4 8 4 Medium 01.01.2010
Celia F Creative and intuitive 10 5 8 8 4 2 5 3 4 8 Low 01.01.2010
John M Persistant and amiable 2 6 2 7 1 10 9 4 4 6 Medium 01.01.2010
Thomas M Considerate and adventurous 8 10 6 8 1 4 6 7 8 10 High 01.01.2010
@andymithamclarke
andymithamclarke / Collecting-Tweets.ipynb
Last active September 21, 2022 06:02
Collecting Tweets from the Twitter API using tweepy.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@andymithamclarke
andymithamclarke / Remote File.csv
Last active April 23, 2021 11:22
101 Scottish Whiskeys with Tasting Notes
RowID Distillery Body Sweetness Smoky Medicinal Tobacco Honey Spicy Winey Nutty Malty Fruity Floral Postcode Latitude Longitude Features
0 1.0 Aberfeldy 2.0 2.0 2.0 0.0 0.0 2.0 1.0 2.0 2.0 2.0 2.0 2.0 PH15 2EB 286580.0 749680.0 10.0
1 2.0 Aberlour 3.0 3.0 1.0 0.0 0.0 4.0 3.0 2.0 2.0 3.0 3.0 2.0 AB38 9PJ 326340.0 842570.0 10.0
2 3.0 AnCnoc 1.0 3.0 2.0 0.0 0.0 2.0 0.0 0.0 2.0 2.0 3.0 2.0 AB5 5LI 352960.0 839320.0 8.0
3 4.0 Ardbeg 4.0 1.0 4.0 4.0 0.0 0.0 2.0 0.0 1.0 2.0 1.0 0.0 PA42 7EB 141560.0 646220.0 8.0
4 5.0 Ardmore 2.0 2.0 2.0 0.0 0.0 1.0 1.0 1.0 2.0 3.0 1.0 1.0 AB54 4NH 355350.0 829140.0 10.0
5 6.0 ArranIsleOf 2.0 3.0 1.0 1.0 0.0 1.0 1.0 1.0 0.0 1.0 1.0 2.0 KA27 8HJ 194050.0 649950.0 10.0
6 7.0 Auchentoshan 0.0 2.0 0.0 0.0 0.0 1.0 1.0 0.0 2.0 2.0 3.0 3.0 G81 4SJ 247670.0 672610.0 7.0
7 8.0 Auchroisk 2.0 3.0 1.0 0.0 0.0 2.0 1.0 2.0 2.0 2.0 2.0 1.0 AB55 3XS 340754.0 848623.0 10.0
8 9.0 Aultmore 2.0 2.0 1.0 0.0 0.0 1.0 0.0 0.0 2.0 2.0 2.0 2.0 AB55 3QY 340754.0 848623.0 8.0
@andymithamclarke
andymithamclarke / disneyland_reviews.csv
Created April 14, 2021 10:55
42,656 Reviews of 3 Disneyland Branches
We can't make this file beautiful and searchable because it's too large.
Review_ID,Rating,Year_Month,Reviewer_Location,Review_Text,Branch
670772142,4,2019-4,Australia,If you've ever been to Disneyland anywhere you'll find Disneyland Hong Kong very similar in the layout when you walk into main street! It has a very familiar feel. One of the rides its a Small World is absolutely fabulous and worth doing. The day we visited was fairly hot and relatively busy but the queues moved fairly well. ,Disneyland_HongKong
670682799,4,2019-5,Philippines,"Its been a while since d last time we visit HK Disneyland .. Yet, this time we only stay in Tomorrowland .. AKA Marvel land!Now they have Iron Man Experience n d Newly open Ant Man n d Wasp!!Ironman .. Great feature n so Exciting, especially d whole scenery of HK (HK central area to Kowloon)!Antman .. Changed by previous Buzz lightyear! More or less d same, but I'm expecting to have something most!!However, my boys like it!!Space Mountain .. Turns into Star Wars!! This 1 is Great!!!For cast members (staffs) .. Felt bit MINUS point from before
id gender age hypertension heart_disease ever_married work_type Residence_type avg_glucose_level bmi smoking_status stroke
9046 Male 67 0 1 Yes Private Urban 228.69 36.6 formerly smoked 1
51676 Female 61 0 0 Yes Self-employed Rural 202.21 N/A never smoked 1
31112 Male 80 0 1 Yes Private Rural 105.92 32.5 never smoked 1
60182 Female 49 0 0 Yes Private Urban 171.23 34.4 smokes 1
1665 Female 79 1 0 Yes Self-employed Rural 174.12 24 never smoked 1
56669 Male 81 0 0 Yes Private Urban 186.21 29 formerly smoked 1
53882 Male 74 1 1 Yes Private Rural 70.09 27.4 never smoked 1
10434 Female 69 0 0 No Private Urban 94.39 22.8 never smoked 1
27419 Female 59 0 0 Yes Private Rural 76.15 N/A Unknown 1
@andymithamclarke
andymithamclarke / 💉 VAERS 2021 | Cleaning & Joining.ipynb
Last active June 9, 2021 08:45
A notebook documenting the way a team at Graphext cleaned and joined data from the 2021 VAERS wave.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.