Category "csv"

Write data in CSV with Java

I'm trying to write data in a new CSV generated automatically after reading and extracting my data. However, always write one record only and it hasn't got the

Import and Edit a CSV file with validation rules

I am very new to Python / coding in general so excuse me if this is a simple question I'm just struggling to find an answer. I have been tasked to create a very

Check if a value in a list exist in a column and if not, write the non existing value to the next column

I have a csv file containing metadata exported from a pst e.g from, to, cc, bcc. I have a list i can query: \*\*my list \*\* Wayne, John little, Joe I have mul

How to find the frequency of words in a list created from a .csv file

I am trying to write a program that first reads in the name of an input file and then reads the file using the csv.reader() method. The file contains a list of

unrecognized character in header of csv

import csv def readCSV(filename, begin_date="01/07/2020", end_date="30/09/2020"): file = open(filename) csvreader = csv.reader(file) header = []

Reading numbers from array in javascript and plotting these using plotly

I'm trying to make an interface that lets a user upload CSV files and plots these using plotly, only using javascript and obviously the plotly library. I'm clos

CSV to PHP class properties

I'm working on an assignment right now, and I'm trying to take the data from a CSV and make them into class objects. So each item in the CSV row needs to be a c

Can I read other than the first sheet with the Read Delimited Spreadsheet.vi function in LabVIEW?

I am using Read Delimited Spreadsheet.vi in LabVIEW and need to read data from other than the first sheet. How do I tell LabVIEW that want to use other than the

Split a row in a csv file into multiple rows using powershell

this is my first post on this website so please be gentle :) (Also a powershell noob) I have received a .csv file and a .txt file. My job is to input data from

Export folder size to CSV

I'm putting together a script that will import a CSV with a list of folder names (and other fields) to get folder sizes (in this case SamAccountName matches the

COUNTIFS: Excel to pandas and remove counted elements

I have a COUNTIFS equation in excel (COUNTIFS($A$2:$A$6, "<=" & $C4))-SUM(D$2:D3) where A2toA6 is my_list. C4 is current 'bin' with the condition and D*

Join large set of CSV files where the header is the timestamp for the file

I have a large set of CSV files. Approx. 15 000 files. And would like to figure out how to join them together as one file for data processing. Each file is in a

Azure Data Studio set tab as delimiter when exporting a csv

in Azure Data Studio there's a setting called queryEditor.results.saveAsCsv.delimiter that allows the user to choose the default delimiter when exporting query

How can I avoid warnings when importing numbers by replacing comma's with a dot in a MySQL table?

I have a table in Mysql that looks like: CREATE TABLE `overig`.`test`( `ID` INT(10) AUTO_INCREMENT, `Order_ID` DECIMAL(10) NOT NULL, `Price_total` DECIMAL(12,2)

Trying to export tickets/incidents from SCSM to csv file using powershell

I am trying to do a simple ticket/incident file export using PowerShell. All of our tickets go into the Service manager 2019 Console. What I am trying to do is

opencv video window not opening though sucess true and camera opens wbut no video window

Can somebody help me with finding error on the below code? I am working on tutorial Face Detect Attendance system python opencv but cv fails to load camera....

How to save feature values extracted from images in csv format using python?

I have extracted some features from images and now I want to save these values in csv file. I have searched some links like (When using OpenCV's 2D feature dete

Comparing 2 columns with different rows in different csv files, and output status to another csv file

I have 2 csv files as shown below. They contain different numbers of rows and the columns are not aligned/sorted along a common index. I need to compare the col

Javascript encodeURI not work well with csv

I'm trying generate short CSV by the code bellow : Source const csv_content = `"Hello"þ"World"þ"#"þ"123"`; const href = 'data:attachment/csv;c

Combine PowerShell Defender outlets into a combined CSV file for monitoring

We cancelled our antivirus software (Kaspersky Anti-Virus, duh) and depend on the Windows Defender in the meantime. We won’t be getting any SIEM server to