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

Install and Use The Signal Encrypted Messenger App

Linuxconfig: Do you wish there was a more secure option for sending text messages and even making calls from your phone?

Valve may be adding support for using compatibility tools for playing games on different operating systems

GamingOnLinux: Valve might be adding support for compatibility tools to enable you to play games on operating systems they weren't designed for, like Wine.

How to Disable SELinux on CentOS 7

SELinux (Security Enhanced Linux) is a Linux kernel security module that allows administrators and users more control over access controls.

Three More Intel Chip Exploits Surface

itprotoday: Not that we needed it, but there's more evidence today that Intel has been playing fast and loose with security in order to stay ahead of the fast-chip competition.

How to display data in a human-friendly way on Linux

NetworkWorld: Many Linux commands now have options to make their output a little easier to digest.

How to Schedule Tasks on Ubuntu 18.04 Using Crontab

Learn how to run programs at a specific time or in a given interval on Ubuntu by using the crontab

How to Install Prometheus and node_exporter on CentOS 7

Prometheus is an open source monitoring system that allows you to collect metrics from any configured target system.

How to limit CPU usage with CPULimit on Ubuntu Linux

 Learn how to limit CPU usage in Ubuntu 18.04 LTS.

How To Install Asterisk on CentOS 7

Asterisk is the most popular and widely adopted open source PBX platform that powers IP PBX systems, conference servers and VoIP gateways.

GamingOnLinux Latest Articles

NVIDIA are working towards better support for NVIDIA Optimus on Linux

Tags: NVIDIA, DriversThanks to a little Twitter tip, we've learned today that NVIDIA are indeed working to provide better support for NVIDIA Optimus…

CnCNet are providing Red Alert & Tiberian Sun with an updated renderer using OpenGL for better Wine support

Tags: Wine, Free GameA little different to what OpenRA [Official Site] are doing with updated gameplay on an open source game engine, CnCNet…

Boyfriend Dungeon, an action-RPG dungeon crawler where the weapons transform into people is on Kickstarter

Tags: Indie Game, Dungeon Crawler, Action, RPG, CrowdfundingBoyfriend Dungeon [Official Site] from Kitfox Games (Moon Hunters) promises a rather…

Graveyard Keeper from Lazy Bear Games and tinyBuild is out with same-day Linux support

Tags: Humble Store, GOG, Steam, RPG, AdventureGraveyard Keeper is a slightly amusing game that has you manage a medieval graveyard while facing…

Daedalic Entertainment's futuristic thriller 'State of Mind' is out with day-1 Linux support

Tags: Humble Store, GOG, Steam, Adventure, Indie Game, Cyberpunk, Unreal EngineGood stuff from Daedalic Entertainment here as they've released State…

Crazy Justice to finally enter Early Access with Linux support on August 23rd

Tags: Action, Battle Royale, Steam, Indie Game, Early Access, Unreal Engine, Free GameCrazy Justice [Steam, Official Site], the third-person shooter…

First-person grappling-hook platformer 'The Free Ones' is out with Linux support, it's pretty good

Tags: Platformer, Steam, Indie Game, Review, AdventureThe Free Ones is a first-person platformer that sees a slave escape from captivity and it's out…

Top-down 3D action-adventure game Sikanda gives you a shape-shifting weapon

Tags: Action, Adventure, Crowdfunding, Indie GameSikanda seems like a pretty interesting top-down action-adventure, one that gives you a…

Time Traveling Raptors is a 16-bit inspired action-platformer where you're trying to fix the timeline

Tags: Crowdfunding, Indie Game, Action, PlatformerTime Traveling Raptors looks all kinds of nuts, an action-platformer where you're facing people as…

Prepare to set sail as seafaring strategy game 'Nantucket' is now officially supported on Linux

Tags: Strategy, Steam, Humble Store, Indie GameAfter being in Beta since April, Picaresque Studio have now given the Linux version of the seafaring…

Isometric university management game 'UniverCity' has entered Early Access, developed on Linux

Tags: Steam, Indie Game, Early Access, SimulationUniverCity from developer Matthew Collins who develops on Linux is a new in-development university…

The Humble Jackbox Party Bundle is out, some of their games have hidden Linux beta versions

Tags: Humble Store, Game Bundle, BetaA quick tip for those who love their party games as Humble have put out the The Humble Jackbox Party Bundle. To…

Valve may be adding support for using compatibility tools for playing games on different operating systems

Tags: Valve, SteamReddit seems to be buzzing with information from SteamDB (full credit to them for finding it) showing indications that Valve…

The Linux version of Moonlighter should be out soon, in the 'last stage'

Tags: Coming Soon, Action, RPG, Rogue-lite, UnityThe action RPG Moonlighter [Official Site] seemed really interesting with the shopkeeper element to…

TANGLEWOOD is a properly retro puzzle-platformer that's now out for Linux, includes a Mega Drive rom file

Tags: Puzzle, Retro, Platformer, Steam, Indie GameBig Evil Corporation have released their puzzle-platformer that really is rather retro and not just…