Fábio Miguel Mello fabiomello

pip install pandas openpyxl

import pandas as pd

df = pd.read_excel("/tmp/file.xlsx")
rows_per_file = 1000
n_chunks = len(df) // rows_per_file

List EFS FileSystems to Table by AWSCLI

echo "Listing all FS"
aws efs describe-file-systems --query "FileSystems[*].{FileSystemID:FileSystemId, Name:Name, SizeinBytes: SizeInBytes.Value}| []|reverse(sort_by(@, &SizeinBytes))" --output table > list.txt
cat list.txt
echo "Saving list to TXT"
cat list.txt|grep "fs-"|cut -d"|" -f2 > all_mounts.txt
mkdir -p /tmp/output
mkdir -p /tmp/mnt

find

SELECT pid, now() - pg_stat_activity.query_start AS duration, query, state FROM pg_stat_activity WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';

cancel

SELECT pg_cancel_backend(pid) FROM pg_stat_activity WHERE (now() - pg_stat_activity.query_start) &gt; interval '5 minutes';

	#!/bin/bash

	declare -a fonts=(
	Agave
	AnonymousPro
	Arimo
	AurulentSansMono
	BigBlueTerminal
	BitstreamVeraSansMono
	CascaidaCode

	#!/bin/bash
	sudo apt install libtool
	sudo apt install libyaml-dev
	asdf install ruby 3.2.2

	cd /tmp
	wget http://archive.debian.org/debian/pool/main/o/openssl/libssl1.0.0_1.0.2l-1~bpo8+1_amd64.deb
	wget http://archive.debian.org/debian/pool/main/o/openssl/libssl-dev_1.0.2l-1~bpo8+1_amd64.deb
	wget http://archive.debian.org/debian/pool/main/o/openssl/openssl_1.0.2l-1~bpo8+1_amd64.deb
	sudo dpkg -i libssl-dev_1.0.2l-1~bpo8+1_amd64.deb
	sudo dpkg -i libssl1.0.0_1.0.2l-1~bpo8+1_amd64.deb
	sudo dpkg -i openssl_1.0.2l-1~bpo8+1_amd64.deb

	sudo apt install curl git
	git clone https://github.com/asdf-vm/asdf.git ~/.asdf --branch v0.8.1
	echo '. $HOME/.asdf/asdf.sh' >> ~/.bashrc
	echo '. $HOME/.asdf/completions/asdf.bash' >> ~/.bashrc
	source ~/.bashrc
	sudo apt install dirmngr gpg curl gawk
	asdf plugin add nodejs https://github.com/asdf-vm/asdf-nodejs.git
	asdf plugin add ruby https://github.com/asdf-vm/asdf-ruby.git
	asdf plugin add erlang https://github.com/asdf-vm/asdf-erlang.git
	asdf plugin-add golang https://github.com/kennyp/asdf-golang.git

	#!/bin/bash

	echo "Instalando dependencias"
	sudo apt install -y git build-essential
	sudo apt install -y curl
	sudo apt install -y libssl1.0-dev
	sudo apt install -y libpq-dev
	sudo apt install -y libpq-dev

	echo "Instalando RBENV"

	#!/usr/bin/perl
	#Time-stamp: "2001-07-29 16:07:28 MDT"
	my $VERSION = '0.71';
	require 5.00404; # I don't think there's (?: ... ) before that.

	=head1 NAME

	crontab2english -- explain crontab commands in English

	=head1 SYNOPSIS