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

5 command-line games for sysadmins

If you're living life at your terminal emulator anyway, why not have a little fun while you're there #EnableSysadmin

Create & manage docker hosts with Docker Machine on VirtualBox

Docker Machine is a tool that let us install Docker Engine on virtual hosts on various platforms, on local environment as well on cloud.

How to Set Up RVM on Debian 10 Buster

If you plan on doing any sort of Ruby development, RVM is a must.

How to Enable Dynamic Transparency Ubuntu

MakeTechEasier:Even though it was removed, you can re-enable dynamic transparency on your Ubuntu PC with the GNOME desktop environment with a simple extension.

How to use Gnome shell's secret screen recorder

Learn how to use a Gnome shell's secret screen recorder.

How To Upgrade Everything Using Topgrade CLI Utility In Linux

ostechnix: The Topgrade utility will upgrade everything in Linux and Unix operating systems.

The E3 2019 Linux gaming round-up

GamingOnLinux: There was actually more from E3 2019 for Linux than I expected

Accessing remote desktops

Need to see what's happening on someone else's screen?

GamingOnLinux Latest Articles

The perils of crowdfunding for Linux games: Eco edition

Tags: Crowdfunding, EditorialWhen crowdfunding games, there's always a risk that something will go wrong. Sometimes games get cancelled, sometimes…

Humble Store have a nice City Builder sale going on this weekend

Tags: Humble Store, Game Sale, City BuilderJust a quick tip before it's over, Humble Store are currently doing a sale with a City Builder theme and…

Dota Underlords from Valve is already quite addictive and they're improving it quickly

Tags: Strategy, Beta, Steam, Valve, Initial ThoughtsWith Dota Underlords available for testing, I've now taken a look at it (thanks Scaine!) and so…

NetherWorld, an impressive looking and weird narrative pixel-art action game is coming to Linux

Tags: Pixel Graphics, Action, Steam, Indie Game, UpcomingCurrently in development by Hungry Pixel, NetherWorld has a pretty impressive pixel-art…

DXVK 1.2.2 released with performance improvements and bug fixes

Tags: Wine, VulkanDXVK, the incredible project that provides a Vulkan-based layer for D3D11 and D3D10 games run with Wine has another release now…

The Expression Amrilato, a Yuri Visual Novel that teaches some Esperanto has a same-day Linux release on GOG

Tags: Visual Novel, GOG, DRM-FreeCurrently stuck in release limbo on Steam, 'The Expression Amrilato' has been released on GOG today with full Linux…

GOG are giving away Toonstruck during the Summer Sale Festival finale

Tags: GOG, Free Game, Giveaway, DRM-FreeThe GOG Summer Sale Festival is ending on Monday June 17th at 10 PM UTC, so GOG are now giving away copies of…

The latest Volcanoids update sounds amazing, lets you directly pilot your drillship

Tags: Steam, Early Access, Indie Game, Steampunk, Unity, SurvivalVolcanoids, the steampunk survival game where your base of operations is a massive…

Skellboy looks like a very sweet action-RPG where you swap body parts

Tags: Action, RPG, Steam, UpcomingSkellboy, a recent discovery being developed by UmaikiGames and published by Fabraz (Slime-San, Planet Diver) looks…

Unique racing game 'Vector 36' adds online multiplayer in the latest update and a free weekend

Tags: Racing, Steam, Indie Game, UpdateVector 36 is a racing game that's quite unusual, as you're piloting a Skimmer across the surface of Mars. …

Relic Hunters Legend to enter Alpha later this month, includes Linux support

Tags: Action, Alpha, Indie Game, UpcomingRelic Hunters Legend, the crowdfunded shoot and loot RPG from Rogue Snail is gearing up for the Alpha…

Hard sci-fi space game 'Rings of Saturn' is now doing an Early Access crowdfunding mix on itch

Tags: Indie Game, Early Access, Crowdfunding, Itch.io, Simulation, Godot EngineRings of Saturn, a hard sci-fi space simulation game made with the…

Starbound's massive 1.4 "Bounty Hunter" update is out now

Tags: Indie Game, Humble Store, GOG, Steam, Sandbox, SurvivalAfter a long wait, with this being the first update to Starbound since October last…

SkateBIRD has flown past the Kickstarter goal, Linux demo now available

Tags: Sports, Casual, Indie Game, Community, Crowdfunding, DemoGet ready to explore a bird-sized skatepark, as SkateBIRD has not only flown right…

Valve release a new stable Steam Client from all the recent Beta builds, nice fixes for Linux

Tags: Steam, UpdateValve have once again gathered all the new features and fixes from a bunch of recent Beta builds and pushed it out to everyone,…