Category "csv"

Is there a way to download and import multiple .tsv files into excel or access?

I am trying to create a database from SEC filings. The filings come in .tsv files and are structured in folders by year and quarter. Ever folder contains about

CSV file with non-English characters error in postman and angular http request

I have uploaded a CSV file with some german words. I can access the file via this link . When I try to get the file via postman, the response is not fully utf

Problem to convert act format to CSV a bytes-like object is required, not 'str'

I have a problem converting an .act file to csv format. I am using this code: import struct import csv DATA = [] with open("modis_lst.act", "rb") as actFile:

custom method for voting bewtween multiple csv files

I have 3 (or more) Dataframes with this structure: ID Percentage 00001 3 00002 15 00003 73 00004 90 ... ... each csv have unique predicted percentage values a

convert csv to netcdf in Python

Hi I have a CSV file that is for several monitoring stations that have measured isotope data repeatedly over a period of time. Country Latitude Longitude

What is the maximum character count that can be stored in a csv column?

I'm saving a large list (list of strings/paragraphs) in a csv's column. I can see some that for some rows, where the data is supposed to be huge, the column is

Print REGEX using USER DEFINED FUNCTION

I'm trying to print the variables ccb_3, nome, data, taxa and parcela using the function I defined as "ext_ccb", but when I run the code it returns 3 times (bec

pandas read_csv throwing ValueError: Invalid file path or buffer object type: <class 'list'>

I want to read a csv file sent as a command line argument. Thought I could directly use FileType object of argsprase but I'm getting errors. from argparse impor

Read .csv file in R

I am a beginner to R, I have a file like below. state population Alabama 4779736 Alaska 710231 Arizona 6392017

Spark read csv option to escape delimiter

Have an input csv like the one below, Need to escape the delimiter within one of the columns (2nd column): f1|f2|f3 v1|v2\|2|v3 x1|x2\|2|x3 spark.read.option(

Using read_excel to upload and automatically name all existing workbook sheets (without specifying the number of sheets)

I would like to adapt the answer below, taken from this question. # Example data write.xlsx(mtcars, "mt cars.xlsx") write.xlsx(mtcars, "mt car s.xlsx") temp =

In Java, how do you deal with double quote inside of a CSV that you need to parse

here is what I want to do, This my spend.csv file : "Date","Description","Detail","Amount" "5/03/21","Cinema","Batman","7.90" "15/02/20","Groceries","Potatoes",

Plotting CSV data on a map in Python

I have to plot data from 1200 isotopic measuring stations (worldwide) in a map for a thesis. For this I have downloaded them in a CSV file. Afterwards I have di

Upload large csv file to cloud storage using Python

Hi I am trying to upload a large csv file but I am getting the below error: HTTPSConnectionPool(host='storage.googleapis.com', port=443): Max retries exceeded w

How to read a csv file with commas in field with pandas python?

Hi I have a csv file with items like this product_id,url 100,https://url/p/Cimory-Yogurt-Squeeze-Original-120-g-745133 "1000,""https://url/p/OREO-Biskuit-Dark-

ASP.NET download csv file as zip?

I've been reading through: https://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-CSV-file-in-ASPNet-using-C-and-VBNet.aspx Rather than only have t

Plot histogram from two columns of csv using pandas

I have a csv file containing two columns. What I'd like to do is to plot a histogram based on these two columns. My code is as follows: data = pd.read_csv('data

Grouping duplicates in CSV file and ranking data based on certain values

I have a CSV file like so - "user_id","age","liked_ad","location" 2145,34,true,USA 6786,25,true,UK 9025,21,false,USA 1145,40,false,UK The csv file goes on. I

How to capture the field values in the csv file using bufferedreader

The csv file looks like this I'm trying to get the field values like name, it is the value after $$NAME$$ (there is a space after the identifier). How do I st

Zipping a list of folders with Python

everyone. I'm really new to Python, so I need some help here. I have a list of folders names inside a .CSV file. All these folders are inside the same path. I n