Datapyx Academy

Date difference in python

Learn to differentiate between the problem and the outcome.

Data Science Tips

In order to connect to MongoDB, python uses a library known as pymongo. You can add this library to your python environment, using the below command from the Anaconda environment.

conda install pymongo

Using Sqlalchemy to store data locally and retrieving it.

We can connect to relational databases for analysing data using the pandas library as well as another additional library for implementing database connectivity. This package is named as sqlalchemy which provides full SQL language functionality to be used in python.

Dataframe multifile join and access.

Read a huge file into the dataframe just to check it out by using this trick!

Simple ways to reduce dataframe memory usage!!

Select only the required columns while loading the data frame.

Torture the data and it will confess to anything
-Ronal Coase

Some lesser know parameters you can use to be a power user of read_csv.

Also important for interview questions.

Pandas Series.fillna() function is used to fill NA/NaN values using the specified method.

Syntax: Series.fillna(value=None, method=None, axis=None, inplace=False, limit=None, downcast=None, **kwargs)

The dropna() function is used to remove missing values. Determine if rows or columns which contain missing values are removed. 0, or 'index' : Drop rows which contain missing values. 1, or 'columns' : Drop columns which contain missing value.

Hashtags

Enum is a class in python for creating enumerations, which are a set of symbolic names (members) bound to unique, constant values.