Most data science students only learn to import CSV, but at work, you have to deal with multiple data formats, and things can get complicated if you are doing it for the first time. In this guide, we will be focusing on importing CSV, Excel, SQL, HTML, and JSON datasets.
SQL
0
What is your age?
1
1
What is your gender?
2
2
What country do you live in?
3
3
If you live in the United States, which state or territory do you live in?
4
4
Are you self-employed?
5
HTML
0
World
10436627754
1
China
3052435000
2
India
1736068837
3
United States
547948656
4
Brazil
379776348
CSV
0
1
01-01-2018
1
2
02-01-2018
2
3
03-01-2018
3
4
04-01-2018
4
5
05-01-2018
EXCEL
0
1949
Harry S. Truman
1
1950
Harry S. Truman
2
1951
Harry S. Truman
3
1952
Harry S. Truman
4
1953
Dwight D. Eisenhower
JSON
0
{'danceability': 0.749, 'energy': 0.839, 'key': 6, 'loudness': -4.8469999999999995, 'mode': 1, 'spe…
1
{'danceability': 0.5730000000000001, 'energy': 0.581, 'key': 10, 'loudness': -9.026, 'mode': 0, 'sp…
2
{'danceability': 0.8, 'energy': 0.719, 'key': 7, 'loudness': -6.2620000000000005, 'mode': 1, 'speec…
3
{'danceability': 0.778, 'energy': 0.632, 'key': 8, 'loudness': -6.415, 'mode': 1, 'speechiness': 0.…
4
{'danceability': 0.797, 'energy': 0.852, 'key': 8, 'loudness': -5.202, 'mode': 1, 'speechiness': 0.…
5
{'danceability': 0.743, 'energy': 0.663, 'key': 2, 'loudness': -8.47, 'mode': 1, 'speechiness': 0.0…
6
{'danceability': 0.915, 'energy': 0.551, 'key': 8, 'loudness': -10.49, 'mode': 1, 'speechiness': 0.…
7
{'danceability': 0.798, 'energy': 0.835, 'key': 9, 'loudness': -3.832, 'mode': 1, 'speechiness': 0.…
8
{'danceability': 0.8270000000000001, 'energy': 0.804, 'key': 9, 'loudness': -5.846, 'mode': 1, 'spe…
9
{'danceability': 0.8300000000000001, 'energy': 0.707, 'key': 2, 'loudness': -5.777, 'mode': 1, 'spe…
0
0.749
0.839
1
0.573
0.581
2
0.8
0.719
3
0.778
0.632
4
0.797
0.852