Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

Derek Derek
Derek Derek
8,744 Points

How 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!

Tim Knight
Tim Knight
28,863 Points

Derek, 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?

Derek Derek
Derek Derek
8,744 Points

Tim 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
Tim Knight
28,863 Points

If 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
Derek Derek
8,744 Points

I got it! Thank you so much