Data Intelligence


Chapter 87 – Interact with Google Big Query ML Pre-trained Model Dataset Using Python

Pre-trained machine learning model is getting popular with more and more LLM launched in the market, which is accepted by more users who are adopting those to boost work efficiency. As this trend moves forward, customized machine learning models might be needed with more demands. Therefore, this article would briefly walk through how an AI app can interact with a big dataset using Python for the purpose to provide pre-trained model functions to users.

Chapter 72 – Build a Blog Content Generator Using OpenAI GPT3 and Easy2Digital API

ChatGPT has been in the spotlight recently. OpenAI GPT3 has been launched since 2020. So in a way, I kind of feel it might be relevant to external factors of the cost of capital and the cost of debt rising which might tighten the business’s operational cost now or this situation might last for a while moving forward. It’s a sort of good timing for AI. Capital-driven is always able to smell the project opportunities in hands.

In this article, I would walk through how to build a blog content generator using OpenAI GPT3 and Easy2Digital APIs to automatically generate blog content in Google Sheets.

Chapter 74 – Flask App Dynamic Sitemap XML Using MongoDB

What a freezing day is like if you build a sitemap and update time by time manually. Or paying for a recurring monthly subscription for just a second work one-off is not a smart decision as well. 

If you are looking for a better way like the feeling of eating better marbling beef meat, this piece is here for you. This article is going to talk about developing dynamic sitemap xml for your Flask App. Let’s go!

JSON vs YAML, Which Data Serialization Is Better?

Any developers or programmers, or even marketers would not feel strange to a data type – JSON. It’s one of the most popular and awesome data serialization language. In fact, there is an alternative called YAML. I believe people who is famiilar with Google ads API must know this data type. In this Python knowledge hub, I would elaborate what are their pros and cons respectively, and how you can better leverage them as a developer and marketer.

Google Sheets ImportXML – Automatically Scrape Web and Collect Product Price Info

I am always on the lookout for a unique angle to use freely available or potentially scrapable data sources. Also, It’s indeed frustrating that you have, admittedly, spent hours upon hours trying to learn Python for writing simple web scraper applications, and implementing web scraping automatically, however, at the end you can only discover the data isn’t accessible, interesting or differentiated enough from what’s already out there.

If you just want to automate updating the profit calculator of your eCommerce business, thankfully, there is an easier way to collect data from the web without spending that much hours: Google Sheets ImportXML Function.

Chapter 76 – Generate the Object Feature Importance Using Scikit learn and Random Forest

The random forest algorithm has been applied across a number of industries, allowing them to make better business decisions. Some use cases include high credit risk analysis and product recommendation for cross-sell purposes.

In this piece, I would briefly walk you through several methods of generating feature importance by using classic red wine quality validator dataset. By the end of this chapter, you can have a basic concept to use Random forest applied to your projects and compare the result amongst different methods.

Python Robotic Process Automation – Def Functions, Import Custom Modules to Create a Multi-functional Bot

Robotic process automation, or RPA is not only a technology, but also it’s a vital mindset to think of how to leverage bots that can do things like understand what’s on a screen, complete the right keystrokes, navigate systems, identify and extract data, and perform a wide range of defined actions. In Python, the def function is one of the key components to deploy, and create multi-functional bot to complete a whole process of task. So this is why the article is about today.

Chapter 75 – CRUD Notion Page Content Using Notion API & Python

ChatGPT is super blink recently because it transforms our life and work style upside down. Likey I am incline to use OpenAI API GPT3 and GPT 3.5 API as it can totally automate my life and off load repetitive work that wastes time but is critical. Using both of them is just like eating a piece of buttery and marbling rich Wagyu beef.

In fact, we never only have one option. Between API and AI chatbot, Notion AI which is using Anthropic’s Claude generative AI model can perfectly provide you semi-auto AI experience with its AI writing and API capability. Although it’s not as crunch as GPT 3, it impresses users with clear, thin and straight using experience.

In this piece, I would walk you through how to retrieve Notion AI content from Notion private page, and update new content using Notion API.

Chapter 86 – Tips to Create AMP Pages for Web App using Python, HTML, CSS, JS

AMP page weight has been downsized after Google has sunset AMP icon in SERP and the function of automatically redirecting traffic to target website page in mobile end. However, it’s still one of the most important snippets to increase exposure and grow traffic from search and discover channels as you might be aware from the search console panel..

So in this piece, I would briefly walk through how to create AMPs for your web app mobile side users usng Python as the sample. By the end of this piece, you can learn the core components and are able to start your own projects using the module in this chapter.

Chapter 63 – Company Financial News Scraper for the Top-down Analysis Using Easy2Digital News API

Industry and company up-to-date news helps you keep pace with the stock company you invested. Nevertheless, it is time consuming if you check one by one out of your investment dashboard. I daresay you feel excited if your stock dashboard can automatically refresh the company news every day using a financial news scraper. As a result, you can make decision always along with top-down industry and company news.

In this article, I’m going to introduce Easy2Digital financial news API 1.0 with the API script sample. With this API, you can build a financial news scraper for your specific collection of company symbols and integrate it with your stock monitor.

Chapter 70 – Build a Discord Bot Using Python, Hikari, Lightbulb, MongoDB

Discord is a social media platform where large numbers of people can interact in the form of a community. Currently, it’s the most harmonious platform for NFT projects as they’re community-oriented. Furthermore, the platforms facilitate NFTs trading or brand NFT marketing through their freedom communication features and integration space with Crypto wallets, such as Collabland, Metamask. Last but not least, it also facilitates NFT gating in private communities.

In this article, I would walk through how to build a discord bot to further increase communication and navigation efficiency using Python, MongoDB, Hikari, and Lightbulb.

Chapter 71 – Build Online Shop Product Detail Pages or PDP Using Flask, Javascript, Bootstrap

Product detail pages are the main functional substances for several critical purposes in business operations. Customers learn about your product and IWOM from PDPs, and it has a high weight to make customers determine whether to check out or not eventually. Online marketplace and social commerce platforms like Google Shopping, and TikTok shop open API integration for merchants to list products and generate organic traffic by connecting with PDP data feed. Marketers put effort to optimise the product conversion rate to increase investment ROI as PDP is one of the most important parts of the conversion funnel.

In this piece, I would attempt to go through how to build product detail pages in bulk using flask, Javascript, and Python from a Python developer perspective. If you are interested in building PDPs using flask, this piece would put you in the right shoes.

Chapter 69 – Build A Flask User Login System Using PyMongo

In this article, I would walk through how to use one of the MongoDB python modules – PyMongo to build a Flask user login system. The integration and development logic is similar to the one using the SQLALCHEMY database, however, there are some configuration and setting details that are unique and different from using MongoDB. 

If you like to use the non-SQL database to build your Flask user login system and manage your customer database, this piece would be your cup of tea.

Chapter 67 – Linkedin User Profile Scraper Using Easy2Digital API, Company Name, Job Title

You have a list of company names and key contact point names, and you want to find their Linkedin profiles before outreach. The question is how to make it done automatically and save the cost as much as possible.

This is the purpose of the article here. I would walk through how to use Easy2Digital API of Linkedin profile scraper and very simple Python lines to scrape the Linkedin profile links.

Chapter 66 – Flask Application Database Using MongoDB Atlas and Python to Better Big Data Management

The non-SQL database is more advanced and capable of handling big data with dynamic schema features. In the era of Big Data, the non-SQL server seems to have a bright future, although in some cases, end-to-end business data solutions are still suitable to utilize SQL databases.

In this article, I will go through how to leverage MongoDB Altas integrating with Flask Applications using Python. It’s right for you to apply this approach to application development.

Chapter 64 – Etsy Product Scraper for Price Anchoring Reference Using Easy2Digital API

For the finance and marketing strategy, price anchoring consideration is critical. In terms of your product value-focused, either product functional value or trading value, or both of value on one product do need market price anchoring to set proper pricing. 

Etsy is listed in the NASDAQ Global Select security exchange, also it’s the largest craft and hand-made seller online B2C and C2C marketplace. It doesn’t matter whether your brand product pricing is higher or lower than a similar craft and hand-made individual top-selling brand in the same category. Conversely, the main question should be why your product pricing is supposed to sit at a higher or lower pricing point than theirs. Whether this strategy can convince your target customer to buy in.

In this article, I’ll go to share the ingredients to build an Etsy product scraper. By the end of this, you can refer to the method and also leverage Easy2Digital API to fetch the data.

Chapter 65 – Flask Search Bar Plus Dynamic Data Table Return Using Pandas and Python

A search box or search bar is a popular function applied on Web applications for visitors to look up things you are finding. A great UX search function can hugely shorten the information search journey and enhance the user experience. In this article, I will go through how to set up a fundamental search function using Flask and return data in the panda’s data frame.

Chapter 62 – Intrinsic Value Scraper for Comparing BVPS vs Price per Share Using Easy2Digital API

Discounted value of the cash that can be taken out of a business during its remaining life, is a well-known intrinsic value explanation offered by Warren Buffett. In fact, the intrinsic value calculator has a top-down and simple way out although the bottom-up and in-depth one requires more input. 

In this article, I’ll walk you through how to leverage Easy2Digital API data to build an intrinsic value scraper using Python. By the end of this piece, you can quickly scrape and consolidate 5 metrics in bulk, and find out if the symbol candidate from your list is a potential undervalued one to add to the investment queue by BVPS vs price per share. 

Chapter 60 – Stock Symbol Data Scraper for Financial Ratio Analysis

Along with interest rates rising against inflation, global stock markets have been bearish and obviously continue to drop as inflation kind of hovers over in a higher position and might last for a long period before pushing it down. 

From a standpoint of the cost of buying in the stock market, this is absolutely a good chance to observe the momentum and estimate the time bottoming out. It’s because this timing is easier for us to analyze and identify undervalued companies compared to the previous QE era, notably now companies are confronting the increasing cost of debt and economic recession challenges. Who can stay still, who is the ACE? 

If you are an investor in mutual funds, ETFs, trusts, Stock, and so on. This article can help you build a stock symbol data scraper for analyzing financial ratios in bulk using Python, FMP, and Easy2Digital API.

Chapter 59 – Using Python and Gmail SMTP to Automate Sending Personalised Emails

From a marketing perspective, organic traffic is not just limited to SEO. Conversely, it covers a wide range of traffic sources as long as the majority percentage of investment is focused on manpower. They can be social media, partnership, VoD, email and so on. Compared to these channels in terms of organic traffic, email marketing is still the most efficient approach in one-to-one conversation marketing with a higher new customer conversion rate and lower cost per retention notably in the eCommerce and B2B sectors.

Basically we have two options out there if leveraging the magic of email marketing – Paid and Free platform. If a long term investment return is your preference rather than you being restricted by the platform recurring payment fees, this article can fit your stomach.

This piece expands on how to save 90% of your manual email marketing campaign time by using Gmail and Python script. By the end of this article, you and your team can write a Python script to build an email blast system using Gmail.

Chapter 57 – Build the User Account Login and Authentication System Using Flask, SQLAlchemy

User-based and customer-oriented are super popular in nowadays’ business model. Apart from web 2.0, web 3.0 more emphasizes decentralisation and gives back more data authority and data management to current users. So an user-centralization approach trend is arising and it just would be more important. So regarding buidling an application using Flask, user login and authentication system is a basic function it must have. Today is on how to leverage Flask login manager and build one in your application.

1 2 4