Ashish Mishra comments

Results 6 comments of


                                            Ashish Mishra

Is there a way to specify quoted nature of input file ?

Thanks, wishlist is the right label :) As csv is text of printable characters, people use weird delimiters and quotes to prevent conflict with descriptive string fields. This would be...

Adding unsparsify by default for CSV output?

Not sure if this is solved but I hit this issue trying to reorder columns in a big csv where a number of columns may be blank. I found verb...

Adding unsparsify by default for CSV output?

I have been unable to reproduce it in small files, I will attempt to create a minimal example.

Adding unsparsify by default for CSV output?

echo "multiline-string" | mlr works. exporting condenses whitespace, but you can pass it through tr to replace space with '\n' Maybe use ; as line terminator to be safe then...

Is there a way to do a simple transposed view of csv ?

Thanks for answering. I need a simple rotate left /transpose for example , Input csv is 4 column and 5 rows, with h1..4 being headers h1 ,h2, h3, h4 r1v1,r1v2,r1v3,r1v4...

Is there a way to do a simple transposed view of csv ?

@johnkerl thanks. you forced me to write a one liner that I was resisting 👍 `$cat example.csv | python -c 'import sys,pandas; print((pandas.read_csv(sys.stdin)).transpose().to_string())'` ---------- Or couple of lines in my...