Data Science - My 30 day Challenge starting on 19th Oct 23

Community 30-Day Challenge
1

I am learning Data Science starting with Analyst specialist path because I have background in accounting so there is a bit of transferable skills that I can utilize in this path.

I am changing my career into data science so I need to learn SQL, Python and BI visualization tools. I do have some experience and knowledge about Power BI and Tableau but programming is a new skill that I will be focusing on acquiring as part of this course.

I am dedicating considerable amount of time (6 to 8 hours per day) to learn, train and practice data science. And hoping this 30 day challenge may keep my accountability in check by exercising my discipline and showing progress every day.

2 Likes
2

Day 1 was pretty good.

I could cover 3% of the course. More importantly I am enjoying learning the basics.

Missing data - (understanding different kinds of missing data is phenomenal :joy: :joy: :joy:)

  • Missing at random (MAR)
  • Missing Completely at Random (MCAR) and
  • Missing Not at Random (MNAR)
2 Likes
3

Day 2 was as goodā€¦

I covered another 2% of the courseā€¦ There are a lot of new concepts introducedā€¦

The focus was mainly on vizā€¦

1 Like
4

Day 3 was a slow day, although I completed a chapter

Todays chapter on types of data analysis using statistics and Bias in Data Analysis

Descriptive Data Analysis

Exploratory Data Analysis

Inferential Data Analysis

Causal Data Analysis

Predictive Data Analysis

1 Like
5

Day 4 was learning about SQLite - SQLite is light SQL version that Codecademy uses for training for its simplicity.

Learnt to install GIT Bash and install SQLliteā€¦ as well as to make it workā€¦ not a difficult taskā€¦ :slight_smile:

Also learnt 6 commands in SQLiteā€¦

CREATE TABLE table_name (
column_1 data-type,
column_2 data-type,
column_3 data-type
);

Insert into values in order -
INSERT INTO table_name
VALUES (value1, value2);

Insert into values by name -
INSERT INTO table_name (column_1, column_2, column_3)
VALUES
(column_1_value1, column_2_value1, column_3_value1)
(column_1_value2, column_2_value2, column_3_value2);

DELETE FROM table_name
WHERE column_1 = value1

ALTER TABLE table_name
ADD column_1 data-type;

UPDATE table_name
SET column_1 = value1
WHERE column_any = some-value

Also, learnt about column constraints

PRIMARY KEY (there will be only one PRIMARY KEY column per table allowed)
UNIQUE (multiple UNIQUE columns per table allowed)
DEFAULT
NOT NULL

1 Like
6

Day 5 - 12%

Although the coverage was not as much compared to yesterday, there were quite a lot of commandsā€¦

I have looked at queries - it included logical operators, comparison operators, wildcard etc.

AND, OR, BETWEEN, LIKE, AS, % and _ wildcards, DISTINCT, LIMIT, NULL clausesā€¦

It also included aggregators such as SUM(), COUNT(), AVG(), MAX(), MIN(), ROUND() and usage of clauses such as WHERE BY, ORDER BY, GROUP BY and HAVINGā€¦ column references such as using column numbers instead of column names in Group by or order by clausesā€¦

7

Day 6 - 16%

Done with SQL foundations and started with Python fundamentals

introduction was fun and simpleā€¦ easy to followā€¦ it was nice to work on the little projectsā€¦ where you start with basic program writing then adding functions etcā€¦

8

Day 7 - 18%

Introduced to Python functionsā€¦ data types, lists, variables, conditional statementsā€¦

9

Day 8 - 21%

Python Control Flow

Python Lists and List Comprehensions

Python Loops

Projects

10

Day 9 - 24%

Python fundamentals for Data Science Part I covered.

It is cool that I could remember most of the commands to practice and work out the project.

It is slower but developing stronger skill setā€¦

11

Day 10 - 25%

It was way small learning for my likingā€¦ Will get back onā€¦

12

Day 11 - 25%

Still at 25%ā€¦ got caught up with weekend chores and although did some studyingā€¦ it wasnā€™t progressing as muchā€¦ APIs are dry subjectā€¦

13

Day 12 - 26%

As promised to myself, I did work on this learning although I had another pressing issue to attend toā€¦ Now that has been sorted out, I can start to dedicate my full attention again on this courseā€¦

1 Like
14

Day 13 - 27%

Concepts are a bit more time consuming but I am still going at themā€¦ at a slow pace than I would wantedā€¦

15

Day 14 - didnā€™t check the %ā€¦ most probably it didnā€™t move muchā€¦ becauseā€¦

all of the sudden codecademy got me to solve Caesar Cipher and Vigenere Vipher encrypted and decrypted messagesā€¦

I feel these are much deeper concepts than what it has been educated so farā€¦ It is not a complaint but I wasnā€™t expecting this as soon as nowā€¦ but it is allowing me to dig deeper to understand the concepts and search web to find out different ways others have approached these problemsā€¦

It is important to accept that most of this is part of learning processā€¦ yes, it makes me feel I have so much to learnā€¦ but, yes I have to learn bit by bitā€¦

I found the below page helpful in understanding the problem logic and coding logicā€¦

16

Day 15 - Still at 27% - however I am practicing using cipher projectsā€¦

It is a bit overwhelming knowing that there is a lot that I donā€™t knowā€¦ but I am willing to learnā€¦

I am also learning to problem solveā€¦ in order to do that we need to understand the problem first in a conceptual wayā€¦

Once we know the problem conceptually then we can solve it step by stepā€¦ that is where programming comes alongā€¦

1 Like
17

Day 16 - No progress on Codecademy material as I am practicing the codingā€¦

I know I need to move on as there is lot more to learn and things will start to make sense as I progressā€¦

1 Like
18

Day 17 - Looking at some video lectures to understand the concepts more clearlyā€¦

I found this wonderful video lecturesā€¦ the teacher is great and delivery is awesomeā€¦ So, I have decided to complete this video lecturesā€¦

1 Like
20

Day 18 - 28%

Still trying to work out the code logic for barry is the spy - how to code for the space in between the wordsā€¦ it is a logical nightmare for me so farā€¦

anywayā€¦ I googled around and finally understood a way to deal with thisā€¦

def encryptor(message, keyword):
letters = ā€˜abcdefghijklmnopqrstuvwxyzā€™
keyword_message = ā€œā€
cipher_message = ā€œā€
j = 0
for i in range(len(message)):
if message[i] in letters:
keyword_message += keyword[j % len(keyword)]
j += 1
elif message[i] not in letters:
keyword_message += message[i]
print("The transformed keyword is: "+keyword_message)
for i in range(len(message)):
if message[i] in letters:
cipher_index = (letters.index(message[i])-letters.index(keyword_message[i])) % 26
cipher_message += letters[cipher_index]
elif message[i] not in letters:
cipher_message += message[i]
return cipher_message

message = ā€œbarry is the spyā€
keyword = ā€œdogā€
print("The cipher message is: "+encryptor(message, keyword))

ā€œFriendsā€ Keyword decryptor message code

def decryptor(message, keyword):
letters = ā€˜abcdefghijklmnopqrstuvwxyzā€™
keyword_message = ā€œā€
cipher_message = ā€œā€
j = 0
for i in range(len(message)):
if message[i] in letters:
keyword_message += keyword[j % len(keyword)]
j += 1
elif message[i] not in letters:
keyword_message += message[i]
print("The transformed keyword is: "+keyword_message)
for i in range(len(message)):
if message[i] in letters:
cipher_index = (letters.index(keyword_message[i])+letters.index(message[i])) % 26
cipher_message += letters[cipher_index]
elif message[i] not in letters:
cipher_message += message[i]
return cipher_message

message = ā€œtxm srom vkda gl lzlgzr qpdb? fepb ejac! ubr imn tapludwy mhfbz cza ruxzal wg zztylktoikqql!ā€
keyword = ā€œfriendsā€
print("The cipher message is: "+decryptor(message, keyword))

21

Day 19 - finally moved past the exercises - I am still not confident about writing loops and iterating values through loopsā€¦ I am hoping this will come with practiceā€¦

1 Like