Category "csv"

Remove special character from a column in dataframe

I am trying to remove a special character (å) from a column in a dataframe. My data looks like: ClientID,PatientID AR0001å,DH_HL704221157198295_9

Remove special character from a column in dataframe

I am trying to remove a special character (å) from a column in a dataframe. My data looks like: ClientID,PatientID AR0001å,DH_HL704221157198295_9

Cannot convert the pdf file into the CSV file

I am a new python learner, I am struggling how to change the pdf file into CSV file by using Spyder. Input import tabula dfs = tabula.read_pdf(r'C:\Users\home\D

create multiple tab in CSV file through R

I have a query in R, for loading data into .xlsx multiple tabs we use below code write.xlsx(newtrain, file = 'path/file.xlsx', sheetName

BigQuery - loading CSV with newlines fail with Node.js, but works with gsutil

I'm trying to load CSV from Cloud Storage to Big Query with a Cloud Function. The file has newlines in some of the strings. When I load from Cloud Shell it load

MonetDB COPY INTO table "unexpected end of file"

I am loading a sizeable csv file (300GB) into a tables using COPY INTO statement. After a long waiting time, I am getting an "unexpected end of file" exception

Put a CSV file in a specific Sheet by Name

With this script I would to put the CSV in a specific Sheet named "TEST". I have tried with getSheetByName but without result. How could I proceed? function imp

Is it possible to read a csv file column by column with League csv?

I wondered if it was possible to read a csv file written like this in symfony using League csv or something else. water_level,2,456,345 wind_speed,2

What's the most robust way to efficiently parse CSV using awk?

The intent of this question is to provide a canonical answer. Given a CSV as might be generated by Excel or other tools with embedded newlines and/or double quo

How to speed up my SUPER SLOW search script

I am building a script to search for $name through a large batch of CSV files. These files can be as big as 67,000 KB. This is my script that I use to search th

Py4JJavaError when trying to write pyspark DataFrame to parquet

I wanted to convert a large .csv vile into .parquet format using pyspark. I am using python 3. I tried changing the codec used for compression, as suggested in

I'm trying to move a cube on the screen according to the data from a csvfile, but it's not working. Can someone help me with this code?

I'm trying to move a cube on the screen according to the data from a csvfile, but it's not working. Can someone help me with this code? using UnityEngine; pub

Convert NetCDF file to CSV or text using Python

I'm trying to convert a netCDF file to either a CSV or text file using Python. I have read this post but I am still missing a step (I'm new to Python). It's a d

Fastest way to read a CSV file java

I´ve been trying to read several csv files (arround 20 MB) using openCSV, but so far it has been slow. Im trying to read 4 csv files which I´m loadi

How to search for a 'text' or 'number' in a csv file with Python AND if exists print only first and second column values to a new csv file

I want to do the following using Python. Step-1: Read a specific third column on a csv file using Python. Step-2: Create a list with values got from step-1 Ste

CsvHelper mapping issue

I have a question related to CsvHelper library and I cannot figure out how to map a csv file to the following MyClass object. the csv file look like: id, Proper

Streamlit Panda Query Function Syntax Error When Finding Column in CSV Dataframe

When Using Streamlit to build a data interface getting a syntax error. My downloaded csv dataframe has a column 'NUMBER OF PERSONS INJURED', after converting i

How to check if a CSV has a header using Python?

I have a CSV file and I want to check if the first row has only strings in it (ie a header). I'm trying to avoid using any extras like pandas etc. I'm thinking

pandas read_csv() method supports zip archive reading but not to_csv() method supports zip archive saving

Pandas 0.18 supports read_csv zip file as argument and reading zipped csv table correctly into data frame. But when i am trying to use to_csv() method to save d

Powershell for creating folders and subfolders from csv

I try to prepare a script that will create folders and subfolders from CSV. When I create a CSV with 1 column 'Name' like so Name XYZ ZXX FFF with the follo