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

LibreOffice 6.2.3 Office Suite Released with More Than 90 Bug Fixes

softpedia: LibreOffice 6.2.3 is here about a month after the release of LibreOffice 6.2.2 to add another layer of bug fixes and improvements

Install The Latest OpenJDK 12, 11 or 8 in Ubuntu, Debian or RHEL Using Zulu OpenJDK Builds

LinuxUprising: Azul Systems provides tested, certified builds of OpenJDK, under the name of Zulu.

Creating SWAP partition using FDISK & FALLOCATE commands

Swap-partition holds the memory which is used in case the physical memory (RAM) is full .

HTTPie - A Modern Command Line HTTP Client For Curl And Wget Alternative

2DayGeek: Learn how to use httpie tool to make CLI interaction with web services.

How To Remove Plank Shadow On Xubuntu?

Plank is a simple dock application that is widely used by Linux users.

How to Generate a Random Number in Linux

Learn how to generate a random number from the Linux command line.

Echo Command in Linux with Examples

 Linuxize: The echo command is one of the most basic and frequently used commands in Linux.

State of enterprise open source: 5 telling stats

EnterprisersProject: How are IT leaders using open source, and what are their future plans?

Minikube: 5 ways IT teams can use it

Minikube lets you run Kubernetes on a laptop or other local machine.

GamingOnLinux Latest Articles

DragonRuby Game Toolkit, a cross-platform way to make games with Ruby

Tags: Game Dev, ToolkitNow for something a little different! Ryan "Icculus" Gordon, a name known for many Linux ports and SDL2 teamed up with indie…

You Died but a Necromancer revived you is good fun in a small package

Tags: Indie Game, Casual, Steam, Itch.io, ReviewYou Died but a Necromancer revived you may not be a name that rolls off the tongue easily but it's…

Forager is a weirdly addictive casual grinding game that has mined into my heart

Tags: Humble Store, Steam, Adventure, Pixel Graphics, Casual, ReviewI'm not usually one for games that have you endlessly wander around, collect…

Altered, a sweet looking puzzle game where you're part of the puzzle is coming to Linux

Tags: Puzzle, Indie Game, Itch.io, Steam, Coming SoonReleasing sometime this Summer, Altered looks like a rather sweet take on the puzzle genre as…

Steam Play just got two updates with 4.2-3 and 3.16-9, some great stuff included

Tags: Steam Play, Valve, SteamValve and CodeWeavers are doing some great work for Linux gaming, with Steam Play seeing two updates in a single day.…

Sid Meier's Civilization VI updated again, Linux client back in sync for cross-platform play

Tags: Aspyr Media, Steam, Strategy, Humble StoreAspyr Media managed to get the latest update to Sid Meier's Civilization VI for Linux approved and…

Post-apocalyptic roguelite shooter 'Danger Gazers' enters Early Access next week, early thoughts

Tags: Action, Indie Game, Steam, Early Access, Coming SoonI'm honestly not quite sure what to make of Danger Gazers, a top-down roguelite shooter…

Valve released a stable Steam Client update yesterday, some nice fixes in for Linux and Steam Play

Tags: Steam, ValveValve are continuing their polishing effort to make the Steam Client work better, with a load of work from the recent Beta releases…

Silly physics platformer where you swing with your tongue 'Crumble' now has a Linux demo

Tags: Platformer, Indie Game, Steam, Demo, Itch.ioIn the 3D platformer Crumble, you play as a rolling ball with a smiley face and a loose tongue. It…

Rotation looks like a promising and unique top-down shooter coming to Linux

Tags: Action, Indie Game, Steam, Coming SoonI do love a good action-packed top-down shooter but a lot of them do end up feeling a little too similar,…

Two Point Hospital's Superbug Initiative brings a new challenge system, beta now available

Tags: Update, Beta, Simulation, Humble Store, SteamThe Superbug Initiative for Two Point Hospital sees players working together across the world, to…

Rocket League has a new Rocket Pass out with a Weekly Challenges system

Tags: Steam, Humble Store, Sports, UpdateIt seems developer Psyonix is taking more inspiration from Fortnite for Rocket League with their latest…

You can now easily run the Epic Store on Linux with Lutris, Epic suggests applying for a grant

Tags: Misc, Apps, Wine, Epic GamesThanks to some effort from the team behind Lutris (and Wine of course), you can now run the Epic Store quite easily…

King Arthur's Gold, the 2D multiplayer castle siege game is now free to play

Tags: Action, Indie Game, Steam, Free GameWith some silly physics and plenty of fun to be had, King Arthur's Gold has officially gone free to play…

Turn-based tactical RPG Fell Seal: Arbiter's Mark officially releasing April 30th

Tags: Strategy, RPG, Steam, Early AccessFell Seal: Arbiter's Mark from 6 Eyes Studio and 1C Entertainment is getting ready to release in full after…