Skip to main content
380 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
117 views

Need some help with I have a csv file provided by my client, which contains the export of products from an internal database connected to an invoicing software. But some fields are in json. This is an ...
Jorge Santos's user avatar
  • 9
0 votes
0 answers
165 views

I decided to create a local database using Duckdb, but wasn't able to resolve a problem related to import of data from CSV files. A reason for that are NAs that is a quite frequent issue in social ...
dkolkin's user avatar
  • 103
0 votes
0 answers
71 views

I have large CSV files with stock values and I have successfully added these to my MariaDB database using the "LOAD DATA INFILE" command: LOAD DATA LOCAL INFILE '/mnt/HD/HD_b2/Public2/...
Jimmy Westberg's user avatar
  • 215
0 votes
0 answers
57 views

I use adodb to import csv to sheet but i have problem with trailing minus data and it seem record set cannot recognize trailing minus and it disappear. i want it to import negatve number but because ...
đức anh phạm ngọc's user avatar
  • 1
0 votes
1 answer
138 views

I am trying to import data from a CSV file that is stored in a Bucket. The CSV file uses the "|" delimiter. I would like to import these data to a MySQL database on Cloud SQL. However, I ...
user avatar
0 votes
1 answer
150 views

I'm importing a csv data file into power bi power query. One of the columns has dates. 90% of the records are formatted as mm/dd/yyyy hh:mm:ss pm/am (12/7/2022 12:30:01 PM). The other 10% of the ...
trena68aolcom's user avatar
  • 1
0 votes
0 answers
497 views

I am using myworkbench 8.0 to import data to MySql 8.0.32 from a 16G csv file. I get "Error Code: 5. Out of memory (Needed 784334881 bytes)". Machine spec: Win 10, 8Gb ram. CSV is | ...
Tshif's user avatar
  • 1
0 votes
0 answers
56 views

I am working with PyQt5 and trying to import csv data to my QTableWidget, using QFileDialog which i open with a QPushButton. The issue is, after choosing the file, my QTableWidget won't refresh and ...
thehusk's user avatar
  • 3
0 votes
1 answer
485 views

Wanted to know the tool which can extract data in csv from a table or by executing a sql query like select * from table 1 inner join table 2 on ... Data is currently in oracle database and required ...
umang's user avatar
  • 25
0 votes
1 answer
130 views

Seems CurrentProject.ImportExportSpecifications("import-CP_Commandes").Execute has sometimes a strange behaviour. I need to import daily one or several csv files that will be inserted into ...
Till Ducroquet's user avatar
  • 1
0 votes
1 answer
206 views

While importing or exporting to a CSV file, I see that python rounds off value but only for certain rows/columns whereas the other data is kept intact. Not sure why this is happening for certain rows/...
aseb's user avatar
  • 27
0 votes
0 answers
389 views

I have a little VB knowledge but this one is way beyond my scope. This is a multipart problem I am trying to find a solution. We have a tab delineated text file with 11 fields that is constantly ...
user20555729's user avatar
  • 1
1 vote
0 answers
247 views

I am trying to load a csv into a data frame using pandas.read_csv. My data has a column of cell ids that are 18 digits long, and then other columns with other data. Sometimes there is an empty entry, ...
Sweta's user avatar
  • 11
0 votes
1 answer
91 views

I have raw data that when importing, there is some "extra" data for some of the rows. It is saved as a text file but is comma separated. When bringing it into R, it looks like this: In the ...
wisamb's user avatar
  • 502
0 votes
0 answers
69 views

I'm running VB 2019, trying to import a CSV file into an Access database using this code: Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + My....
user3516774's user avatar
  • 29
0 votes
2 answers
2k views

I'm looking to import data with known required column headers, from a variable list of .csv files, some of which have columns I don't need. For example: File 1 maybe has: NAME, ADDRESS, EMAIL File 2 ...
GTB's user avatar
  • 5
0 votes
1 answer
219 views

I am trying to get some data from a csv file having more than than 3 million rows. I've set an ADODB connection to my csv file and everything works fine except for querying date columns. Here is how I ...
Oğuzhan Orhan's user avatar
  • 3
1 vote
1 answer
344 views

I have a csv like: file: 1;a;3;4 1;2;b;4 1;[a;b];3;4 Loading like pd.from_csv(file, sep=';') returns error: ParserError: Error tokenizing data. C error: Expected 4 fields in line 3, saw 5 as the [a;...
Towlie's user avatar
  • 77
-1 votes
2 answers
656 views

I have created a csv file with two columns - the subject and the modules. and i want to print out all the modules for the same subject the csv file looks like this csvfile currently my code looks like:...
Humaira's user avatar
  • 1
0 votes
1 answer
313 views

I need to create a database importing data from a csv file. Following the instructions of the exercise, I created the models and a file for the script, but when I run the command python manage.py ...
materialAres's user avatar
  • 47
1 vote
1 answer
801 views

I need to get the values from my csv file and for this I need to set the seperator to ';' and the values are in '"'. If I try it like this: final CSVReader reader = new CSVReader(new ...
Phil's user avatar
  • 37
0 votes
2 answers
1k views

I am new to python and I am trying to help my son with a school project. He needs to look at a csv with min and max outdoor temperature, and then write to a different CSV with the min temperature and ...
Vaughn's user avatar
  • 1
3 votes
1 answer
2k views

This was part of another question (Reading URLs from .csv and appending scrape results below previous with Python, BeautifulSoup, Pandas ) which was generously answered by @HedgeHog and contributed to ...
Michael Wiz's user avatar
  • 173
0 votes
0 answers
1k views

I got the following query to import a .csv that works perfectly when I execute it on the SQL Server instance of my Microsoft SQL Server 2019. SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', ...
Bob's user avatar
  • 487
-1 votes
2 answers
548 views

I am working on a project that has a function that allows users to import a file (Excel or CSV) to DB (MsSQL). I have read tutorials on the internet and followed them, but the problem is one of my ...
Nguyen Dinh Khanh's user avatar
  • 1
1 vote
1 answer
2k views

I have hashtags (#) in some of my string fields in a CSV file. It looks like that R has problems with it. csv = "A;B;C n;# 9;0 n;1;0" read.table(text=csv, header=TRUE, sep=";", ...
buhtz's user avatar
  • 12.5k
1 vote
2 answers
3k views

I don't know where it is wrong, right in my code, please help I already wasted lot of my time... THANK YOU _/\_ admin.py from import_export import resources from import_export.admin import ...
Naveen Sargam's user avatar
  • 17
1 vote
1 answer
180 views

I want to import a CSV into solr via Index Handlers like described in the docs: https://solr.apache.org/guide/7_1/uploading-data-with-index-handlers.html#csv-update-parameters I have a CSV with the ...
Tim Dreier's user avatar
  • 35
0 votes
2 answers
55 views

My code is as follow The output is null, I should use while loop as you see, but somewhere in my code is not working properly. and I'm not able to use any other library I need an hours array and rate ...
Alex Jey's user avatar
  • 1
0 votes
0 answers
173 views

I have a flat file which I need to import to SQL. Datatype of table is nvarchar(4000). I also use format file which is xml file. the problem is the flat file has 'PM vuông' but when I imported to SQL, ...
Trần Thế Chương's user avatar
  • 1
0 votes
1 answer
1k views

I have a csv file that has header called CompanyName. In the csv there are tons of rows and different company names. But I keep a text file with specific companies whose data I need to retrieve. ...
Milan Patel's user avatar
  • 43
1 vote
1 answer
366 views

I am sorry for asking this but I am going to go crazy trying to solve it. I call a method from my activity d.loadQuestions(this); I use that method to import two CSV files to a SQLite table. public ...
Javierungo's user avatar
  • 81
2 votes
2 answers
2k views

I am trying to import this CSV file: HEADER "{ ""field1"": ""123"", ""field2"": ""456"" }" "{ "...
maxime.b28's user avatar
  • 61
-3 votes
1 answer
217 views

I would like to create a JSON with array of nested objects with a grouping for different fields. This is the CSV and Iwould like to group it by sid, year and quarter (first three fields): S4446B3,2020,...
alfio's user avatar
  • 9
1 vote
2 answers
3k views

Very new to Python here. I am trying to read a file from a folder, but without knowing its full name. For example AAA_05212021.csv is the file name located in C:\test\ AAA is the known part of the ...
Trainee 's user avatar
  • 13
-4 votes
1 answer
750 views

I'm getting a segmentation fault error while parsing data from a CSV file in C Language. I believe the error is given while reading the last line <person[i].status> as if i comment the same line ...
zumuha's user avatar
  • 63
2 votes
1 answer
6k views

I have a CSV file that looks like below In my SSIS package (Visual Studio 2017), I create a Flat File connection Text qualifer: " Header Row Delimiter: {LF} Header Rows to skip: 0 Column ...
faujong's user avatar
  • 1,179
0 votes
1 answer
409 views

InfluxDB and Flux return query results in annotated CSV format. Im am querying the data from R studio using the InfluxDB v2 API. How do I work with the data I receive in the annotated csv format? ...
strittmm's user avatar
  • 33
0 votes
0 answers
159 views

I'm trying to import data through files and below code works fine with csv files but, when I upload a zip file it uploads some garbage value into database. Can you please help me with this. Thank you! ...
Rushi's user avatar
  • 25
-1 votes
1 answer
554 views

I have a few text files and there are multiline headers. If the file has the string 'Server totals' then I need to read in the text file, columns after this string. for root, dirs, files, in os.walk('...
belewis6i's user avatar
  • 107
-1 votes
2 answers
37 views

I would like to get the if "172" in statement to identify the addresses with 172 in them. Thinking I must have syntax wrong on "if "172" in {row["IP_ADDRESS_ZLOC"]}:...
zero_point_zero's user avatar
  • 1
0 votes
1 answer
270 views

i am looking for a db2 method to import a .csv file (IMPORT.CSV) like this: 2020-01-01;1.234.567,12345 in the a DB2 table MY_TABLE: CREATE TABLE MY_TABLE ( DTRIF DATE, SALDO ...
Stefano Tinarelli's user avatar
  • 35
0 votes
1 answer
918 views

I'm new to VBA and therefore need some help. I'm trying to import data from a CSV file using a method where I can chose the csv of a list using the following piece of code: Private Sub ...
jjj's user avatar
  • 35
1 vote
2 answers
785 views

We have 2 branches B-1 and B-2 within the distance of 100kms. Both these Branches have their own SQL server setup in their respective locations ;with same database name, tables and structure... Means ...
Shaaaan's user avatar
  • 65
1 vote
0 answers
914 views

I have a CSV file filename.csv with the following content: UID;Datum;Klasse;SendungsNr 6177;14.08.20;624;00340434299338038179 6178;14.08.20;624;00340434299338038186 6179;14.08.20;624;...
Albin's user avatar
  • 1,147
0 votes
1 answer
84 views

Working in R. But I think this question is universal. Wall Street Journal visualized a dataset on disease infection rates in the U.S.: X-axis is year. Y-axis is state. And shade of red per tile is ...
owlstone's user avatar
  • 563
0 votes
0 answers
318 views

I have two tables. one is user-table -name - user and another table named profile. The format of csv file for user is like this: first_name,last_name,username,email,phone,user_role,status,...
Joshi's user avatar
  • 2,800
1 vote
0 answers
368 views

I am trying to export some data from a connection say UAT to DEV. Once I export my data into a new table, would do a MINUS to get the missing or incorrect data. I don't have the option of creating a ...
Rohit Prasad's user avatar
  • 145
0 votes
1 answer
672 views

Trying to Store GTIN numbers in WordPress Database via WooCommerce CSV Import In Excel I created my CSV in which there is a column called meta:wpseo_global_identifier_values Through excel formulas I ...
Matt's user avatar
  • 1
0 votes
1 answer
2k views

I use vaex.from_csv() to convert csv to hdf5 . import vaex vaex.from_csv("/Users/xxxx/development/vaex/dataAN/testdata1.csv", convert=True) Get IPython/core/interactiveshell.py:3331: ...
heyuqi's user avatar
  • 3

1
2 3 4 5
…
8