Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Derek Derek
8,744 PointsHow to get started with independent research on Big Data
Hello, Treehouse community!
I am a novice in big data and am currently looking for some cool ideas to develop my skills in the area of databases. I've googled some websites that provide free datasets, but I am having trouble using them. For example, since I am really interested in soccer, I have downloaded a dataset from
https://www.kaggle.com/hugomathien/soccer
but when I open the downloaded file, I am only given random numbers and zeros like below:
5351 4c69 7465 2066 6f72 6d61 7420 3300 0400 0101 0040 2020 0010 ed35 0000 b1f4 0000 0000 0000 0000 0000 0009 0000 0004 0000 0000 0000 0000 0000 0001 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0010 ed35 002d e60a 0500 0000 0103 fb00 0000 0011 03fb 0216 02d6 01eb 01eb 0000 0000 0000
I have taken some python courses here at Treehouse but no courses ever dealt with such random-looking data, so I was confused as to how to get started. Thank you for reading, and I appreciate your help!
Derek Derek
8,744 PointsTim Knight Yes it is. I downloaded database.sqlite (9.64 MB). Am I looking at a wrong file? Which one should I download?
1 Answer
Tim Knight
28,888 PointsIf you're wanting access to the plaintext data I'd see if they have a CSV format of the data. If all you have is SQLite you can use a tool like http://sqlitebrowser.org/ to navigate through the data. You won't be able to just use a text editor to view SQLite data. A SQLite editor will let you write SQL queries to navigate through your data though.
Derek Derek
8,744 PointsI got it! Thank you so much
Tim Knight
28,888 PointsTim Knight
28,888 PointsDerek, does the file you're trying to open have a file extension? What type of file is it? It looks to me like you're trying to open a compressed or executable file within a text editor. I see on the website that they have a file called soccor.zip, is that the file you're trying to review?