Skip to content

Tag: csv

Nice file parsing required

I need to process a file like this and I need to transform it to a dict : I don’t succeed in any fast and elegant way to deal Answer Let me first specify what I have understood from your requirement. You input is a csv file, with optionaly quoted fields: ok the csv module can parse it The first

Balance dataset using pandas

This is for a machine learning program. I am working with a dataset that has a csv which contains an id, for a .tif image in another directory, and a label, 1 or 0. There are 220,025 rows in the csv. I have loaded this csv as a pandas dataframe. Currently in the dataframe, there are 220,025 rows, with 130,908

Resampling timestamps in a CSV

I have a CSV file that stores data from different smartphone sensors. The timestamps are elapsed nanoseconds since the program to record the data was started. Short example: The time steps between the timestamps are not equal, but I would like them to be. My question is how to achieve this? I was thinking abo…

How to recognise different csv encodings?

I am not sure if it’s with the encoding itself however this is my problem; I would expect it to print this: However it does not recognise any of the Japanese characters and rather comes up with The encoding I used on the csv file was ISO2022. My question is, is there a way to make this appear properly? …

Convert timeseries csv in Python

I want to convert a CSV file of time-series data with multiple sensors. This is what the data currently looks like: The different sensors are described by numbers and have different numbers of axes. If a new activity is labeled, everything below belongs to this new label. The label is in the same column as th…

Split string with unexpected behaviour?

I am reading a csv file and I use a split on every line but I do not fully understand the behavior. csv file: code: This yields: but I expected the last line to be: Answer Use the delimiter arg to csv.reader to split on semicolons instead of commas:

Issue with writing CSV in Python

I am reading and XLSX file. and looping over the rows and colums to remove all the clutter from the excel. When I print full_data_row it prints the string with , so that is correct. When i check my csv file. I get this as an ouput: header1,header2,header3 O,p,z,e,t, ,h,o,s,t,e,d, Answer csvwriter.writerow() e…