/dev/chat

« first day (4005 days earlier) ← previous day next day → last day (954 days later) »

polemon

10:52 AM

@MichaelHomer Do you mean the books that are read on youtube by Tom Foolery?

terdon

11:13 AM

Swallows and Amazons

Swallows and Amazons is a children's adventure novel by English author Arthur Ransome and first published on 21 July 1930 by Jonathan Cape. Set in the summer of 1929 in the Lake District, the book introduces the main characters of John, Susan, Titty and Roger Walker (Swallows); as well as their mother, Mary; and their baby sister, Bridget (nicknamed Vicky). We also meet Nancy and Peggy Blackett (Amazons); their uncle Jim (James Turner), commonly referred to as Captain Flint; and their widowed mother, Molly Blackett. It is the first book in the Swallows and Amazons series, followed by Swallowdale...

1 hour later…

terdon

12:25 PM

@PrabhjotSingh no need to delete! Just fix it so that you can get the output the OP shows in their question. Something like this would do it (using the original example files):

 csvjoin -H -d ' ' -c 2,1 file2 file1 | tr ',' ' ' | tail -n+2

Prabhjot Singh

@terdon I'm trying to fix this. But this doesn't work.

```

/usr/lib/python3/dist-packages/agate/table/from_csv.py:88: RuntimeWarning: Column names not specified. "('a',)" will be used as names.
/usr/lib/python3/dist-packages/agate/table/from_csv.py:88: RuntimeWarning: Column names not specified. "('a',)" will be used as names.

```

mlr --opprint --fs space join -j x -f file{1,2} This command too works on files with headers only.

Thanks for putting your time into this.

terdon

12:44 PM

@PrabhjotSingh Yeah, I can't avoid the error messages either. But it works, regardless:

$ csvjoin -H -d ' ' -c 2,1 file2 file1 | tr ',' ' ' | tail -n+2
/usr/lib/python3.9/site-packages/agate/table/from_csv.py:72: RuntimeWarning: Error sniffing CSV dialect: Could not determine delimiter
333 ttt
444 kkk

You just need to ignore the error.

Prabhjot Singh

@terdon But I'm getting only error lines.

terdon

Ah, have you added headers? I'm using the example files from the OP:

terdon@tpad foo $ cat file1
abc
123
ttt
kkk
terdon@tpad foo $ cat file2
111 wed
222 kad
333 ttt
444 kkk

Prabhjot Singh

@terdon Still same output. Nothing after error.

terdon

Weird. The OP had some spaces at the end of the line (likely a copy paste error) and that can also cause issues, but you'd get a different error:

$ csvjoin -H -d ' ' -c 2,1 file2 file1 | tr ',' ' ' | tail -n+2
/usr/lib/python3.9/site-packages/agate/table/from_csv.py:72: RuntimeWarning: Error sniffing CSV dialect: Could not determine delimiter
ValueError: Row 2 has 19 values, but Table only has 9 columns.

What command are you using? What values are you passing to -c?

Prabhjot Singh

1:00 PM

@terdon The files and commands:

ilkkachu

@terdon, please remove the messages under my name from this chatroom: https://chat.stackexchange.com/rooms/129999/discussion-on-answer-by-ilkkachu-how-can-i-transliterate-some-characters-1-to-1
I have posted them as comments, which are supposed to be transient, and which should be deletable at any time. As chat messages, they're no longer deletable.

Prabhjot Singh

```

mc@mc:~/mashdata$ awk '1{print }' file{5,7}
abc
123
ttt
kkk
111 wed
222 kad
333 ttt
444 kkk
mc@mc:~/mashdata$ csvjoin -H -d ' ' -c 2,1 file{5,7}
/usr/lib/python3/dist-packages/agate/table/from_csv.py:88: RuntimeWarning: Column names not specified. "('a',)" will be used as names.
/usr/lib/python3/dist-packages/agate/table/from_csv.py:88: RuntimeWarning: Column names not specified. "('a', 'b')" will be used as names.
Column 1 is invalid. The last column is 'a' at index 0.

@terdon My mistake. This should be csvjoin -H -d ' ' -c 2,1 file{7,5}.

terdon

@ilkkachu I made a room for us.

@PrabhjotSingh It works for me with file{7,5} and gives me your error message with file{5,7}

Prabhjot Singh

1:49 PM

@terdon Undeleted. Thank you.

terdon

@PrabhjotSingh Yay! Have an upvote!

5 hours later…

jesse_b

6:30 PM

I remember apache being easier to use :/

Faheem Mitha

@jesse_b Cryptic.

jesse_b

exactly

jesse_b

6:46 PM

I'm sure it's not that bad I just want to run this simple site so I don't feel like reading about apache configs for an hour. I remembered it being much more simple the last time I did something like this

Faheem Mitha

@jesse_b I don't think it's that complicated. But it's easy to overlook the obvious, I find.

And personally, I have a hard time understanding documentation. I'm constantly misreading it.

2 hours later…