The Linux Rain Linux General/Gaming News, Reviews and Tutorials

Articles found under tag: tables

A simpler track-changes script

By

Back in March 2015 I blogged about a track-changes script that reports the edits made to a tab-separated data table. The script actually generates two reports: a plain text version and a fancy HTML version. A slightly improved version of that script is on my data-cleaning website here. The script…

Read Article

A script to find empty fields in a table

By

It's pretty easy to see which fields are empty in the tab-separated table demo (below). The 2nd and 4th field, Col2 and Col4, have no visible characters at all in the rows below the header line: That was simple, but what if the table is huge, with lots of fields and records? Eyeballing for fields…

Read Article

Transposing rows and columns: 3 methods

By

Swapping the rows and columns in a table on the command line would seem to be a fairly easy thing to do. For example, with this tab-separated table (called 'tabbed') as input: get this tab-separated table ('swapped') as output: Datamash Transposing rows and columns is indeed easy if you have the…

Read Article

Split a table and number the pieces: two methods

By

I worked on these bits of code to simplify a shell script of mine. You really wouldn't want to see the script's original commands here — they're way too ugly! The new commands are much prettier and work well. The problem To simplify the story, here's a comma-separated table called demo, sorted on t…

Read Article

Software is not data

By

You know that trick where the magician snatches the tablecloth from the table, leaving the plates, cutlery and glassware in place? Watch as I do something similar on my computer. The screenshot above shows the top left corner of a large data table of mine in a spreadsheet. Drum roll, please... …

Read Article

On dates and stuffed non-dates

By

Nothing gives my wife the Screaming Meemies like dates in spreadsheets. Unless she formats the target cell in advance as text, the spreadsheet will turn a perfectly innocent, non-date string like 23/2/6 into '23-Feb-2006'. When she types 6420-11-3, according to both LibreOffice Calc and Gnumeric,…

Read Article

The header line: how to add, delete and ignore it

By

In a plain-text table, the first or header line usually contains the names of the fields. In this article I've pulled together a variety of ways to add and delete a header, and also how to do things with the rest of the table while leaving the header intact as the first line in the file. Add a…

Read Article

Joining Tables on the Command-Line

By

This article compares 3 different ways to join tables on a common field. All 3 work OK on small tables, but there's a big difference in speed when the tables to be joined are large, as shown below. Table joining isn't something you need to do if you store data in a simple, flat-file database like a…

Read Article

Tips on Tables

By

Big data or small data, a lot of it comes these days as plain text arranged in rows and columns. Here are a few tips on working with tables of text, both in text editors and on the command line. CSV isn't what it seems. Text tables are often exported from databases and spreadsheets as…

Read Article

News Elsewhere

Linuxtoday.com

4 Ways to Disable Root Account in Linux

The root account is the ultimate account on a Linux and other Unix-like operating systems.

How To Remove Docker Containers, Images, Volumes, and Networks

Linuxize: Docker doesn't remove unused objects such as containers, images, volumes, and networks unless you explicitly tell it to do so.

On the low adoption of automated testing in FOSS

For projects of any value and significance, having a comprehensive automated test suite is nowadays considered a standard software engineering practice.

Android Integration Extension For Gnome GSConnect v13 Stable Released

 LinuxUprising: The latest GSConnect v13, released today, is a rewrite with with changes to the architecture, settings and default behavior, and it requires Gnome Shell 3.28 or 3.30.

How to start a vnc server for the actual display (scraping) with TigerVNC

HowToForge: VNC is a desktop sharing application

How the CISO of Xerox is Improving Security

eWEEK: Alissa Johnson knows full well that when it comes to securing a diverse, distributed enterprise like Xerox, there is no one single technology that is sufficient.

How To Browse And Read Entire Arch Wiki As Linux Man Pages

ostechnix: Arch-wiki-man program helps you to browse and read entire Arch Wiki as Linux man pages.

Linux: Find Out Which Port Number a Process is Listening on

As Linux users, we sometimes need to know which port number a particular process is listening upon.

How to Search and Remove Directories Recursively on Linux

Tecmint: This short tutorial describes how to find and delete directories recursively in the Linux file system.

GamingOnLinux Latest Articles

A statement from HOF Studios about the Depth of Extinction Steam key removal, plus thoughts

Tags: Steam, Misc, EditorialAfter writing about how the developer of Depth of Extinction revoked a user’s externally purchased Steam key after…

Game developer revokes a user's Steam key after negative review

Tags: Misc, Steam, Indie Game, EditorialHere's a case of how to definitely not deal with getting negative feedback. A developer of Depth of…

Control a magical flying door in To Leave, a mystifying difficult adventure now available on Linux

Tags: Steam, Platformer, Adventure, Puzzle, Indie Game, ReviewFreaky Creations recently released To Leave, a mystifying narrative-driven adventure…

Squally, a 2D game which has you hack it will be on Linux, demo available

Tags: Steam, Coming Soon, Indie Game, Early Access, Puzzle, Action, RPGI'm always curious to see how hacking mechanics make it into games and Squally…

A look at some interesting games and bundles on sale for Linux gamers

Tags: Game Sale, Game BundleHere's your (almost) weekly look at some interesting games and bundles that are currently on sale that have an…

You can try HITMAN free for a limited time in the Colorado location with the Halloween Pack

Tags: Steam, Feral Interactive, Stealth, ActionThe Halloween Pack pack for HITMAN goes live today giving you a chance to try it for free, which…

The excellent space-colony sim 'Oxygen Not Included' has a Space Industry update along with a new short

Tags: Steam, Indie Game, Early Access, Strategy, SimulationMy love for Klei continues on, with Oxygen Not Included getting another big update named…

Magic battle arena 'Magicae Mundi' has entered Early Access with Linux support

Tags: Early Access, Steam, Indie Game, ActionMagicae Mundi, a PvP magic battle arena game from developer Renan Sylvestre just entered Early Access…

Holy Potatoes! A Spy Story?! from Daylight Studios to release for Linux on November 7th

Tags: Coming Soon, Steam, Casual, Simulation, Strategy, ComedyThe wacky spy-agency sim Holy Potatoes! A Spy Story?! [Official Site] from Daylight…

Relaxing puzzle game inspired by Sudoku and Kakuro 'Puzlogic' to leave Early Access on November 2nd

Tags: Puzzle, Indie Game, Steam, Early AccessFor those who love to test their brain, the rather nice puzzle game Puzlogic which is inspired by…

Canonical have released some statistics from the Ubuntu installer survey

Tags: MiscWhen installing Ubuntu 18.04, Canonical's installer will offer to send some statistics to them. Canonical have now released some of this.…

Fight over the Iron Throne and swipe left or right in Reigns: Game of Thrones out now

Tags: GOG, Steam, Adventure, RPGReigns: Game of Thrones is the new entry to the Reigns series that has you swiping left and right to make decisions…

Rocket League's Halloween event is live, cross-platform 'RocketID' feature delayed and more news

Tags: Humble Store, Steam, Update, SportsThere's a few bits of Rocket League news to go over today, with the start being the Halloween event which is…

Hand of Fate 2 - The Servant and the Beast DLC is out extending the already great experience

Tags: DLC, GOG, Steam, Action, RPG, Indie GameReady to face the Dealer once again? Hand of Fate 2, the excellent mix of card-based board game…

The Steam Controller on Ubuntu 18.10 (and other distributions using Linux Kernel 4.18) needs a quick fix

Tags: HOWTO, HardwareAfter updating to Ubuntu 18.10 today I noticed that a lot of games were either crashing to the desktop, not detecting my Steam…