Miller book has a heading awk-like features: mlr filter and mlr put. This answer is a good example.

+1 and thanks @Kusalananda

@Kusalananda Hello

@PrabhjotSingh Hi there! I'm focusing elsewhere tonight so I might be able to respond quickly. I hope you're doing well.

@Kusalananda I'm better now.

I just wanted to tell you that I taken paste command from your answer. I added that command in my answer.

This question

I not only copied your paste command but every step in that question.

@PrabhjotSingh Oh, that's perfectly fine! But why did you delete your answer?

I hope you don't mind. And didn't mind when I pinged.

@PrabhjotSingh No worries what so ever!

@Kusalananda I think a != "" is not valid in sqlite.

Thanks to you.

It is, as far as I know. Does the code work? I haven't tested it. I don't remember if empty values are inserted as empty strings or as NULLs when you're using csvsql..

If it doesn't work with a != "", then try with a IS NOT NULL.

... or whatever the correct wording is.

This is working fine with IS NOT NULL. I've undeleted it.

Thanks Kusalananda.

@PrabhjotSingh Great!

My current installation of csvkit has some sort of issue with the sqlite backend, so I can't use csvsql to do things like that at the moment.

The thing you may want to do is to explain the code a bit... :-)