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

Raccoon - APK Downloader for Linux, MacOS, and Windows

Raccoon is a free and modern open-source APK downloader application that enables you to safely download any Android app available on Google Play Store to your Linux, Windows, or Mac desktop.

How To Share Files Anonymously And Securely: Linux Alternatives to Google Drive

The ability to share files regardless of the physical distance and almost instantaneously is one of the greatest characteristics of the Internet.

Gogo - Create Shortcuts to Long and Complicated Paths in Linux

Gogo is an impressive way to bookmark directories inside your shell.

Western Digital's Long Trip from Open Standards to Open Source Chips

Western Digital, the company known to most as a seller of hard drives, has gone all-in on open source.

Dell Unveils New XPS 13 Developer Edition Ubuntu Laptop with 10th Gen Intel CPUs

As part of Dell's new consumer PC portfolio, the company also unveiled today a new generation of its acclaimed XPS 13 Developer Edition powered by Ubuntu Linux.

How To Find USB Device Bandwidth Usage On Linux

 ostechnix: Usbtop is a top-like CLI utility that helps us to find USB device bandwidth usage on Linux.

How to navigate Ansible documentation

Ansible's documentation can be daunting for beginner's. Here's a tour that might help.

Google's Chrome OS 76 Improves Support for Multiple Accounts on Chromebooks

Chrome OS 76's probably most exciting is a unified account management for those who use multiple Google accounts on their Chromebook

GamingOnLinux Latest Articles

Mable & The Wood is a fairly unusual Metroidvania out now with Linux support

Tags: Steam, New Release, Metroidvania, Action, Indie Game, AdventureFeaturing a sweet fairy-powered protagonist wielding a sword so big they can…

The stable Wine 4.0.2 release is now available

Tags: Wine, New ReleaseIf you prefer to walk on the calmer side of life, the Wine 4.0.2 release has been made available today. As it's just a…

Some more thoughts on Ion Fury, the FPS from Voidpoint and 3D Realms

Tags: Action, FPS, Steam, ReviewIon Fury (previously Ion Maiden) is true example of how you really don’t need to push graphics ever closer to…

Valve tease a new Dota 2 hero named Snapfire with an animated short

Tags: MOBA, Free Game, Valve, SteamSnapfire is the name and Dota 2 is the game! Valve have teased a new bad-ass female hero in a wild west themed…

Looks like the Smach Z handheld gaming unit is getting an upgrade

Tags: HardwareThe Smach Z team attended this year's Gamescom and is appears they're not done tweaking this gaming handheld. While all their current…

Space colony building sim Space Haven has a third Alpha release out now

Tags: Indie Game, Alpha, Early Access, Upcoming, Sandbox, Simulation, StrategySpace Haven from Bugbyte Ltd continues being shaped into something…

Neverwinter Nights: Enhanced Edition has a new DLC out with Tyrants of the Moonsea

Tags: RPG, Steam, DLC, New ReleaseLooking for your next adventure? Neverwinter Nights: Enhanced Edition just got even bigger with a new "premium…

Supergiant Games is turning ten years old, big sale on their games and HADES is heading to Steam

Tags: Steam, Itch.io, Game SaleSupergiant Games, the team behind hits like Bastion and Transistor are turning ten years old as a studio and so…

Dynasty Mode & Eight Princes DLC for THREE KINGDOMS out for Linux, plus a Total War sale

Tags: DLC, New Release, Feral Interactive, Game Sale, Steam, Humble StoreFeral Interactive announced earlier today that the Eight Princes DLC for…

Zombie apocalypse action RPG Zombasite has a big update and a big sale to match

Tags: Action, RPG, Humble Store, GOG, Steam, Game Sale, UpdateAhead of the upcoming full release of Din's Legacy, Soldak Entertainment aren't…

Things are about to get weird in the Two Point Hospital: Close Encounters expansion

Tags: DLC, Upcoming, Humble Store, Steam, Strategy, SimulationTwo Point Studios and SEGA just announced the next expansion for their amusing hospital…

Hello Games appear to be keeping an eye on Steam Play with No Man's Sky, temp fix needed for NVIDIA

Tags: Steam Play, Steam, HOWTONo Man's Sky recently had an absolutely ridiculous update to add in tons of new features and greatly expanded…

Little Red Dog Games announce Rogue State Revolution, a political thriller roguelike

Tags: Upcoming, Steam, Strategy, Simulation, Godot EngineLittle Red Dog Games (Precipice, Deep Sixed, Rogue State) have announced Rogue State…

Rocket Pass 4 is coming to Rocket League on August 28th, with a new rally-inspired Battle-Car

Tags: Steam, Update, SportsThe fourth Rocket Pass is due to arrive in Rocket League soon, along with the start of Competitive Season 12. For those of…

Roguelike Stay Safe: Labyrinth of the Mad now has a Linux beta, sounds quite unique

Tags: Roguelike, Indie Game, Steam, BetaStay Safe: Labyrinth of the Mad from Yellowcake Games is a roguelike with plenty of random generation,…