Category "csv"

How to use write.table to download a dataframe into a nice csv/Excel file?

I am trying to use the write.table() function, within Shiny downloadHandler(), to download the df reactive dataframe as a .csv file, per the reproducible code a

Convert large csv to hdf5

I have a 100M line csv file (actually many separate csv files) totaling 84GB. I need to convert it to a HDF5 file with a single float dataset. I used h5py in te

How do I read a large csv file with pandas?

I am trying to read a large csv file (aprox. 6 GB) in pandas and i am getting a memory error: MemoryError Traceback (most recent

How do I import a csv into chart.js?

I have been looking for this solution but can't seem to find it . Does chart.js support this ? I have attempted to parse in the data with papaparse, but due to

how to convert a CSV into JSON using Python Or Java. The csv is representation of a nested JSON (Containing array of json objects and nested objects)

I get a csv file like : attrib1_x , attrib1_y , attrib1_z_0_p , attrib1_z_0_c , attrib1_z_1_p , attrib1_z_1_c , attrib2_R , attrib2_K , attrib3 1 , 2 , 100 , 20

SSIS preserve trailing spaces in csv destination

I have a problem in SSIS, with a simple data flow task between a sql SELECT and a CSV destination. I don't retrieve trailing spaces in string columns of the des

How to convert SQLite database in android studio and then share it as csv file

Im making an app in which the users inserts values into a table (SQLite DB) and I want to make a share button which will share the the table as an excel file (.

Wordpress WebToffee alternatives

I am planning to use WordPress WebToffee plugin to setup my online WooCommerce site. The plugin however only supports CSV files. I can easily convert all of my

Single column to multiple columns with columns as heading and fill with binary values

Given column in the csv file labels ['N'] ['C'] ['D'] ['A'] ['D','C'] ['H'] ['D','G'] ['M'] ['O'] I want the labels a

Export members of multiple groups

Is it possible to change the PS script below in two ways: The group members are now exported horizontally but I want all the users in 1 cell in the column besid

(unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape [duplicate]

I'm trying to read a .csv file into Python (Spyder) but I keep getting an error. My code: import csv data = open("C:\Users\miche\Documents\s

How to fix “AttributeError: __enter__” when using csv.reader(open(..)..)?

I get the following error with my code: Traceback (most recent call last): File "C:\Users\XXX\Sentiment Analysis-vader.py", line 34, in <module> f.pri

How to add tags when uploading to S3 from pandas?

Pandas lets you pass an AWS S3 path directly to .to_csv() and .to_parquet(). There's a storage_options argument for passing S3 specific arguments. I would like

Python Pandas Error tokenizing data

I'm trying to use pandas to manipulate a .csv file but I get this error: pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in li

How to read a csv using sql

I would like to know how to read a csv file using sql. I would like to use group by and join other csv files together. How would i go about this in python. exa

EmptyDataError: No columns to parse from file

Currently I am getting the below Error and I am tried out the below posts: Solution 1 Solution 2 But I am not able to get the error resolved. My python code is

Combining 2 Tables, Want to keep all Non 0 Bit on DUPLICATE KEY

I have a table with 1000 columns (yes its normalized), that is storing Biiig Daaata! I need to Insert Update new data as it becomes available overnight, and f

Pandas dataframe read_csv on bad data

I want to read in a very large csv (cannot be opened in excel and edited easily) but somewhere around the 100,000th row, there is a row with one extra column ca

how do i sort data from a csv file numerically in python

I am writing a program that takes students scores from a csv file and needs to sort then highest to lowest score. the csv file looks like this: josh 12 john

how do i sort data from a csv file numerically in python

I am writing a program that takes students scores from a csv file and needs to sort then highest to lowest score. the csv file looks like this: josh 12 john