Skip to content
Home » Operating System » Page 5

Operating System

Operating System / OS Information, How-To’s, Tips, Tools, and Guides for a variety of systems

COMBINE MULTIPLE CSV FILES FROM THE COMMAND LINE AND RETAIN FILENAMES

For this guide we will take thousands of csv files and combine them into One single file, which will be uploaded to a database. This file will have a new column inserted, where the originating filename will be added next to the row. 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:

for /f %a in ('dir /b *.csv') do for /f "tokens=*" %b in (%a) do echo %b,%a >> 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

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

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

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


ARE YOU LEAKING PRIVATE INFORMATION, WHEN YOU VISIT WEBSITES?

How much information are you exposing on the internet? Check out the links below to find out more….

IP v4 Address Leaks
https://ipleak.net
https://nordvpn.com/what-is-my-ip/
https://browserleaks.com/ip

IP v6 Address Leaks
https://ipv6leak.com

DNS Leak
https://dnsleak.com/
https://www.dnsleaktest.com/

Browser Leaks
https://browserleaks.com/

Email Leaks
https://emailipleak.com/

Java Leaks
https://browserleaks.com/javascript

Canvas Fingerprinting
https://browserleaks.com/canvas

WebGL Testing
https://browserleaks.com/webgl

SSL Client Test
https://browserleaks.com/ssl

Geolocation Testing
https://browserleaks.com/geo

And SOOOOO Much More
https://browserleaks.com/#more

DELETE ALL PASSWORDS IN CHROME

This is the continuation of a series of articles, that help you divorce your life from BIG TECH. With the recent events in American Politics, the need for these guides has become apparent. I hope this guide assists in your journey to protect yourself.

Using a password manager is recommended….Allowing google to harvest your passwords…bad idea. This guide will show you how to quickly delete all of your passwords from Chrome, at once.

On a Windows 10 computer
Open Chrome
Press ctrl and h at the same time to show your History
Select Clear Browsing Data from the Menu on the left
You will have two options, Basic and Advanced
Select Advanced
Time Range: All Time
Place a checkmark next to Everything in the list below
Click Clear Data

All of your data and passwords will be erased.

To finish it off, disconnect the Sync option by selecting Turn off sync and personalization

You are well on your way to divorcing yourself from Google

WINDOWS 10 SET DEFAULT BROWSER TO FIREFOX

This is the continuation of a series of articles, that help you divorce your life from BIG TECH. With the recent events in American Politics, the need for these guides has become apparent. I hope this guide assists in your journey to protect yourself.

On your Windows 10 system, and after you have installed and secured Firefox
Go to the Type here to search box
Type in Default Apps and press Enter
The Default Apps window will appear
Scroll down to Web Browser
Click the Icon shown
Select Firefox
Close the window by pressing the X at the top

Your default browser is now Firefox

WINDOWS 10 REPLACE CHROME WITH FIREFOX

This is the continuation of a series of articles, that help you divorce your life from BIG TECH. With the recent events in American Politics, the need for these guides has become apparent. I hope this guide assists in your journey to protect yourself.

For many years, chrome was my go-to browser. Quick, Efficient, and able to handle everything that I could throw at it…It also allowed an attack against me, from a Threat Actor, who I personally knew. This Threat Actor logged into my google account from their corporate office Tewksbury MA, and also again at their residence in Beverly MA. Once in they had logged into my gmail account, synchronized all of my passwords and sites, then began logging into all of my business and personal accounts. I personally, was able to successfully track the Threat Actor, and worked with the State Police, Attorneys General, and the FBI in matter. Aside from that instance, BIG TECH has run amock, and my data needs, must be removed from them moving forward. For this I chose to deprecate Chrome and use Firefox (good old firefox)

As you can see, direct from the firefox website, they understood my reasons already: “No shady privacy policies or back doors for advertisers. Just a lightning fast browser that doesn’t sell you out.“

To install firefox on your Windows 10 computer
Open your browser and navigate to:
https://www.mozilla.org/en-US/firefox/new/
Click Download Now
Once the Firefox Installer downloads, Open the file and click Run
Click Next and the installtion will begin
Click Start Setup
Click Start Import
Select Chrome (or whatever other browser you use)
Click Next
Select Bookmarks
Don’t bring over Saved Logins and Passwords, use a password manager instead
Click Next
The import will run, and once completed click Finish
Select your Theme
Now click the Gear at the top right of your home page
Click Search
Change the Default Search Engine from Google to DuckDuckGo
And if you did not listen to me, and you brought over your Saved Logins and Passwords you will need to
Click Privacy & Security
Place a check mark in the box for Primary Password
Set a Primary Password, and Confirm it
Then click OK on the note that the password has been set

You are done! Happy and Safe Browsing!

PREVENT SIRI FROM DATA MINING APPS ON YOUR IPAD / IPHONE

This is the continuation of a series of articles, that help you divorce your life from BIG TECH. With the recent events in American Politics, the need for these guides has become apparent. I hope this guide assists in your journey to protect yourself.

Each and every time you download an app to your iPad or your iPhone, Siri jumps in and attempts to mine data about you, your behaviors, and they send this data back to BIG TECH…. Here is how to protect yourself from it

After downloading an application onto your iPad or your iPhone
From the device’s “Desktop”
Open the Settings App
Scroll down to the Application section where the recently installed application shows up
Click on the Application
Select Siri & Search from the menu on the Right
In this sub menu, deselect (Change from Green to Grey) each item
Learn from this App
Show Suggestions from APP
Suggest App
Show App in Search
Show Content in Search

You will also have to do this for every single app that was installed prior. I also suggest after every major update, you double check to ensure your settings have not been changed