Recent questions tagged CSV

0 votes

533 views

1 answer

csv - MySQL - Multiple set on LOAD DATA INFILE

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

485 views

1 answer

csv - Best practices for inserting/updating large amount of data in SQL Server 2008

I'm building a system for updating large amounts of data through various CSV feeds. Normally I would just ... a productive environment? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

471 views

1 answer

csv - Replace multiple consecutive white spaces with one comma in Unix

I have the following sed command: sed 's/s/,/g' input > output.csv (I got the command from this related topic ... .0201,0.1822,0.9156 Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

424 views

1 answer

csv - Replace multiple consecutive white spaces with one comma in Unix

I have the following sed command: sed 's/s/,/g' input > output.csv (I got the command from this related topic ... .0201,0.1822,0.9156 Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

484 views

1 answer

csv - Replace multiple consecutive white spaces with one comma in Unix

I have the following sed command: sed 's/s/,/g' input > output.csv (I got the command from this related topic ... .0201,0.1822,0.9156 Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

417 views

1 answer

csv - Importing and updating data in Elasticsearch

We have an existing search function that involves data across multiple tables in SQL Server. This causes a heavy load ... "state_code": "CA" } See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

600 views

1 answer

csv - How to open a text file with Excel in UTF-8 encoding?

I have a text file with ".tsv" extension. It has UTF-8 enconding and it contains cyrillic characters. When I ... file in Excel with the wizard. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

csv - Replacing part of string in python pandas dataframe

I have a similar problem to the one posted here: Pandas DataFrame: remove unwanted parts from strings in a column I need ... is 0.9.1 Thanks! :) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

486 views

1 answer

csv - Loading a file into a numpy array with python

So I'm very green with Python and am trying to learn by replicating some matlab code I've written. I have ... , but with comma-delimited data? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

498 views

1 answer

csv - unix join separator char

Sorry for the maybe trivial question. I fought a bit with the unix join command, trying to get tabs instead of ... -t argument, it must work. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

583 views

1 answer

csv - Delete every other line in notepad++

Is there a way in Notepad++ to delete every other or nth line? I have a massive list of data and I need to ... I only need a selection of 5,000 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

398 views

1 answer

csv content filtering by list elments in Python

I got stuck in getting the right result from a simple piece of Python code ( I am a Python beginner anyway) ... myfile.write(var) myfile.close() See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

459 views

1 answer

csv - Issue with negative sign after executing the tr command in UNIX

My requirement is to convert pipe separated file into normal excel. So I used the below tr command in UNIX to ... sign to front of the field. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

547 views

1 answer

csv - Matlab xlsread cutting off file after row 1048576

Is there any other way of importing an Excel formatted .csv into Matlab other than xlsread(file.csv); The file ... because of the date format. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

804 views

1 answer

csv - Python [Errno 13] Permission denied:

I'm attempting to write a quick python script to iterate through all csv files in the current folder and ... Permission denied: 'HeaderRemoved' See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

468 views

1 answer

csv - Create report and upload to server for download

I have a CSV file thats 300MB and has over 1/2 million entries. I want to run reports and make these reports ... has been sorted by column B. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

374 views

1 answer

csv - Importing financial data into Python Pandas using read_csv

I have a .csv with the following structure: date_begin,date_end,name,name_code,active_accounts,transaction_amount, ... Any thoughts? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

497 views

1 answer

csv - Regex: Comma delimited integers

I'm trying to create a regex that accept: An empty string, a single integer or multiple integers separated by a comma but ... ,10}([,]d{10})*$ See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

542 views

1 answer

csv - SQL Server - join rows into comma separated list

Let's suppose I have a temporary table which looks like this: +----+------+ | Id | Value| +----+- ... point me to a right direction? Thank you. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

804 views

1 answer

csv - Python Scrapy: How to get CSVItemExporter to write columns in a specific order

In Scrapy, I have my items specified in a certain order in items.py, & my spider has those items again ... would be very appreciated. Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

785 views

1 answer

csv - How do you read a file inside a zip file as text, not bytes?

A simple program for reading a CSV file inside a zip file works in Python 2.7, but not in Python 3.2 $ cat ... one make this work in Python 3? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

933 views

1 answer

csv - MYSQL LOAD DATA INFILE ignore duplicate rows (autoincrement as primary key)

I ran into some trouble using LOAD DATA INFILE command as i wanted to ignore the lines that was already in the ... links but did not help :( See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

468 views

1 answer

csv - Powershell: Reference a property that contains a space

I am importing a CSV file using powershell. The problem is, the title of one of the columns is "Remaining ... Time' in expression or statement" See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

596 views

1 answer

csv - Printing column separated by comma using Awk command line

I have a problem here. I have to print a column in a text file using awk. However, the columns are not ... I print out 3rd column using awk? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

712 views

1 answer

csv - How to import a tsv file with SQLite3

I have a tsv (tab separated file) that I would like to import with sqlite3. Does someone know a clear way ... a .tsv file into sqlite? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

417 views

1 answer

csv - Excel changes date formats

I run a process to produce a rather large CSV file of data. Sometimes I find it helpful to open the ... off all text formatting altogether. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

460 views

1 answer

csv - Using Powershell environmental variables as strings when outputting files

I am using Get-WindowsAutopilotInfo to generate a computer's serial number and a hash code and export that info ... I missing something? Thanks! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

553 views

1 answer

csv - How to read a text file into GNU R with a multiple-byte separator?

I can use read.csv or read.csv2 to read data into R. But the issue I encountered is that my separator is a ... . How can I deal with this? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags