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
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
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(
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
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
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
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
I have a csv file that has inconsistent spacing after the comma, like this: 534323, 93495443,34234234, 3523423423, 2342342,236555, 6564354344 I have written a f
I have a log file in csv which has a column contains a list of filepaths separated by comma. I want to split those filepaths into new rows using pyspark(or exce
I need to add some additional values to an existing column for my CSV file. So this is what I have so far: Sample input CSV file: Alfa,Beta,Charlie,Delta,Echo,F
Sorry But I can't use pandas. I have a sample input csv file that looks like this: Alfa,Beta,Charlie,Delta,Echo,Foxtrot,Golf,Hotel,India,Juliett,Kilo A1,B1,C1,D
I am working on automating status reports using Python and the Jira API with a config.ini file. My goal is to have a config file where users can supply a jql st
Does anyone know how to convert a .csv file to a .data or know how to use only half of a .data file like a csv file? I'm trying to achieve a mean Average Positi
I am trying to create a PowerShell script that adds two leading zeros to all the numbers in a particular column.This script is able to add the two zeros to the
I want to import a large csv file without creating table before for that csv file into postgresql. While searching on stackoverflow, one of th
i have a large tab seperated csv file, about ~10GB, i need to edit all the "direct" words in a column named Tab2 with the value of the column Tab1 in the same r
I have a CSV: '1\n2\na'. If I read it with something like pd.read_csv(io.StringIO('1\n2\na'), names=['A'], dtype={'A': 'float'}) specifying that the first colum
I need the code to rearrange the columns while changing the header names without using Pandas. I also need to omit some of the columns in the new csv file. Samp
I need to choose and merge multiple csv files. All are in the same structure, however the name of file and sheets change. The separator is ; The code merges the
I'm having trouble executing this file. Given that I'm working on a multi-class classification, each .txt file has several lines addressing each object in every