About this Dataset

Tourism Dataset

Justification:

Columns:

Location: A ten- -character random string that represents the location's name.
Nation: Selectively selected from a roster of nations.
Type: Selectively selected from a range of travel-related categories.
Visitor count: A random integer value that indicates how many people have visited.
Rating: A random float number in the range of 1.0 and 5.0 is used to indicate the rating.
Revenue: A float value chosen at random to indicate the revenue received.
Accommodation_Available: Returns a value of "Yes" or "No" depending on the availability of accomodation.
Target Size: During the loop, the file size is measured and rows are added until the file size reaches roughly 310.43 KB.

You will have a tourism_dataset.csv file, roughly 310.43 KB in size, after executing this code. Depending on the data distribution and file overhead, adjustments can be required.

Tables

Tourism Dataset

@kaggle.umeradnaan_tourism_dataset.tourism_dataset

183.02 KB
5989 rows
7 columns


CREATE TABLE tourism_dataset (
  "location" VARCHAR,
  "country" VARCHAR,
  "category" VARCHAR,
  "visitors" BIGINT,
  "rating" DOUBLE,
  "revenue" DOUBLE,
  "accommodation_available" VARCHAR
);