Skip to content

Instantly share code, notes, and snippets.

View simonespa's full-sized avatar

Simone Spaccarotella simonespa

View GitHub Profile
@simonespa
simonespa / dynamodb.js
Created January 14, 2023 16:37
AWS Dynamo DB
const AWS = require('aws-sdk');
AWS.config.update({region: 'eu-west-1'});
const dynamodb = new AWS.DynamoDB();
const params = {
ExpressionAttributeValues: {
':v1': {
S: 'aod'
@simonespa
simonespa / cloudwatch.js
Created January 14, 2023 16:13
CloudWatch Metrics (putMetricData)
// https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/CloudWatch.html#putMetricData-property
const AWS = require("aws-sdk");
const cloudwatch = new AWS.CloudWatch({
accessKeyId: process.env.AWS_ACCESS_KEY_ID,
secretAccessKey: process.env.AWS_SECRET_ACCESS_KEY,
sessionToken: process.env.AWS_SESSION_TOKEN,
region: process.env.AWS_REGION
});
@simonespa
simonespa / camera.html
Created January 14, 2023 12:46
Web Cam (navigator > MediaDevices > UserMedia)
<html>
<head>
<script type="text/javascript">
(async () => {
try {
const mediaStream = await navigator.mediaDevices.getUserMedia({
audio: true,
video: true
});
@simonespa
simonespa / dials.ts
Created October 27, 2022 11:15
Dials Reader
import fs from 'fs';
export class Dials {
private file: string;
private dials: object;
constructor(file: string) {
this.file = file;
try {
@simonespa
simonespa / pandas.py
Last active September 19, 2022 19:06
Pandas Queries
# Using groupby() and count()
df2 = df.groupby(['A'])['A'].count()
# Using GroupBy & count() on multiple column
df2 = df.groupby(['A','B'])['C'].count()
# Using GroupBy & size() on multiple column
df2 = df.groupby(['A','B'])['C'].size()
# using DataFrame.size() and max()
@simonespa
simonespa / feature_type_detection.py
Created September 18, 2022 14:28
Pandas feature type detection
def detect_features(data_frame):
numerical = []
categorical = []
for name, type in dict(data_frame.dtypes).items():
if type == 'object':
categorical.append(name)
else:
numerical.append(name)
return {
@simonespa
simonespa / Database.java
Created August 15, 2022 22:02
Java DB connection
package database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Database {
@simonespa
simonespa / UrlConnection.java
Created August 15, 2022 21:30
URL Connection in Java
package urlauthentication;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;
public class UrlConnection {
@simonespa
simonespa / http_requests.cpp
Created August 9, 2022 18:31
HTTP requests in C++
#include <iostream>
#include <string>
#include <curl/curl.h>
using namespace std;
static size_t WriteCallback(void *contents, size_t size, size_t nmemb, void *userp) {
((std::string*)userp)->append((char*)contents, size * nmemb);
return size * nmemb;
}
# To synchronise a local folder to a non-empty remote repo
git init
git remote add origin https://github.com/simonespa/repo.git
git pull origin main
git push -u origin main