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

Articles found under tag: tables

A script to find empty fields in a table


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


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


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


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


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


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


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


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

3 Simple, Excellent Linux Network Monitors Learn more about your network connections with the iftop, Nethogs, and vnstat tools.

Librem 5 Privacy-Focused Linux Phone Crowdfunding Campaign Ends with $2 Million

Librem 5 was successfully crowdfunded about two weeks ago when it surpassed its goal of $1.5 million, but the campaign continued to run

Wine 2.0 Gets Third Stability Update with Improvements for Adobe Premiere, More

Wine 2.0.3 comes three months after the previous maintenance release

GNOME 3.28 Linux Desktop Environment Development Kicks Off with First Snapshot

softpedia: With a three-day delay, the GNOME 3.27.1 milestone has been released this past weekend for early adopters

How to manage casual contributors to open source projects Try these strategies to better utilize contributions from your project's episodic volunteers.

How to Monitor and Detect Modified Files using Tripwire IDS on Ubuntu 16.04

HowToForge: Tripwire is a free and open source Intrusion Detection System (IDS).

5 ways to invigorate education with Raspberry Pi

Raspberry Pi and open source software are great options for teaching computers to students, teachers, and librarians.

How to explain Kubernetes in plain English

EnterprisersProject: Guidance on how to explain Kubernetes and orchestration in plain terms that people can at least begin to understand.

Updated Settings Application in Fedora 27 Workstation

FedoraMagazine: Fedora 27 Workstation is slated for release soon, and it ships with version 3.26 of GNOME.

GamingOnLinux Latest Articles

Overgrowth has finally left Early Access, after many years of development

Tags: Steam, Action, Indie Game, Humble StoreLike the idea of rabbits that walk, talk and kick ass? Overgrowth [Official Site] has finally left Early…

Indie FPS ‘Vengeance’ has a huge update, starting to actually get fun now

Tags: Action, FPS, Steam, Indie Game, Early AccessAlways on the lookout for a new FPS that supports Linux, with ‘Vengeance’ [Steam] being…

Perform a live concert in Comedy Night, now on Linux

Tags: Comedy, Simulation, SteamComedy Night [Steam], an online game about performing comedy in front of a live audience has recently released the…

SEUM: Speedrunners from Hell adds 33 new levels in 'The Drunk Side of the Moon' DLC

Tags: Steam, DLC, PlatformerNeed more speedrunning? SEUM: Speedrunners from Hell [Steam] has expanded with 33 more levels in their new 'The Drunk…

Space shooter 'ASTROKILL' updated with official Linux support

Tags: Action, Steam, Early AccessLooks like the Beta of ASTROKILL [Steam] went well, as the developer just pushed out a big update and with it comes…

The developers of Ashes of the Singularity: Escalation are working on the Linux version

Tags: Strategy, Steam, Coming SoonGood news for fans of strategy games, as Ashes of the Singularity: Escalation is currently being ported to Linux. …

Sunday Linux Gaming Wrap-up

Tags: MiscIt's Sunday, I have my coffee ready next to me in my favourite mug and it's time to take a look at things we've missed for Linux and Linux…

The Linux beta of 'The Coma: Recut' is running nicely, should be out properly soon

Tags: Steam, Indie Game, Unity3D, BetaThe Coma: Recut [Steam] is coming to Linux, with it currently in beta. I've tested the beta and it is running…

Some thoughts on the fast-paced strategy game Mushroom Wars 2

Tags: Strategy, Steam, Review, Indie GameMushroom Wars 2 [Steam] released for Linux recently, this fast-paced strategy game is a little on the…

The 'Jungle Inferno' update for Team Fortress 2 has landed

Tags: Steam, Action, FPS, Free GameTeam Fortress 2 [Steam], the free to play shooter from Valve has been updated once again with the Jungle Inferno…

Wine Staging 2.19 is now available with more D3D11 work

Tags: WineWine Staging 2.19 has been officially announced today, although it seems like a quieter release compared to the past releases. Here's whats…

The next three major Steam sale dates have been leaked

Tags: Steam, Game SaleValve never do manage to keep sale dates hidden for long, but for the dates of the three next major sales to slip is a bit…

Skirmish Line, a strategy game inspired by classic flash game Mud and Blood 2 is now on Linux

Tags: Steam, Indie Game, Strategy, Tower DefenceSkirmish Line [Steam, Official Site], a game inspired by an older flash game Mud and Blood 2 is now…

Colony building sim 'Maia' has a huge update with cats, dogs, hurricanes and more

Tags: Sandbox, Steam, Indie Game,, SimulationPet lovers gather around, as your off-world colonists will now have some pets! This might be one…

Friday Livestream with Samsai at 5 PM UTC!

Tags: LivestreamHello, dear viewers! It is time for us to welcome the coming weekend with a Friday Livestream! We have games, we have a silly…