Top "Data-import" questions

The import and export of data is the automated or semi-automated input and output of data sets between different software applications.

Fastest way to import CSV files in MATLAB

I've written a script that saves its output to a CSV file for later reference, but the second script for …

matlab file-io csv data-import
'utf-8' codec can't decode byte 0x92 in position 18: invalid start byte

I am trying to read in a dataset called df1, but it does not work import pandas as pd df1=…

python-3.x data-import
Can you automatically create a mysqldump file that doesn't enforce foreign key constraints?

When I run a mysqldump command on my database and then try to import it, it fails as it attempts …

mysql foreign-keys mysqldump data-import
Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

I am using MySQL Workbench 8.0. I am trying to dump test data to DB including all the tables, stored procedures …

mysql mysql-workbench data-import
Convert VARCHAR to SMALLDATETIME as part of UPDATE statement

I'm performing a bulk data import on CSV files. In the CSV files, my 'Date' column contains a date in …

sql sql-server sql-server-2008 sql-server-2008-r2 data-import
Bulk Insert Failed "Bulk load data conversion error (truncation)"

I've done data imports with SQL Server's BULK INSERT task hundreds of times, but this time I'm receiving an error …

sql-server-2008 bulkinsert data-import
Load data from csv file to oracle table from command line

I tried with sql loader.The thing is the table needs to be empty for data loading.Is there any …

oracle oracle11g sql-loader data-import
How to skip an unknown number of empty lines before header on pandas.read_csv?

I want to read a dataframe from a csv file where the header is not in the first line. For …

python csv pandas file-io data-import
Error when trying to import NetCDF to R

I' struggeling to open a NetCDF file in R. When I try to open it with library(ncdf) # read in …

r netcdf data-import
How can I do indexing .html files in SOLR

The files I want to do indexing is stored on the server(I don't need to crawl). /path/to/files/ …

solr full-text-indexing dataimporthandler data-import solr4