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

Is WINE Linux Enterprise Friendly?

Datamation: The WINE software can useful, but faces some key challenges for a long term approach.

How to upgrade Debian 8 (Jessie) to 9 (Stretch) safely

 HowToForge: This tutorial shows you how to upgrade your Debian system from Debian Jessie (8) to Debian Stretch (9) in a few simple steps.

How to Block USB Storage Devices in Linux Servers

 Do you know how to block access to USB in Linux? (if you don't you should learn..)

How technology changes the rules for doing agile

EnterprisersProject: Scaling DevOps from small group to large organization is hard.

Bug Bounty Hackers Make More Money Than Average Salaries, Report Finds

eWEEK: Why do individuals spend time going after bug bounties? HackerOne report reveals what ethical hackers are going after and why.

20 Years of LWN

Congratulations to LWN on an amazing milestone.

How To Install Themes Or Icons In Elementary OS

After installing Elementary OS, you may feel that you want to customize it to look more than Out-of-the-box system

Barcelona Opts for Breath of Open Source Fresh Air

LinuxInsider: Barcelona city officials have voted to shut the door on Microsoft Windows in favor of the Linux operating system and open source technology.

NHS: Thanks for the free work, Linux nerds, now face our trademark cops

The Register: Devs quit, suggest Britain's health service bosses used them to bag Microsoft deal

GamingOnLinux Latest Articles

We Happy Few delayed again until 'Summer 2018', refunds will be possible

Tags: Coming Soon, Steam, GOG, Open WorldIn the latest production update to We Happy Few [Official Site], the developers note it will have another…

DECEIVER is a cyberpunk pre-apocalyptic philosophical shooter that's heading to Linux

Tags: Open Source, Action, Coming Soon, Indie GameDECEIVER [Official Site] is a cyberpunk pre-apocalyptic philosophical shooter with parkour and…

Looks like first-person steampunk dungeon crawler 'Vaporum' is coming to Linux

Tags: Steam, Indie Game, Dungeon Crawler, RPGThe first-person steampunk dungeon crawler Vaporum [Official Site] is showing signs of being released…

OBS Studio 21.0.1 released with Luajit/Python3 scripting support and plenty more

Tags: Open SourceOBS Studio 21.0.1 [Official Site] is a pretty big release and it sounds really quite exciting too, with the possibilities that come…

Looks like a Linux beta of Battle Chasers: Nightwar is finally coming

Tags: Steam, Coming Soon, Beta, Action, RPGBattle Chasers: Nightwar [Official Site] was supposed to released for Linux back in October last year, but…

OBS Studio NDI Plugin for Linux, send video from one Linux PC to another

Tags: Editorial, HOWTOTwo PC streaming has usually required either a dedicated capture card or setting up finicky RTMP servers, and while setting up…

The Linux 2017 GOTY Awards are now over, here's the winners

Tags: GOTYAnother year has completely flown by and with that another year of our GOTY Awards comes to a close, here's the results of the Linux 2017…

Where The Water Tastes Like Wine is confirmed for same-day Linux support

Tags: Steam, Coming Soon, AdventureRecently I wrote about how the adventure game Where The Water Tastes Like Wine [Steam, Official Site] would…

Tangledeep, the rather pretty dungeon crawler is leaving Early Access next month

Tags: Roguelike, Steam, GOG, Indie Game, Dungeon CrawlerTangledeep [Steam, GOG, Official Site] is a game we haven't covered a lot here, even though…

Eco, a detailed sandbox simulation game is launching on Steam Early Access soon

Tags: Sandbox, Survival, Simulation, Indie Game, Steam, Coming SoonEco [Official Site] is a hard game to properly describe, it's a detailed sandbox…

Cattle and Crops, a farming simulation and management game that has Linux support

Tags: Early Access, Simulation, Indie GameNeed your farming fix? Cattle and Crops [Official Site] is an in-development farming simulation and…

PLAY WITH ME, a mixture of horror and puzzles inspired by the SAW movies should come to Linux

Tags: Horror, Puzzle, Steam, Indie GameThe developer of PLAY WITH ME [Steam, Official Site], a horror and puzzle game inspired by the SAW movies is…

It's possible 'Two Point Hospital' from Two Point Studios & SEGA may be coming to Linux

Tags: Steam, SimulationTwo Point Hospital [Official Site, Steam], a new hospital building and management sim from Two Point Studios & SEGA might…

Friday Livestream with Samsai at 6 PM UTC!

Tags: LivestreamHello there, potential viewer! I am here to notify you that you have a one-time opportunity* to participate in an adventure unlike…

FPS 'Interstellar Marines' is still alive and updated, finally fixes their Wargames mode timer on Linux

Tags: Action, FPS, Indie Game, Early AccessInterstellar Marines [Steam] was one of the most promising FPS games in a long time, until they basically…