Programming Archives - Serhii Puzyrov

Google Cloud Datastore – A Simple And Fast NoSQL Database For Your Project (with Python API examples)

Google Cloud Platform has a lot of different data storing options, but if you are looking for a simple NoSql solution with fast read-inserts – Google DataStore will be the right choice here. If you are writing some web application – Google Datastore will help you to easily handle your app’s data like data of Read more about Google Cloud Datastore – A Simple And Fast NoSQL Database For Your Project (with Python API examples)[…]

How To Deploy A Simple Flask App On Google App Engine In Couple Of Minutes

Google App Engine is a Google Cloud service which lets you to deploy your web site or web application and share it with other world in a very simple way without carrying about all these complicated server stuff and infrastructure. In this guide we will deploy our own app, the whole process can be described Read more about How To Deploy A Simple Flask App On Google App Engine In Couple Of Minutes[…]

Pandas Python Library = Excel On Steroids (tutorial for beginners)

People that never tried programming often think, that programming is something very complicated and hard to start. Honestly I had the same thinking until I tried python – one of the most intuitive programming languages with a low entry barrier. While learning programming it’s important to be able instantly try your knowledge in practice. In Read more about Pandas Python Library = Excel On Steroids (tutorial for beginners)[…]

How You Can Create Your Own Bot Using Selenium WebDriver And Python

When I created my first bot with Selenium library – I could not believe how easy and intuitively Selenium is. It’s like writing a scenario for a movie – You just describing step by step what should be going on. In my particular case – Selenium helped me to automate reporting of some advertising platforms, Read more about How You Can Create Your Own Bot Using Selenium WebDriver And Python[…]

How To Automate Facebook Ads Reporting In Google Data Studio With Python And FB Marketing API

If You ever wanted to create a dashboard with Facebook Ads data – You probably had an issue with data connectors. The most popular like “Supermetrics” – costs money, but You can try to create your own free solution. There is a scheme of my solution: As you can see on the scheme – there Read more about How To Automate Facebook Ads Reporting In Google Data Studio With Python And FB Marketing API[…]

3 Helpful Python Functions For Data Manipulation

Working with Pandas dataframes It`s often needed to reshape the data, in order to prepare it for further analysis, visualization or library that requires particular data form. I`ve decided to share with you some functions that I used a lot working with customer journey paths, exported from Google Analytics. For experienced data scientist that could Read more about 3 Helpful Python Functions For Data Manipulation[…]

Google BigQuery API Request (Python)

Google BigQuery is a great big-data tool, which let you to store a huge amount of data in cloud, and manipulate it with SQL queries. But there are situations, when you want to get that data to your python environment for more advanced purposes like machine learning, which is possible thanks to numerous python libraries. Read more about Google BigQuery API Request (Python)[…]

Google Analytics API Request (Python)

Google Analytics Reporting Api gives you a lot of possibilities like downloading your data without sampling, exporting it to databases or just ability to work with raw data (for example in Jupyter Notebooks). The easiest way I`ve found to make a API request to Google Analytics: 1. Create a Google Cloud Platform project and enable Read more about Google Analytics API Request (Python)[…]

Parallel Coordinates For Multidimensional Data Visualization

Parallel coordinates were invented in far 1885 by French engineer and mathematician Philbert Maurice d’Ocagne. When I discovered this way of visualization – I was really impressed how it allows to visualize such a complicated thing as multidimensional data in a simple and intuitive way. This is how I visualized few dimensions of Mobile App Read more about Parallel Coordinates For Multidimensional Data Visualization[…]

New vs Returning Client-ID Variable In Google Tag Manager

Sometimes, while configuring tags in Google Tag Manager, we want to know if the user visiting our site for the first time or not. Variable like that can be very useful if we want to fire some of our tags only for new or returning users, or assign different conversion value of the same conversion Read more about New vs Returning Client-ID Variable In Google Tag Manager[…]

Why Google Apps Script Is Simple

Google Apps Script is an environment, from which you can interact with Google G Suite Services like Google Docs, Sheets, Forms and so on. It can be really helpful if you want to automate some of your routine job. With some basic knowledge of JavaScript you can create really great things, that would save you a lot of Read more about Why Google Apps Script Is Simple[…]