Skip to content

COMBINE MULTIPLE CSV FILES FROM THE COMMAND LINE

For this guide we will take thousands of csv files and combine them into One single file, which will be uploaded to a database. In scraping sites, often my output files are separated and after i clean them up I need to combine them. This is how I do it.

On my Windows 10 computer
I will copy my CSV files over to a secondary drive, leaving the originals intact.
Then I will open a command prompt as an administrator and navigate to that drive. If the files are on my H: drive will navigate by typing
H:
Then press Enter

Now I will navigate to the “dataset” folder
cd dataset

I will then list the directory contents to ensure this holds my csv files
dir

Once I see all of my csv files I will enter the following
copy *.csv combined-date.csv
Then press Enter

This will create a file called combined-04132021.csv (which is today’s date)

And I can then upload that file to my database easily

THE VESPER

  • General

“Three measures of Gordon’s, one of vodka, half a measure of Kina Lillet. Shake it very well until it’s ice-cold, then add a large thin slice of lemon peel. Got it?”

-James Bond

US Stock Market Terminology

Quick Reference for Stock Market Terms. When you hear the major terms including equities, derivatives, fixed income, and cash, the information below are what constitutes each market

Equities
Stock
ETF
Mutual Funds

Derivatives
Options
Commodities
Forex (currencies)

Fixed Income
Bonds
Treasuries
Certificate of Deposit

Cash
Savings
Money Market

PAYPAL CRYPTO – CONVERTING CASH TO BITCOIN

  • Crypto

Recently Paypal has launched their crypto system, allowing you to purchase and sell crypto. Here is the rundown on how to do it, and what it does not do when converting cash to bitcoin, ethereum, litecoin and others

To convert cash to Bitcoin
Open a browser and navigate to https://www.paypal.com
Login to your Paypal account

Side Note:
Make sure your Paypal account is connected to your checking account already.. If it is not, you will have to do this

Once logged into Paypal, click on the Crypto button at the top right
Click BUY next to Bitcoin
Select the Big Blue Buy button at the center again

Side Note:
If this is your first time buying crypto with Paypal you will need to Confirm some extra info before you buy

Next you will put your amount listed in USD, into the Paypal window
Paypal will also add their Fees on top of the amount you specified
Click Confirm, and your crypto will be purchased with Paypal.

You now own crypto

Now for my issues with it
1. Paypal does not let you transfer your crypto out. They hold your crypto, and you hostage to their HUGE fees.

2. You do not have control over your crypto. They get hacked, you lose your crypto. You can do nothing about it

3.They show a chart that says Bitcoin is $59,133, however when you go to sell it, they immediately take roughly half a percent off. So in trying to sell it you see Bitcoin is $58,823. Cancel out of that screen, and Bitcoin is magically back at $59,151. Go back into the sell screen and your half a percent or so is gone again. Over and over I did this, and over and over the spread didn’t make sense.

4. When selling you also have to pay a large paypal fee

5. Then to transfer your cash back into your account, you pay another 1%

All in all, on a $10,200 transaction, I paid $410.33 in fees immediately and will be hit by the other 1% when it goes to my bank. Bitcoin did not decrease in price either during my 10 minute test. It actually increased in value around $80.

RASPBERRY PI 4 – FLIGHTAWARE SETUP

Flightaware…an amazing app, will give you a free subscription if you monitor the skies above your house. To setup a raspberry pi with this ability, perform the following

This guide assumes you have a Raspberry Pi, already setup with Raspbian. If you don’t have this, follow the guide below:
https://tacticalware.com/install-raspbian-os-on-raspberry-pi-4/

Once you are up and running with your Raspberry Pi, you will need to plug in your flightaware usb dongle which can be found on the bottom of this page

After that, run the following commands:
From your Raspberry Pi “Desktop”
Open a terminal
sudo bash
apt-get update
apt dist-upgrade
reboot

Your system will now reboot and come back up to your “Desktop”
Open a terminal
sudo bash
wget http://flightaware.com/adsb/piaware/files/packages/pool/piaware/p/piaware-support/piaware-repository_3.7.1_all.deb
dpkg -i piaware-repository_3.7.1.deb
apt-get update
apt-get install piaware
piaware-config allow-auto-updates yes
apt-get install dump1090-fa
reboot


Your system will now reboot and come back up to your “Desktop”
Open a terminal
sudo bash
ifconfig
get the ip address of your Pi
Open the Chromium web browser on your Raspberry Pi
Navigate to https://flightaware.com/adsb/piaware/claim
Create an account or Login and claim your piaware.
If successful you will see a message similar to the following message on the web page:
PiAware – Claim and Link a Brand New PiAware Ground Station
Success!
You claimed the following 1 receivers:
162323d5-6532-4s436-9486-d6173334
Next you will want to click on the link listed in your Success message:
Great news! Your account is associated with the following PiAware receivers and you can view your statistics here:
Now you will be in the config page of your flightaware account
So you will want to click on the Gear icon
Configure your location and the height of the antenna

And you are done!

You are now monitoring the sky overhead

Hardware I used:
Raspberry Pi 4 (4gb)
https://amzn.to/3q551IO

SanDisk 32GB Ultra microSDHC UHS-I Memory Card with Adapter
https://amzn.to/2Vfvo0y

CanaKit 3.5A Raspberry Pi 4 Power Supply (USB-C)
https://amzn.to/3fNTYPu

CanaKit Raspberry Pi 4 Micro HDMI Cable – 6 Feet
https://amzn.to/33u5hr9

SanDisk MobileMate USB 3.0 microSD Card Reader (Only needed if you dont have a Micro SD Reader/Writer slot in your computer)
https://amzn.to/39toi0G

Flightaware USB Stick
https://amzn.to/3aFKpju

Flightaware Antenna
https://amzn.to/3pZ3yn3

HOSTING WEBSITES BEYOND YOUR GOVERNMENT’S REACH

Many countries have websites, and content they cannot visit, or information they cannot post. Here in the States, simply saying fraud and election together will get you banned from social media and from searches….Welcome to 2021…

To post content beyond your local country’s censorship, you will have to make your website in a different country. Even then, your government may be able to take it down through their partnerships with those countries

How do you make sure you are safe, and your website is safe….

Build your website, in a country, which does not have an Extradition agreement with your local government….

For us in the States, to post information about fraudulent elections we would have to select a web hosting provider which resides outside of the countries in from the current list (they cannot be on this list):
https://en.wikipedia.org/wiki/List_of_United_States_extradition_treaties

ANTI-SURVEILLANCE / COUNTERSURVEILLANCE / ANTI-PAPPARAZZI / CLOTHING

  • Privacy

The simple lack of Privacy is becoming more and more prevalent these days. In looking for technologies that would skew unwanted photographs, I was able to find some info on the web, yet i was unable to purchase any products that actually did it. So I threw together some of my own COVID masks, with the pieces and parts added to them. Below you will find a few pictures of what I did.

I use bandannas as face coverings during the pandemic. While I will use an N95 mask, I will overlay it with your regular bandanna for that second (now CDC recommended) layer of protection.

I had decided to put the anti-surveillance tech to use on these bandannas
anti-surveillance
anti-papparazzi

As you can see from above, I started with the regular camo bandanna, and overlayed a pattern on top of them in this grey material. The grey pattern is the countersurveillance system.

When a photo is taken of these bandannas, and the flash is used (daytime or night time) the photo is blacked out, and the grey areas are now extraordinarily white, as you can see below. These photos were taken in the same light, of the same bandannas, using the same iphone camera. The only difference is the flash was now enabled, as is with most cameras.


countersurveillance


antipapparazzi

And finally here are some pictures of me, wearing it, and having a photo taken with the iphone camera’s flash on.

tacticalware.com - anti papparazzi

anti surveillance

If you have any interest in having some of these made for you, feel free to drop me a line at tacticalwaredotcom@gmail.com

RASPBERRY PI RDP TO WINDOWS 10

From time to time I need the ability to use RDP from my Raspberry Pi, to connect to my Windows 10 computer. Here is how I have installed RDP on my Raspberry Pi.

First you need to make sure your Raspberry Pi is running on Raspbian

Next, open a Terminal
Type:
sudo bash
apt-get update
apt-get dist-upgrade
apt-get install xrdp remmina
Press Y when prompted
The software will install
Once it has completed, reboot your Raspberry Pi

When you are back onto your Desktop
Go to the Raspberry Menu in the top left
Select Internet
Click Remmina

Now put the settings of your Windows 10 computer in, and make sure your Windows 10 system already has RDP enabled

Connect, and you are in!

Hardware that I used:
Raspberry Pi 4 (4gb)
https://amzn.to/3q551IO

SanDisk 32GB Ultra microSDHC UHS-I Memory Card with Adapter
https://amzn.to/2Vfvo0y

CanaKit 3.5A Raspberry Pi 4 Power Supply (USB-C)
https://amzn.to/3fNTYPu

CanaKit Raspberry Pi 4 Micro HDMI Cable – 6 Feet
https://amzn.to/33u5hr9

Western Digital 500GB WD_Black SN750 NVMe
https://amzn.to/3nZ5pH4

Plugable USB C to M.2 NVMe Tool-free Enclosure
https://amzn.to/3lflV3L

LISTS OF .ONION SITES

These are the two largest lists of .onion sites, which constantly update, that I use.

Reddit


The Hidden Wiki
http://zqktlwi4fecvo6ri.onion.ws/wiki/index.php/Main_Page

You’re Welcome

ACCESSING .ONION SITES WITHOUT TOR

While TOR is the recommended way to access the dark web, everyone and anyone can still visit without the same level of anonymity. I certainly would suggest using TOR always, however if you need to get to any .onion site from a computer without tor, you can do so by following this:

Open an internet browser (Edge, Firefox, Chrome, etc)
Type in the .onion site (ex. https://protonirockerxow.onion/rc/)
After the .onion portion of the address, add .dog (ex
Press Enter
You are now viewing RISEUP’s website on the darkweb, using a regular browser