Category "csv"

Convert text file into dataframe with custom multiple delimiter in python

i'am new to python. I have one txt file. it contains some data like 0: 480x640 2 persons, 1 cat, 1 clock, 1: 480x640 2 persons, 1 chair, Done. date (0.635s) Tue

how to use Google Cloud Translate API for translating bulk data?

I have a csv file of several thousands of rows in multiple languages and I am thinking of using google cloud translate API to translate foreign language text in

Renaming Multiple Printers "Rename-Printer"

Having trouble with trying to import a .csv or .txt with multiple printer names (shown below). Running this locally on a server to change printer names in a lis

Pentaho : Get Rowcount from a gz csv file

I need to find number of rows present in csv file but the csv file is compressed into gz format. I used "Get Files Row Count" but the rowcount value is wrong. I

Why is are my rows not being written to the CSV file?

With the code below the CSV file aaab.csv is created but nothing is written to it. The print(row) gives me the correct information. What am I doing wrong? I hav

Writing charcters in the csv files instead of writing the sentence

I want to save my data in the CSV format, I have some sentences and I want to save every sentence in a different row, but the output is like this: This is my c

Refreshing data from csv in python using pandas

I'm new to python and trying to learn it on the go, i'm tring to make a data entry phonebook using python with pandas. There is the code I wrote: import pandas

Python: I have a list of dictionaries but when I try to call a specific Key and Value it is throwing a error

def readParksFile(fileName="national_parks(1).csv"): nationalParks = open(fileName) headers = nationalParks.readline() keys = headers.split(",")

Merging CSVs into one sees exponentially bigger size

I have 600 CSV files of size ~1Mo for a total of roughly 600Mo. I want to put all of them into a sqlite3 db. So my first step would be to merge them into one bi

How to Export formatted CSV data to file?

I have a python script that parses/prints all the urls from an xml file to csv format. It does this, but it doesn't create an actual csv file. How do I turn thi

How to Export formatted CSV data to file?

I have a python script that parses/prints all the urls from an xml file to csv format. It does this, but it doesn't create an actual csv file. How do I turn thi

why didn't my program write some of the fields?

So I wrote a program to write the different attributes like title, total number of comments, total upvotes, post body, author name of submissions in a CSV file.

Send csv file in pytest test using restframework ApiClient

I'm trying to test my view which requires csv_file and one parameter in request, but getting error "details": {"csv_file": ["The submitted data was not a file.

R Studio keeps crashing when I'm trying to merge multiple csv files into a data frame. How do I fix this?

I have 12 csv files that I need to merge for analysis project and their size ranges from 20mb to 120mb per file. I attempted cutting down to only using the nece

Problem by using for loop when loading data series from .csv file and save them as array matrix for every columns loaded

I want to load a series of data from 6 CSV files and save them per column of the data series. As I call the Column_A, Column_B and new_Column_A, only the last o

What could be wrong with a Pandas DataFrame?

I couldn't make head or tail of this: I have a function that reads a bunch of csv files from a S3 bucket, concats them and returns the DataFrame: def create_df(

How to save JSON to CSV?

I am trying to use a raw data output from mixpanel API and save all events to a .csv. Mixpanel gives me the following data as <class 'str'>: {"event":"Te

Windows Powershell: How to compare two CSV files and output the rows that are just in either of the file but not in both

I have a file first.csv name,surname,height,city,county,state,zipCode John,Doe,120,jefferson,Riverside,NJ,8075 Jack,Yan,220,Phila,Riverside,PA,9119 Jill,Fan,120

convert a CSV file to JSON file

I am trying to convert CSV file to JSON file based on a column value. The csv file looks somewhat like this. ID Name Age CSE001 John

MariaDB losing data when importing CSV

I'm trying to import a CSV file into MariaDB. I've created the table with "varchar(300)" for each field, so it's not missing space. Also, when I loaded the file