Python Code Interview [Data Scientist]


I was given an account-data of an user number 7 from a CSV sheet named account.csv. I was asked to evaluate his mean balance over the last 3 months of all his accounts. (Library Pandas is recommended).
The account.csv file has the data as following:




Git Cheat Sheet

A set of selected git commands which are used almost on a daily basis. The commands are taken from the github official documentation.

Note: [] = only the content without [] ; “[]” = content inside “”



> git config –global “[name]”
> git config –global “[email address]”

Local Repository Creation:

> git init [project-name]
> git clone [url]

Before & During the push:

> git add [file]
> git commit -m “message”


> git branch
> git branch [branch-name]
> git checkout [branch-name]
> git merge [branch]
> git branch -d [branch-name]  // deleting a branch

Review History:

> git log

Redo Commits:

> git reset [commit]   // commit no. from the git log
> git reset –hard [commit]

Save Fragments:

> git stash
> git stash drop


> git push [alias] [branch]  // pushes the changes from local to the remote repository
> git pull  // updates the local repository
> git merge [bookmark]/[branch]

Suppress Tracking:

.gitignore file holds the following command to avoid temporary files, and paths:

lists of all ignored files: git ls-files –other –ignored –exclude-standard
 my git profile: my git

reference: github cheat sheet

Welcome Message

“Architecture before Artifact”

Hi, welcome to my blog. I am  a software developer, and a data science enthusiast. This is my experience, and knowledge sharing blog on programming, software development, and so on. To be clear, I am blogging to remember the stuff that I need for my job, and if anyone is eventually helped by it, then he is welcome.

My book on software engineering has been released lately. It is named, “SOA into Micro service and integration of the changes”, ISBN: 978-3-330-00366-8