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

How to build a WiFi picture frame with a Raspberry Pi

Use a Raspberry Pi to DIY a digital photo frame that streams photos from the cloud.

Six years ago Steam was released for Linux - Happy Birthday

Happy official birthday to the Steam client for Linux

Ethical Hacking, Ubuntu-Based BackBox Linux Is Now Available on AWS

The BackBox Linux operating system promises to offer Amazon Web Services users an optimal environment for professional penetration testing operations

How to Flush DNS Cache on Ubuntu 18.04 LTS

The following guide shows you how to Flush the DNS Cache in Ubuntu 18.04

6 Ways to Open Folders in Ubuntu 18.04 LTS

Opening folders in Ubuntu is one of the basic tasks you will perform as a regular Ubuntu user.

How To Change HostName In Linux?

2DayGeek: Simple methods to change hostname in Linux.

Run Particular Commands Without Sudo Password In Linux

ostechnix: This brief tutorial describes how to run particular commands without sudo password in Unix-like operating systems.

Load Testing Web Servers with Siege Benchmarking Tool

Knowing how much traffic your web server can handle when under stress is essential for planning future grow of your website or application.

Some pretty useful YUM tips & tricks

Yum is the default package manager for RPM packages on RHEL & CentOS.

GamingOnLinux Latest Articles

Ravenfield, the single-player FPS with large-scale battles has a new release out

Tags: FPS, Early Access, Action, Indie Game, Unity, SteamMore FPS news for you this weekend, with the single-player Ravenfield having another great…

The unique FPS 'Shotgun Farmers' is leaving Early Access next month

Tags: Action, Indie Game, Unity, FPS, Steam, Early AccessShotgun Farmers, by far one of the most unique FPS games I've played in a long time is due…

The first Steam Play update for this year is out with Proton 3.16-7 beta

Tags: Steam Play, Valve, Steam, BetaValve have pushed out a Steam Play beta update with Proton 3.16-7 now available for testing. Lots of fixes! Not…

Wine 4.2 is officially out with plenty of game fixes

Tags: WineThe Wine team are having a busy year once again, with the second development release for Wine 5.0 out as the bottle for Wine 4.2 is now…

A look at what games and bundles are on sale ahead of the weekend

Tags: Game Sale, Game BundleAh yes, another weekend is about to crash into our lives and so you're looking for a new game to sink some hours into.…

Dungeons 3 has a new unexpected DLC out today, adding in another campaign

Tags: Strategy, DLC, Steam, Humble Store, GOGI have to hand it to Realmforge Studios and Kalypso Media Digital, they've supported Dungeons 3…

The 2D beat 'em up 'Tunche' is another game funded on Kickstarter and heading to Linux

Tags: Beat 'em up, Crowdfunding, Indie Game, Coming SoonAnother bit of positive crowdfunding news for you today, as Tunche, the 2D beat 'em up with…

Forgiveness, a new escape room style puzzle game is coming to Linux this month

Tags: Coming Soon, Indie Game, Puzzle, SteamWith themes based around the seven deadly sins with psychological-horror vibes, Forgiveness, a new escape…

Eastshade, the peaceful open-world exploration game is still coming to Linux

Tags: Coming Soon, Delayed, Steam, Indie Game, Open World, Exploration, Itch.ioWhile the Linux version of Eastshade sadly didn't arrive at release,…

Apparently Valve are working with Easy Anti-Cheat to get support in Steam Play (updated: yup)

Tags: Valve, Steam, Steam Play, WineUpdate: Turns out, this is true. As a Valve developer did reply to a user on the VKx Discord to say "they're…

Fancy working on Wine to help push Steam Play? CodeWeavers are hiring

Tags: Wine, Steam Play, JobsCodeWeavers, the company that supports Wine development that's working with Valve on Steam Play are looking to recruit…

Littlewood, the peaceful building RPG has been fully funded and it's on the way to Linux

Tags: Crowdfunding, Indie Game, Coming Soon, RPGUnlike a lot of RPGs, Littlewood actually takes place after all the action has been done. It's your…

Sid Meier's Civilization VI: Gathering Storm is out with Linux support as expected

Tags: Strategy, DLC, Aspyr Media, Humble Store, SteamSid Meier's Civilization VI: Gathering Storm, the massive new expansion has arrived and as…

Game porter and Steam Play dev Ethan Lee is running a crowdfunding campaign

Tags: CrowdfundingNintendo's USB GameCube adapter for the Wii U and Switch could soon work on Linux, Mac and Windows if this crowdfunding campaign…

We. The Revolution, a unique looking strategy game set during the French Revolution will be on Linux

Tags: Strategy, Coming Soon, GOG, SteamFor those after a strategy game that certainly looks unique, We. The Revolution is bringing the blood-soaked…