Category "csv"

Query (SQL like joins) remote CSV for data analysis

I would like to query (SQL with joins) CSV files sitting in a network folder for performing data analysis work. I'm not allowed to move the files out of the net

Sklearn can't convert string to float

I'm using Sklearn as a machine learning tool, but every time I run my code, it gives this error: Traceback (most recent call last): File "C:\Users\FakeUserMad

UnicodeDecodeError: 'utf-8' codec can't decode byte 0x96 in position 35: invalid start byte

I am new to Python, I am trying to read csv file using below script. Past=pd.read_csv("C:/Users/Admin/Desktop/Python/Past.csv",encoding='utf-8') But, getting

R: unzipping large compressed .csv yields "zip file is corrupt" warning

I am downloading a 78MB zip file from the UN FAO, which contains a 2.66GB csv. I am able to unzip the the downloaded file from a folder using winzip, but have b

Add Glossary to Google translte V3 API by python

I am trying to add a glossary by CSV. I put the CSV on my google storage. I got this Error: google.api_core.exceptions.InvalidArgument: 400 Failed to parse cont

Copy Data from CSV file to Sqlite file in Android

I want to copy the data from CSV file to SQLite file for my android application.SQLite table structure i.e. the columns are different than the CSV file columns.

Filter rows in csv file based on another csv file and save the filtered data in a new file

Good day all so I was trying to filter file2 based on file1, where file1 is a subset from file2. But file2 has a description column that I need to be able to an

Saving as CSV through google script handling newline characters

So I'm attempting to take a sheet from a Google Spreadsheet and save it as a .CSV file just like you can manually do. It is working fairly well, but I've ran in

Looking for a clean way to export data to a CSV that is previously used in a different controller route that renders a Form/DB query

I have a page that has a form that generates a query that renders relevant information from my database: Render Example The controller function I use creates th

Automated MD5 and Hex Encoding of Spreadsheet Columns

I am receiving a CSV file, and in that file I need to Hex Encode one column, and MD5 Hash another column. Final Outcome I am looking for is to take an incomin

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