There are some minor problems with the recent answers:
1. using awk -F, fails when a cell contains a quoted cell with an
embedded comma
2. using pandas fails when the csv file is already flawed, panda throws
an long exception error
I cobbled together the csvlint program, trying to follow
Use Python and Pandas.
import pandas as pd
df = pd.read_csv('filename', sep=',')
print(df.head())
print(df.shape)
# then do a boat load more operations on your data
On Sat, May 20, 2023 at 5:37 PM American Citizen
wrote:
> Hello all:
>
> I am using the xsv program for most csv file operations
awk -F, '{ print NF }'
On Sat, May 20, 2023, 20:37 American Citizen
wrote:
> Hello all:
>
> I am using the xsv program for most csv file operations since it is
> quite fast.
>
> There is one command which I wish it had, called "length" which would
> give the fields per record (delineated by a
Hello all:
I am using the xsv program for most csv file operations since it is
quite fast.
There is one command which I wish it had, called "length" which would
give the fields per record (delineated by a line-feed or new line)
awk or gawk does have NF variable and I can use this to verify
Anyone running the latest ZM and Ubuntu server? I just
did the update of the whole thing. All seems to be working
except that ZMNinja only shows of the 10 cameras I have
on the system. If I open the [monitors] section it shows all
of the cameras but the ones not showing up have a bar
through them.