Stack Overflow
Stack Overflow

Questions tagged [dataset]

A dataset is a collection of data, generally represented in tabular form, with columns signifying different variables and rows signify different members of the set. If you are looking for a freely available dataset for any purpose, please consider asking your question on https://opendata.stackexchange.com.

11414 questions
19
votes
3 answers

Create a new table and adding a primary key using SELECT INTO

I have a database table that is created using the SELECT INTO SQL syntax. The database is in Access and consists of roughly 500,000 rows. The problem is when I do the join, the unique is the entire row - what I would like is an auto number ID field…
user559142
  • 12,279
  • 49
  • 116
  • 179
19
votes
15 answers

How can I change the table adapter's command timeout

I'm using Visual Studio 2008 with C#. I have a .xsd file and it has a table adapter. I want to change the table adapter's command timeout. Thanks for your help.
cagin
  • 5,772
  • 14
  • 74
  • 130
18
votes
8 answers

How to read data from Microsoft Access .accdb database files into R?

The RODBC documentation suggests it is possible, but I am not sure how to read data from a Microsoft Access (the new .accdb format) file with this package into R (on Debian GNU/Linux). The vignette talks about drivers, but I do not quite understand…
Egon Willighagen
  • 1,621
  • 4
  • 19
  • 36
18
votes
7 answers

Useful stock SQL datasets?

Does anyone know of any resources that provide good, useful stock datasets? For example, I've downloaded a SQL script that includes all of the U.S. states, cities, and zipcodes. This saved me a lot of time in a recent application where I wanted to…
Shadowman
  • 11,150
  • 19
  • 100
  • 198
18
votes
6 answers

ImportError: No module named datasets

from datasets import dataset_utils ImportError: No module named datasets. when i am writing this in python sript. import tensorflow as tf from datasets import dataset_utils slim = tf.contrib.slim But i am getting error. from datasets import…
ansu1234
  • 191
  • 1
  • 1
  • 6
18
votes
3 answers

Download link for Ta Feng Grocery dataset

I am desperately trying to download the Ta-Feng grocery dataset for few days but appears that all links are broken. I needed for data mining / machine learning research for my msc thesis. I also have the Microsoft grocery database, the Belgian store…
Dragan
  • 500
  • 3
  • 11
18
votes
6 answers

Populating a dataset from a CSV file

I would like to read the contents of a CSV file and create a dataset. I am trying like this: var lines = File.ReadAllLines("test.csv").Select(a => a.Split(';')); DataSet ds = new DataSet(); ds.load(lines); but apparently this is not correct.
jayt.dev
  • 975
  • 6
  • 14
  • 36
17
votes
5 answers

How do I generate random sample data in my Oracle database?

Does anyone know of a tool that can inspect a specified schema and generate random data based on the tables and columns of that schema?
Justin Kredible
  • 8,354
  • 15
  • 65
  • 91
17
votes
4 answers

Finding null value in Dataset - DataRow.IsNull method vs ==DbNull.Value - c#

What are the benefits of using the c# method DataRow.IsNull to determine a null value over checking if the row equals DbNull.value? if(ds.Tables[0].Rows[0].IsNull("ROWNAME")) {do stuff} vs if(ds.Tables[0].Rows[0]["ROWNAME"] == DbNull.value) {do…
Jarrod
  • 1,535
  • 3
  • 16
  • 19
17
votes
9 answers

Why do we still use DataSets in .NET?

DataSets were one of the big things in .NET 1.0 and even now when using .NET 3.5 I still find myself having to use them....especially when I have to call a stored proc which returns a dataset which I then end up having to manually transform into an…
mezoid
  • 28,090
  • 37
  • 107
  • 148
17
votes
7 answers

What are the disadvantages of Typed DataSets

I come from a world that favors building your own rather than rely on libraries and frameworks built by others. After escaping this world I have found the joy, and ease, of using such tools as Typed DataSets within Visual Studio. So besides the loss…
Craig Tyler
  • 470
  • 6
  • 9
17
votes
5 answers

How do I transform a List into a DataSet?

Given a list of objects, I am needing to transform it into a dataset where each item in the list is represented by a row and each property is a column in the row. This DataSet will then be passed to an Aspose.Cells function in order to create an…
mezoid
  • 28,090
  • 37
  • 107
  • 148
17
votes
3 answers

Parsing a .NET DataSet returned from a .NET Web Service in Java

I have to consume a .NET hosted web service from a Java application. Interoperability between the two is usually very good. The problem I'm running into is that the .NET application developer chose to expose data using the .NET DataSet object. There…
Chris Dail
  • 25,715
  • 9
  • 65
  • 74
17
votes
1 answer

Exclude data sets from R package build

I'm implementing an R package, where I have several big .rda data files in the 'data' folder. When I build the package (with R CMD build to create the .tar.gz packed file), also the data files are included in the package, and since they are really…
WoDoSc
  • 2,598
  • 1
  • 13
  • 26
16
votes
6 answers

What is the right order of insertion/deletion/modification on dataset?

The MSDN claims that the order is : Child table: delete records. Parent table: insert, update, and delete records. Child table: insert and update records. I have a problem with that. Example : ParentTable have two records parent1(Id : 1) and…
Cyril Gandon
  • 16,830
  • 14
  • 78
  • 122
1 2 3
…
99 100