InterviewQs
Pricing
Sign in
Code Snippets
Pandas
Add new column to Pandas dataframe with default value
Change the order of columns in Pandas dataframe
SearchInput pandas column with string contains and does not contain
Concatenate Pandas dataframes (like a union function in SQL)
Count distinct in Pandas aggregation
Count the frequency a value occurs in Pandas dataframe
Create Pandas dataframe with random numbers
Create a new column in Pandas dataframe
Drop duplicate rows in Pandas based on column value
Dropping rows/columns from a Pandas dataframe
Dynamically update a plot in iPython notebook
Extract month and year from column in Pandas, create new column
Find and replace characters in Pandas dataframe columns
Convert column in Pandas dataframe to a list
Return the number of columns in a Pandas dataframe
Read data from CSV into Pandas. Output data from Pandas to CSV
Iterate over rows in a dataframe in Pandas
Merge two dataframes together in Pandas
Replace all NaN values with 0's in a column of Pandas dataframe
Get the mean and median from a Pandas column in Python
Create a pivot table from a Pandas dataframe
Pandas rolling mean in dataframe
Remove duplicate columns by name in Pandas
Remove NaN values from a Pandas series
Rename columns in a Pandas dataframe
Get the row count and column count from a Pandas dataframe
Select rows from a Pandas DataFrame based on values in a column
Select Pandas dataframe rows between two dates
Sort a dataframe in Pandas based on multiple columns
Python
Break a long line into multiple lines in Python
Concatenate two arrays (lists) in Python
Convert a list of Python dictionaries to a Pandas dataframe
Convert to number to float, int, and string in Python
Generate a for loop in Python
Create and run a function in Python
If and else statements in Python
Importing data from MongoDB into Python (Pandas)
Introduction to Linear Regression using Python
Create a bar chart in Python with Matplotlib
Create a scatter plot in Python with Matplotlib
Open a browser URL using Python
Introduction to forecasting with FB Prophet
Check if a list is empty in Python
Generate current time in Python
Access the index of a Python for loop (enumerate)
Iterate over dictionaries in Python
Slice notation in Python
Sort a Python dictionary by value or key
Check whether a Python string contains another string
Time delay in Python script (sleep)
Create a scatter plot in Python with Seaborn
Convert strings to lower and uppercase in Python
Slice a string in python (right, left, mid equivalents)
Web scraping with Python using Beautiful Soup
SQL
Create a case statement in SQL
Concatenate multiple columns in SQL
Count unique records in SQL
Finding duplicate values in a SQL table
Insert multiple rows in a single SQL query
Select data from SQL table based on multiple conditions