read-csv-files - Databricks

%scala 
val diamonds = spark.read.format("csv")
  .option("header", "true")
  .option("inferSchema", "true")
  .load("/databricks-datasets/Rdatasets/data-001/csv/ggplot2/diamonds.csv")

display(diamonds)


1	0.23	Ideal	E	SI2	61.5	55	326	3.95	3.98	2.43
2	0.21	Premium	E	SI1	59.8	61	326	3.89	3.84	2.31
3	0.23	Good	E	VS1	56.9	65	327	4.05	4.07	2.31
4	0.29	Premium	I	VS2	62.4	58	334	4.2	4.23	2.63
5	0.31	Good	J	SI2	63.3	58	335	4.34	4.35	2.75
6	0.24	Very Good	J	VVS2	62.8	57	336	3.94	3.96	2.48
7	0.24	Very Good	I	VVS1	62.3	57	336	3.95	3.98	2.47
8	0.26	Very Good	H	SI1	61.9	55	337	4.07	4.11	2.53
9	0.22	Fair	E	VS2	65.1	61	337	3.87	3.78	2.49
10	0.23	Very Good	H	VS1	59.4	61	338	4	4.05	2.39
11	0.3	Good	J	SI1	64	55	339	4.25	4.28	2.73
12	0.23	Ideal	J	VS1	62.8	56	340	3.93	3.9	2.46
13	0.22	Premium	F	SI1	60.4	61	342	3.88	3.84	2.33
14	0.31	Ideal	J	SI2	62.2	54	344	4.35	4.37	2.71
15	0.2	Premium	E	SI2	60.2	62	345	3.79	3.75	2.27
16	0.32	Premium	E	I1	60.9	58	345	4.38	4.42	2.68
17	0.3	Ideal	I	SI2	62	54	348	4.31	4.34	2.68
18	0.3	Good	J	SI1	63.4	54	351	4.23	4.29	2.7
19	0.3	Good	J	SI1	63.8	56	351	4.23	4.26	2.71
20	0.3	Very Good	J	SI1	62.7	59	351	4.21	4.27	2.66
21	0.3	Good	I	SI2	63.3	56	351	4.26	4.3	2.71
22	0.23	Very Good	E	VS2	63.8	55	352	3.85	3.92	2.48
23	0.23	Very Good	H	VS1	61	57	353	3.94	3.96	2.41
24	0.31	Very Good	J	SI1	59.4	62	353	4.39	4.43	2.62
25	0.31	Very Good	J	SI1	58.1	62	353	4.44	4.47	2.59
26	0.23	Very Good	G	VVS2	60.4	58	354	3.97	4.01	2.41
27	0.24	Premium	I	VS1	62.5	57	355	3.97	3.94	2.47
28	0.3	Very Good	J	VS2	62.2	57	357	4.28	4.3	2.67
29	0.23	Very Good	D	VS2	60.5	61	357	3.96	3.97	2.4
30	0.23	Very Good	F	VS1	60.9	57	357	3.96	3.99	2.42
31	0.23	Very Good	F	VS1	60	57	402	4	4.03	2.41
32	0.23	Very Good	F	VS1	59.8	57	402	4.04	4.06	2.42
33	0.23	Very Good	E	VS1	60.7	59	402	3.97	4.01	2.42
34	0.23	Very Good	E	VS1	59.5	58	402	4.01	4.06	2.4
35	0.23	Very Good	D	VS1	61.9	58	402	3.92	3.96	2.44
36	0.23	Good	F	VS1	58.2	59	402	4.06	4.08	2.37
37	0.23	Good	E	VS1	64.1	59	402	3.83	3.85	2.46
38	0.31	Good	H	SI1	64	54	402	4.29	4.31	2.75
39	0.26	Very Good	D	VS2	60.8	59	403	4.13	4.16	2.52
40	0.33	Ideal	I	SI2	61.8	55	403	4.49	4.51	2.78
41	0.33	Ideal	I	SI2	61.2	56	403	4.49	4.5	2.75
42	0.33	Ideal	J	SI1	61.1	56	403	4.49	4.55	2.76
43	0.26	Good	D	VS2	65.2	56	403	3.99	4.02	2.61
44	0.26	Good	D	VS1	58.4	63	403	4.19	4.24	2.46
45	0.32	Good	H	SI2	63.1	56	403	4.34	4.37	2.75
46	0.29	Premium	F	SI1	62.4	58	403	4.24	4.26	2.65
47	0.32	Very Good	H	SI2	61.8	55	403	4.35	4.42	2.71
48	0.32	Good	H	SI2	63.8	56	403	4.36	4.38	2.79
49	0.25	Very Good	E	VS2	63.3	60	404	4	4.03	2.54
50	0.29	Very Good	H	SI2	60.7	60	404	4.33	4.37	2.64
51	0.24	Very Good	F	SI1	60.9	61	404	4.02	4.03	2.45
52	0.23	Ideal	G	VS1	61.9	54	404	3.93	3.95	2.44
53	0.32	Ideal	I	SI1	60.9	55	404	4.45	4.48	2.72
54	0.22	Premium	E	VS2	61.6	58	404	3.93	3.89	2.41
55	0.22	Premium	D	VS2	59.3	62	404	3.91	3.88	2.31
56	0.3	Ideal	I	SI2	61	59	405	4.3	4.33	2.63
57	0.3	Premium	J	SI2	59.3	61	405	4.43	4.38	2.61
58	0.3	Very Good	I	SI1	62.6	57	405	4.25	4.28	2.67
59	0.3	Very Good	I	SI1	63	57	405	4.28	4.32	2.71
60	0.3	Good	I	SI1	63.2	55	405	4.25	4.29	2.7
61	0.35	Ideal	I	VS1	60.9	57	552	4.54	4.59	2.78
62	0.3	Premium	D	SI1	62.6	59	552	4.23	4.27	2.66
63	0.3	Ideal	D	SI1	62.5	57	552	4.29	4.32	2.69
64	0.3	Ideal	D	SI1	62.1	56	552	4.3	4.33	2.68
65	0.42	Premium	I	SI2	61.5	59	552	4.78	4.84	2.96
66	0.28	Ideal	G	VVS2	61.4	56	553	4.19	4.22	2.58
67	0.32	Ideal	I	VVS1	62	55.3	553	4.39	4.42	2.73
68	0.31	Very Good	G	SI1	63.3	57	553	4.33	4.3	2.73
69	0.31	Premium	G	SI1	61.8	58	553	4.35	4.32	2.68
70	0.24	Premium	E	VVS1	60.7	58	553	4.01	4.03	2.44
71	0.24	Very Good	D	VVS1	61.5	60	553	3.97	4	2.45
72	0.3	Very Good	H	SI1	63.1	56	554	4.29	4.27	2.7
73	0.3	Premium	H	SI1	62.9	59	554	4.28	4.24	2.68
74	0.3	Premium	H	SI1	62.5	57	554	4.29	4.25	2.67
75	0.3	Good	H	SI1	63.7	57	554	4.28	4.26	2.72
76	0.26	Very Good	F	VVS2	59.2	60	554	4.19	4.22	2.49
77	0.26	Very Good	E	VVS2	59.9	58	554	4.15	4.23	2.51
78	0.26	Very Good	D	VVS2	62.4	54	554	4.08	4.13	2.56
79	0.26	Very Good	D	VVS2	62.8	60	554	4.01	4.05	2.53
80	0.26	Very Good	E	VVS1	62.6	59	554	4.06	4.09	2.55
81	0.26	Very Good	E	VVS1	63.4	59	554	4	4.04	2.55
82	0.26	Very Good	D	VVS1	62.1	60	554	4.03	4.12	2.53
83	0.26	Ideal	E	VVS2	62.9	58	554	4.02	4.06	2.54
84	0.38	Ideal	I	SI2	61.6	56	554	4.65	4.67	2.87
85	0.26	Good	E	VVS1	57.9	60	554	4.22	4.25	2.45
86	0.24	Premium	G	VVS1	62.3	59	554	3.95	3.92	2.45
87	0.24	Premium	H	VVS1	61.2	58	554	4.01	3.96	2.44
88	0.24	Premium	H	VVS1	60.8	59	554	4.02	4	2.44
89	0.24	Premium	H	VVS2	60.7	58	554	4.07	4.04	2.46
90	0.32	Premium	I	SI1	62.9	58	554	4.35	4.33	2.73
91	0.7	Ideal	E	SI1	62.5	57	2757	5.7	5.72	3.57
92	0.86	Fair	E	SI2	55.1	69	2757	6.45	6.33	3.52
93	0.7	Ideal	G	VS2	61.6	56	2757	5.7	5.67	3.5
94	0.71	Very Good	E	VS2	62.4	57	2759	5.68	5.73	3.56
95	0.78	Very Good	G	SI2	63.8	56	2759	5.81	5.85	3.72
96	0.7	Good	E	VS2	57.5	58	2759	5.85	5.9	3.38
97	0.7	Good	F	VS1	59.4	62	2759	5.71	5.76	3.4
98	0.96	Fair	F	SI2	66.3	62	2759	6.27	5.95	4.07
99	0.73	Very Good	E	SI1	61.6	59	2760	5.77	5.78	3.56
100	0.8	Premium	H	SI1	61.5	58	2760	5.97	5.93	3.66

Showing the first 1000 rows.

%scala

diamonds.printSchema

%r 
library(SparkR)

diamonds <- read.df("/databricks-datasets/Rdatasets/data-001/csv/ggplot2/diamonds.csv", source = "csv", header="true", inferSchema = "true")

display(diamonds)


1	0.23	Ideal	E	SI2	61.5	55	326	3.95	3.98	2.43
2	0.21	Premium	E	SI1	59.8	61	326	3.89	3.84	2.31
3	0.23	Good	E	VS1	56.9	65	327	4.05	4.07	2.31
4	0.29	Premium	I	VS2	62.4	58	334	4.2	4.23	2.63
5	0.31	Good	J	SI2	63.3	58	335	4.34	4.35	2.75
6	0.24	Very Good	J	VVS2	62.8	57	336	3.94	3.96	2.48
7	0.24	Very Good	I	VVS1	62.3	57	336	3.95	3.98	2.47
8	0.26	Very Good	H	SI1	61.9	55	337	4.07	4.11	2.53
9	0.22	Fair	E	VS2	65.1	61	337	3.87	3.78	2.49
10	0.23	Very Good	H	VS1	59.4	61	338	4	4.05	2.39
11	0.3	Good	J	SI1	64	55	339	4.25	4.28	2.73
12	0.23	Ideal	J	VS1	62.8	56	340	3.93	3.9	2.46
13	0.22	Premium	F	SI1	60.4	61	342	3.88	3.84	2.33
14	0.31	Ideal	J	SI2	62.2	54	344	4.35	4.37	2.71
15	0.2	Premium	E	SI2	60.2	62	345	3.79	3.75	2.27
16	0.32	Premium	E	I1	60.9	58	345	4.38	4.42	2.68
17	0.3	Ideal	I	SI2	62	54	348	4.31	4.34	2.68
18	0.3	Good	J	SI1	63.4	54	351	4.23	4.29	2.7
19	0.3	Good	J	SI1	63.8	56	351	4.23	4.26	2.71
20	0.3	Very Good	J	SI1	62.7	59	351	4.21	4.27	2.66
21	0.3	Good	I	SI2	63.3	56	351	4.26	4.3	2.71
22	0.23	Very Good	E	VS2	63.8	55	352	3.85	3.92	2.48
23	0.23	Very Good	H	VS1	61	57	353	3.94	3.96	2.41
24	0.31	Very Good	J	SI1	59.4	62	353	4.39	4.43	2.62
25	0.31	Very Good	J	SI1	58.1	62	353	4.44	4.47	2.59
26	0.23	Very Good	G	VVS2	60.4	58	354	3.97	4.01	2.41
27	0.24	Premium	I	VS1	62.5	57	355	3.97	3.94	2.47
28	0.3	Very Good	J	VS2	62.2	57	357	4.28	4.3	2.67
29	0.23	Very Good	D	VS2	60.5	61	357	3.96	3.97	2.4
30	0.23	Very Good	F	VS1	60.9	57	357	3.96	3.99	2.42
31	0.23	Very Good	F	VS1	60	57	402	4	4.03	2.41
32	0.23	Very Good	F	VS1	59.8	57	402	4.04	4.06	2.42
33	0.23	Very Good	E	VS1	60.7	59	402	3.97	4.01	2.42
34	0.23	Very Good	E	VS1	59.5	58	402	4.01	4.06	2.4
35	0.23	Very Good	D	VS1	61.9	58	402	3.92	3.96	2.44
36	0.23	Good	F	VS1	58.2	59	402	4.06	4.08	2.37
37	0.23	Good	E	VS1	64.1	59	402	3.83	3.85	2.46
38	0.31	Good	H	SI1	64	54	402	4.29	4.31	2.75
39	0.26	Very Good	D	VS2	60.8	59	403	4.13	4.16	2.52
40	0.33	Ideal	I	SI2	61.8	55	403	4.49	4.51	2.78
41	0.33	Ideal	I	SI2	61.2	56	403	4.49	4.5	2.75
42	0.33	Ideal	J	SI1	61.1	56	403	4.49	4.55	2.76
43	0.26	Good	D	VS2	65.2	56	403	3.99	4.02	2.61
44	0.26	Good	D	VS1	58.4	63	403	4.19	4.24	2.46
45	0.32	Good	H	SI2	63.1	56	403	4.34	4.37	2.75
46	0.29	Premium	F	SI1	62.4	58	403	4.24	4.26	2.65
47	0.32	Very Good	H	SI2	61.8	55	403	4.35	4.42	2.71
48	0.32	Good	H	SI2	63.8	56	403	4.36	4.38	2.79
49	0.25	Very Good	E	VS2	63.3	60	404	4	4.03	2.54
50	0.29	Very Good	H	SI2	60.7	60	404	4.33	4.37	2.64
51	0.24	Very Good	F	SI1	60.9	61	404	4.02	4.03	2.45
52	0.23	Ideal	G	VS1	61.9	54	404	3.93	3.95	2.44
53	0.32	Ideal	I	SI1	60.9	55	404	4.45	4.48	2.72
54	0.22	Premium	E	VS2	61.6	58	404	3.93	3.89	2.41
55	0.22	Premium	D	VS2	59.3	62	404	3.91	3.88	2.31
56	0.3	Ideal	I	SI2	61	59	405	4.3	4.33	2.63
57	0.3	Premium	J	SI2	59.3	61	405	4.43	4.38	2.61
58	0.3	Very Good	I	SI1	62.6	57	405	4.25	4.28	2.67
59	0.3	Very Good	I	SI1	63	57	405	4.28	4.32	2.71
60	0.3	Good	I	SI1	63.2	55	405	4.25	4.29	2.7
61	0.35	Ideal	I	VS1	60.9	57	552	4.54	4.59	2.78
62	0.3	Premium	D	SI1	62.6	59	552	4.23	4.27	2.66
63	0.3	Ideal	D	SI1	62.5	57	552	4.29	4.32	2.69
64	0.3	Ideal	D	SI1	62.1	56	552	4.3	4.33	2.68
65	0.42	Premium	I	SI2	61.5	59	552	4.78	4.84	2.96
66	0.28	Ideal	G	VVS2	61.4	56	553	4.19	4.22	2.58
67	0.32	Ideal	I	VVS1	62	55.3	553	4.39	4.42	2.73
68	0.31	Very Good	G	SI1	63.3	57	553	4.33	4.3	2.73
69	0.31	Premium	G	SI1	61.8	58	553	4.35	4.32	2.68
70	0.24	Premium	E	VVS1	60.7	58	553	4.01	4.03	2.44
71	0.24	Very Good	D	VVS1	61.5	60	553	3.97	4	2.45
72	0.3	Very Good	H	SI1	63.1	56	554	4.29	4.27	2.7
73	0.3	Premium	H	SI1	62.9	59	554	4.28	4.24	2.68
74	0.3	Premium	H	SI1	62.5	57	554	4.29	4.25	2.67
75	0.3	Good	H	SI1	63.7	57	554	4.28	4.26	2.72
76	0.26	Very Good	F	VVS2	59.2	60	554	4.19	4.22	2.49
77	0.26	Very Good	E	VVS2	59.9	58	554	4.15	4.23	2.51
78	0.26	Very Good	D	VVS2	62.4	54	554	4.08	4.13	2.56
79	0.26	Very Good	D	VVS2	62.8	60	554	4.01	4.05	2.53
80	0.26	Very Good	E	VVS1	62.6	59	554	4.06	4.09	2.55
81	0.26	Very Good	E	VVS1	63.4	59	554	4	4.04	2.55
82	0.26	Very Good	D	VVS1	62.1	60	554	4.03	4.12	2.53
83	0.26	Ideal	E	VVS2	62.9	58	554	4.02	4.06	2.54
84	0.38	Ideal	I	SI2	61.6	56	554	4.65	4.67	2.87
85	0.26	Good	E	VVS1	57.9	60	554	4.22	4.25	2.45
86	0.24	Premium	G	VVS1	62.3	59	554	3.95	3.92	2.45
87	0.24	Premium	H	VVS1	61.2	58	554	4.01	3.96	2.44
88	0.24	Premium	H	VVS1	60.8	59	554	4.02	4	2.44
89	0.24	Premium	H	VVS2	60.7	58	554	4.07	4.04	2.46
90	0.32	Premium	I	SI1	62.9	58	554	4.35	4.33	2.73
91	0.7	Ideal	E	SI1	62.5	57	2757	5.7	5.72	3.57
92	0.86	Fair	E	SI2	55.1	69	2757	6.45	6.33	3.52
93	0.7	Ideal	G	VS2	61.6	56	2757	5.7	5.67	3.5
94	0.71	Very Good	E	VS2	62.4	57	2759	5.68	5.73	3.56
95	0.78	Very Good	G	SI2	63.8	56	2759	5.81	5.85	3.72
96	0.7	Good	E	VS2	57.5	58	2759	5.85	5.9	3.38
97	0.7	Good	F	VS1	59.4	62	2759	5.71	5.76	3.4
98	0.96	Fair	F	SI2	66.3	62	2759	6.27	5.95	4.07
99	0.73	Very Good	E	SI1	61.6	59	2760	5.77	5.78	3.56
100	0.8	Premium	H	SI1	61.5	58	2760	5.97	5.93	3.66

Showing the first 1000 rows.

%r

printSchema(diamonds)

root
 |-- _c0: integer (nullable = true)
 |-- carat: double (nullable = true)
 |-- cut: string (nullable = true)
 |-- color: string (nullable = true)
 |-- clarity: string (nullable = true)
 |-- depth: double (nullable = true)
 |-- table: double (nullable = true)
 |-- price: integer (nullable = true)
 |-- x: double (nullable = true)
 |-- y: double (nullable = true)
 |-- z: double (nullable = true)

%python

diamonds = spark.read.format('csv').options(header='true', inferSchema='true').load('/databricks-datasets/Rdatasets/data-001/csv/ggplot2/diamonds.csv')

display(diamonds)


1	0.23	Ideal	E	SI2	61.5	55	326	3.95	3.98	2.43
2	0.21	Premium	E	SI1	59.8	61	326	3.89	3.84	2.31
3	0.23	Good	E	VS1	56.9	65	327	4.05	4.07	2.31
4	0.29	Premium	I	VS2	62.4	58	334	4.2	4.23	2.63
5	0.31	Good	J	SI2	63.3	58	335	4.34	4.35	2.75
6	0.24	Very Good	J	VVS2	62.8	57	336	3.94	3.96	2.48
7	0.24	Very Good	I	VVS1	62.3	57	336	3.95	3.98	2.47
8	0.26	Very Good	H	SI1	61.9	55	337	4.07	4.11	2.53
9	0.22	Fair	E	VS2	65.1	61	337	3.87	3.78	2.49
10	0.23	Very Good	H	VS1	59.4	61	338	4	4.05	2.39
11	0.3	Good	J	SI1	64	55	339	4.25	4.28	2.73
12	0.23	Ideal	J	VS1	62.8	56	340	3.93	3.9	2.46
13	0.22	Premium	F	SI1	60.4	61	342	3.88	3.84	2.33
14	0.31	Ideal	J	SI2	62.2	54	344	4.35	4.37	2.71
15	0.2	Premium	E	SI2	60.2	62	345	3.79	3.75	2.27
16	0.32	Premium	E	I1	60.9	58	345	4.38	4.42	2.68
17	0.3	Ideal	I	SI2	62	54	348	4.31	4.34	2.68
18	0.3	Good	J	SI1	63.4	54	351	4.23	4.29	2.7
19	0.3	Good	J	SI1	63.8	56	351	4.23	4.26	2.71
20	0.3	Very Good	J	SI1	62.7	59	351	4.21	4.27	2.66
21	0.3	Good	I	SI2	63.3	56	351	4.26	4.3	2.71
22	0.23	Very Good	E	VS2	63.8	55	352	3.85	3.92	2.48
23	0.23	Very Good	H	VS1	61	57	353	3.94	3.96	2.41
24	0.31	Very Good	J	SI1	59.4	62	353	4.39	4.43	2.62
25	0.31	Very Good	J	SI1	58.1	62	353	4.44	4.47	2.59
26	0.23	Very Good	G	VVS2	60.4	58	354	3.97	4.01	2.41
27	0.24	Premium	I	VS1	62.5	57	355	3.97	3.94	2.47
28	0.3	Very Good	J	VS2	62.2	57	357	4.28	4.3	2.67
29	0.23	Very Good	D	VS2	60.5	61	357	3.96	3.97	2.4
30	0.23	Very Good	F	VS1	60.9	57	357	3.96	3.99	2.42
31	0.23	Very Good	F	VS1	60	57	402	4	4.03	2.41
32	0.23	Very Good	F	VS1	59.8	57	402	4.04	4.06	2.42
33	0.23	Very Good	E	VS1	60.7	59	402	3.97	4.01	2.42
34	0.23	Very Good	E	VS1	59.5	58	402	4.01	4.06	2.4
35	0.23	Very Good	D	VS1	61.9	58	402	3.92	3.96	2.44
36	0.23	Good	F	VS1	58.2	59	402	4.06	4.08	2.37
37	0.23	Good	E	VS1	64.1	59	402	3.83	3.85	2.46
38	0.31	Good	H	SI1	64	54	402	4.29	4.31	2.75
39	0.26	Very Good	D	VS2	60.8	59	403	4.13	4.16	2.52
40	0.33	Ideal	I	SI2	61.8	55	403	4.49	4.51	2.78
41	0.33	Ideal	I	SI2	61.2	56	403	4.49	4.5	2.75
42	0.33	Ideal	J	SI1	61.1	56	403	4.49	4.55	2.76
43	0.26	Good	D	VS2	65.2	56	403	3.99	4.02	2.61
44	0.26	Good	D	VS1	58.4	63	403	4.19	4.24	2.46
45	0.32	Good	H	SI2	63.1	56	403	4.34	4.37	2.75
46	0.29	Premium	F	SI1	62.4	58	403	4.24	4.26	2.65
47	0.32	Very Good	H	SI2	61.8	55	403	4.35	4.42	2.71
48	0.32	Good	H	SI2	63.8	56	403	4.36	4.38	2.79
49	0.25	Very Good	E	VS2	63.3	60	404	4	4.03	2.54
50	0.29	Very Good	H	SI2	60.7	60	404	4.33	4.37	2.64
51	0.24	Very Good	F	SI1	60.9	61	404	4.02	4.03	2.45
52	0.23	Ideal	G	VS1	61.9	54	404	3.93	3.95	2.44
53	0.32	Ideal	I	SI1	60.9	55	404	4.45	4.48	2.72
54	0.22	Premium	E	VS2	61.6	58	404	3.93	3.89	2.41
55	0.22	Premium	D	VS2	59.3	62	404	3.91	3.88	2.31
56	0.3	Ideal	I	SI2	61	59	405	4.3	4.33	2.63
57	0.3	Premium	J	SI2	59.3	61	405	4.43	4.38	2.61
58	0.3	Very Good	I	SI1	62.6	57	405	4.25	4.28	2.67
59	0.3	Very Good	I	SI1	63	57	405	4.28	4.32	2.71
60	0.3	Good	I	SI1	63.2	55	405	4.25	4.29	2.7
61	0.35	Ideal	I	VS1	60.9	57	552	4.54	4.59	2.78
62	0.3	Premium	D	SI1	62.6	59	552	4.23	4.27	2.66
63	0.3	Ideal	D	SI1	62.5	57	552	4.29	4.32	2.69
64	0.3	Ideal	D	SI1	62.1	56	552	4.3	4.33	2.68
65	0.42	Premium	I	SI2	61.5	59	552	4.78	4.84	2.96
66	0.28	Ideal	G	VVS2	61.4	56	553	4.19	4.22	2.58
67	0.32	Ideal	I	VVS1	62	55.3	553	4.39	4.42	2.73
68	0.31	Very Good	G	SI1	63.3	57	553	4.33	4.3	2.73
69	0.31	Premium	G	SI1	61.8	58	553	4.35	4.32	2.68
70	0.24	Premium	E	VVS1	60.7	58	553	4.01	4.03	2.44
71	0.24	Very Good	D	VVS1	61.5	60	553	3.97	4	2.45
72	0.3	Very Good	H	SI1	63.1	56	554	4.29	4.27	2.7
73	0.3	Premium	H	SI1	62.9	59	554	4.28	4.24	2.68
74	0.3	Premium	H	SI1	62.5	57	554	4.29	4.25	2.67
75	0.3	Good	H	SI1	63.7	57	554	4.28	4.26	2.72
76	0.26	Very Good	F	VVS2	59.2	60	554	4.19	4.22	2.49
77	0.26	Very Good	E	VVS2	59.9	58	554	4.15	4.23	2.51
78	0.26	Very Good	D	VVS2	62.4	54	554	4.08	4.13	2.56
79	0.26	Very Good	D	VVS2	62.8	60	554	4.01	4.05	2.53
80	0.26	Very Good	E	VVS1	62.6	59	554	4.06	4.09	2.55
81	0.26	Very Good	E	VVS1	63.4	59	554	4	4.04	2.55
82	0.26	Very Good	D	VVS1	62.1	60	554	4.03	4.12	2.53
83	0.26	Ideal	E	VVS2	62.9	58	554	4.02	4.06	2.54
84	0.38	Ideal	I	SI2	61.6	56	554	4.65	4.67	2.87
85	0.26	Good	E	VVS1	57.9	60	554	4.22	4.25	2.45
86	0.24	Premium	G	VVS1	62.3	59	554	3.95	3.92	2.45
87	0.24	Premium	H	VVS1	61.2	58	554	4.01	3.96	2.44
88	0.24	Premium	H	VVS1	60.8	59	554	4.02	4	2.44
89	0.24	Premium	H	VVS2	60.7	58	554	4.07	4.04	2.46
90	0.32	Premium	I	SI1	62.9	58	554	4.35	4.33	2.73
91	0.7	Ideal	E	SI1	62.5	57	2757	5.7	5.72	3.57
92	0.86	Fair	E	SI2	55.1	69	2757	6.45	6.33	3.52
93	0.7	Ideal	G	VS2	61.6	56	2757	5.7	5.67	3.5
94	0.71	Very Good	E	VS2	62.4	57	2759	5.68	5.73	3.56
95	0.78	Very Good	G	SI2	63.8	56	2759	5.81	5.85	3.72
96	0.7	Good	E	VS2	57.5	58	2759	5.85	5.9	3.38
97	0.7	Good	F	VS1	59.4	62	2759	5.71	5.76	3.4
98	0.96	Fair	F	SI2	66.3	62	2759	6.27	5.95	4.07
99	0.73	Very Good	E	SI1	61.6	59	2760	5.77	5.78	3.56
100	0.8	Premium	H	SI1	61.5	58	2760	5.97	5.93	3.66

Showing the first 1000 rows.

%python

diamonds.printSchema()

%sql
-- mode "FAILFAST" will abort file parsing with a RuntimeException if any malformed lines are encountered
CREATE TEMPORARY VIEW diamonds
USING CSV
OPTIONS (path "/databricks-datasets/Rdatasets/data-001/csv/ggplot2/diamonds.csv", header "true", mode "FAILFAST")

%sql SELECT * FROM diamonds


1	0.23	Ideal	E	SI2	61.5	55	326	3.95	3.98	2.43
2	0.21	Premium	E	SI1	59.8	61	326	3.89	3.84	2.31
3	0.23	Good	E	VS1	56.9	65	327	4.05	4.07	2.31
4	0.29	Premium	I	VS2	62.4	58	334	4.2	4.23	2.63
5	0.31	Good	J	SI2	63.3	58	335	4.34	4.35	2.75
6	0.24	Very Good	J	VVS2	62.8	57	336	3.94	3.96	2.48
7	0.24	Very Good	I	VVS1	62.3	57	336	3.95	3.98	2.47
8	0.26	Very Good	H	SI1	61.9	55	337	4.07	4.11	2.53
9	0.22	Fair	E	VS2	65.1	61	337	3.87	3.78	2.49
10	0.23	Very Good	H	VS1	59.4	61	338	4	4.05	2.39
11	0.3	Good	J	SI1	64	55	339	4.25	4.28	2.73
12	0.23	Ideal	J	VS1	62.8	56	340	3.93	3.9	2.46
13	0.22	Premium	F	SI1	60.4	61	342	3.88	3.84	2.33
14	0.31	Ideal	J	SI2	62.2	54	344	4.35	4.37	2.71
15	0.2	Premium	E	SI2	60.2	62	345	3.79	3.75	2.27
16	0.32	Premium	E	I1	60.9	58	345	4.38	4.42	2.68
17	0.3	Ideal	I	SI2	62	54	348	4.31	4.34	2.68
18	0.3	Good	J	SI1	63.4	54	351	4.23	4.29	2.7
19	0.3	Good	J	SI1	63.8	56	351	4.23	4.26	2.71
20	0.3	Very Good	J	SI1	62.7	59	351	4.21	4.27	2.66
21	0.3	Good	I	SI2	63.3	56	351	4.26	4.3	2.71
22	0.23	Very Good	E	VS2	63.8	55	352	3.85	3.92	2.48
23	0.23	Very Good	H	VS1	61	57	353	3.94	3.96	2.41
24	0.31	Very Good	J	SI1	59.4	62	353	4.39	4.43	2.62
25	0.31	Very Good	J	SI1	58.1	62	353	4.44	4.47	2.59
26	0.23	Very Good	G	VVS2	60.4	58	354	3.97	4.01	2.41
27	0.24	Premium	I	VS1	62.5	57	355	3.97	3.94	2.47
28	0.3	Very Good	J	VS2	62.2	57	357	4.28	4.3	2.67
29	0.23	Very Good	D	VS2	60.5	61	357	3.96	3.97	2.4
30	0.23	Very Good	F	VS1	60.9	57	357	3.96	3.99	2.42
31	0.23	Very Good	F	VS1	60	57	402	4	4.03	2.41
32	0.23	Very Good	F	VS1	59.8	57	402	4.04	4.06	2.42
33	0.23	Very Good	E	VS1	60.7	59	402	3.97	4.01	2.42
34	0.23	Very Good	E	VS1	59.5	58	402	4.01	4.06	2.4
35	0.23	Very Good	D	VS1	61.9	58	402	3.92	3.96	2.44
36	0.23	Good	F	VS1	58.2	59	402	4.06	4.08	2.37
37	0.23	Good	E	VS1	64.1	59	402	3.83	3.85	2.46
38	0.31	Good	H	SI1	64	54	402	4.29	4.31	2.75
39	0.26	Very Good	D	VS2	60.8	59	403	4.13	4.16	2.52
40	0.33	Ideal	I	SI2	61.8	55	403	4.49	4.51	2.78
41	0.33	Ideal	I	SI2	61.2	56	403	4.49	4.5	2.75
42	0.33	Ideal	J	SI1	61.1	56	403	4.49	4.55	2.76
43	0.26	Good	D	VS2	65.2	56	403	3.99	4.02	2.61
44	0.26	Good	D	VS1	58.4	63	403	4.19	4.24	2.46
45	0.32	Good	H	SI2	63.1	56	403	4.34	4.37	2.75
46	0.29	Premium	F	SI1	62.4	58	403	4.24	4.26	2.65
47	0.32	Very Good	H	SI2	61.8	55	403	4.35	4.42	2.71
48	0.32	Good	H	SI2	63.8	56	403	4.36	4.38	2.79
49	0.25	Very Good	E	VS2	63.3	60	404	4	4.03	2.54
50	0.29	Very Good	H	SI2	60.7	60	404	4.33	4.37	2.64
51	0.24	Very Good	F	SI1	60.9	61	404	4.02	4.03	2.45
52	0.23	Ideal	G	VS1	61.9	54	404	3.93	3.95	2.44
53	0.32	Ideal	I	SI1	60.9	55	404	4.45	4.48	2.72
54	0.22	Premium	E	VS2	61.6	58	404	3.93	3.89	2.41
55	0.22	Premium	D	VS2	59.3	62	404	3.91	3.88	2.31
56	0.3	Ideal	I	SI2	61	59	405	4.3	4.33	2.63
57	0.3	Premium	J	SI2	59.3	61	405	4.43	4.38	2.61
58	0.3	Very Good	I	SI1	62.6	57	405	4.25	4.28	2.67
59	0.3	Very Good	I	SI1	63	57	405	4.28	4.32	2.71
60	0.3	Good	I	SI1	63.2	55	405	4.25	4.29	2.7
61	0.35	Ideal	I	VS1	60.9	57	552	4.54	4.59	2.78
62	0.3	Premium	D	SI1	62.6	59	552	4.23	4.27	2.66
63	0.3	Ideal	D	SI1	62.5	57	552	4.29	4.32	2.69
64	0.3	Ideal	D	SI1	62.1	56	552	4.3	4.33	2.68
65	0.42	Premium	I	SI2	61.5	59	552	4.78	4.84	2.96
66	0.28	Ideal	G	VVS2	61.4	56	553	4.19	4.22	2.58
67	0.32	Ideal	I	VVS1	62	55.3	553	4.39	4.42	2.73
68	0.31	Very Good	G	SI1	63.3	57	553	4.33	4.3	2.73
69	0.31	Premium	G	SI1	61.8	58	553	4.35	4.32	2.68
70	0.24	Premium	E	VVS1	60.7	58	553	4.01	4.03	2.44
71	0.24	Very Good	D	VVS1	61.5	60	553	3.97	4	2.45
72	0.3	Very Good	H	SI1	63.1	56	554	4.29	4.27	2.7
73	0.3	Premium	H	SI1	62.9	59	554	4.28	4.24	2.68
74	0.3	Premium	H	SI1	62.5	57	554	4.29	4.25	2.67
75	0.3	Good	H	SI1	63.7	57	554	4.28	4.26	2.72
76	0.26	Very Good	F	VVS2	59.2	60	554	4.19	4.22	2.49
77	0.26	Very Good	E	VVS2	59.9	58	554	4.15	4.23	2.51
78	0.26	Very Good	D	VVS2	62.4	54	554	4.08	4.13	2.56
79	0.26	Very Good	D	VVS2	62.8	60	554	4.01	4.05	2.53
80	0.26	Very Good	E	VVS1	62.6	59	554	4.06	4.09	2.55
81	0.26	Very Good	E	VVS1	63.4	59	554	4	4.04	2.55
82	0.26	Very Good	D	VVS1	62.1	60	554	4.03	4.12	2.53
83	0.26	Ideal	E	VVS2	62.9	58	554	4.02	4.06	2.54
84	0.38	Ideal	I	SI2	61.6	56	554	4.65	4.67	2.87
85	0.26	Good	E	VVS1	57.9	60	554	4.22	4.25	2.45
86	0.24	Premium	G	VVS1	62.3	59	554	3.95	3.92	2.45
87	0.24	Premium	H	VVS1	61.2	58	554	4.01	3.96	2.44
88	0.24	Premium	H	VVS1	60.8	59	554	4.02	4	2.44
89	0.24	Premium	H	VVS2	60.7	58	554	4.07	4.04	2.46
90	0.32	Premium	I	SI1	62.9	58	554	4.35	4.33	2.73
91	0.7	Ideal	E	SI1	62.5	57	2757	5.7	5.72	3.57
92	0.86	Fair	E	SI2	55.1	69	2757	6.45	6.33	3.52
93	0.7	Ideal	G	VS2	61.6	56	2757	5.7	5.67	3.5
94	0.71	Very Good	E	VS2	62.4	57	2759	5.68	5.73	3.56
95	0.78	Very Good	G	SI2	63.8	56	2759	5.81	5.85	3.72
96	0.7	Good	E	VS2	57.5	58	2759	5.85	5.9	3.38
97	0.7	Good	F	VS1	59.4	62	2759	5.71	5.76	3.4
98	0.96	Fair	F	SI2	66.3	62	2759	6.27	5.95	4.07
99	0.73	Very Good	E	SI1	61.6	59	2760	5.77	5.78	3.56
100	0.8	Premium	H	SI1	61.5	58	2760	5.97	5.93	3.66

Showing the first 1000 rows.

Read and Write CSV Files