Category "csv"

How to iterate sample users along with endpoint & payload while calling each API post request

Original question link: There are two functions: ReadInp() -> Dict[str, str] This reads a csv and returns a dict with a url as key and a payload as the value

Rails - a way to check the last line while using smarter_csv gem

I am using smarter_csv gem to parse a large CSV file on Heroku. SmarterCSV.process(file_name, { chunk_size: 10, headers_in_file: false, user_provided_headers: u

Need help creating schema for loading CSV into BigQuery

I am trying to load some CSV files into BigQuery from Google Cloud Storage and wrestling with schema generation. There is an auto-generate option but it is poor

How to read each cell of a column in csv and take each as input for jq in bash

I am trying to read each cell of CSV and treat it as an input for the JQ command. Below is my code: line.csv | Line | |:---- | | 11 | | 22 | | 33 | Cod

Map object not setting values after execution of function

I have a function below where the purpose is to parse multiple local csv files. For each parsed csv file, I then grab 1-5 random elements. Since the CSV parser

Find difference between a set of csv files in folder A compared to set of csv files in folder B

There are a number a files that need to be compared for differences in their rows; difference not as in subtraction but as in what values are different for each

How to Access Private Github Repo File (.csv) in Python using Pandas or Requests

I had to switch my public Github repository to private and cannot access files, not with access tokens that I was able to with the public Github repo. I can a

How does Pyarrow read_csv handle different file encodings?

I have a .dat file that I had been reading with pd.read_csv and always needed to use encoding="latin" for it to read properly / without error. When I use pyarr

How can I optimize this Powershell script, converting JSON to CSV?

I have a very large JSON Lines File with 4.000.000 Rows, and I need to convert several events from every row. The resulted CSV File contains 15.000.000 rows. Ho

output multiples row to csv python

New to python, so if this impossible sorry for time wasting.. I would like to get the full data set that is printed in console into to the csv when written out.

Extracting from CSV file knowing row and column number on command line

I have a CSV file and I want to extract the element in the first row and 3rd column. How might I go about doing this?

Converting tensorflow dataset to pandas dataframe

I am very new to the deep learning and computer vision. I want to do some face recognition project. For that I downloaded some images from Internet and converte

Convert JSON format column to new columns

I have a sub-Yelp Dataset in csv, and attributes column is in json format. I'm trying to convert that column to new columns, but none of the relevant code on di

Copy file from remote server to local machine in Postgres

I cannot figure out how I can copy a remote server file as a CSV file on my local machine (windows). I have tried \copy mytable TO 'C:/pg/mytable.csv' CSV DELIM

Download A File Generated Within An R Shiny App

I am currently trying to generate a Shiny App that at the press of a button generates and downloads data for a user. I have a user defined function that pulls d

How to join two tables using a comma-separated-list in the join field

I have two tables, categories and movies. In movies table I have a column categories. That column consists of the categories that movie fits in. The categories

How to read csv using column name in java

I have tried reading a column with its index using below code: int col1; String msg = null; int i = 0; String[] array = null; File file =

How to read csv using column name in java

I have tried reading a column with its index using below code: int col1; String msg = null; int i = 0; String[] array = null; File file =

XML to CSV with PHP converter [problem with images grabing]

I really need your help who works with XML and PHP. Looked for many other questions, but still nothing was found about my situation when in xml there is deeper

How to read csv from ftp using pandas? [duplicate]

I connected to a sftp and got a list of files successfully: ssh = paramiko.SSHClient() ssh.set_missing_host_key_policy( paramiko.AutoAddPolicy