Unlocking the Power of GPT-4: An Introduction to Free ChatBot AI

As technology advances at an unprecedented rate, there is an increasing demand for tools that can simplify, innovate, and augment human experiences. One such technological marvel is ChatGPT, based on OpenAI’s GPT-4 architecture. With the introduction of the Free ChatBot AI, a complimentary version of ChatGPT, everyone can now experience the power of conversational AI without breaking the bank. In this post, we will explore what this free ChatBot AI is and how you can harness its capabilities.

What is Free ChatBot AI?

Free ChatBot AI is a conversational model based on OpenAI’s cutting-edge GPT-4 technology. It retains much of the paid version’s functionality, accuracy, and contextual understanding but is offered without a price tag. The motivation behind introducing a free version was to democratize access to AI, ensuring that businesses, developers, students, and hobbyists alike can taste what state-of-the-art AI conversational models can achieve.

How to use Free ChatBot AI?

Using Free ChatBot AI is a straightforward process:

Access: Navigate to the official website of the Free ChatBot AI version. It’s not necessary to create a login to use.

Prompt: Start by entering a prompt or a question. For instance, you might type, “Tell me a fun fact about dolphins.” The more specific and clear your prompt, the better and more accurate the response you can expect.

Response: After inputting your prompt, the AI will process the information and provide an answer in seconds. Seeing the model generate responses that often feel incredibly human-like is fascinating.

Refinement: If the answer isn’t quite what you expected, you can refine your question or ask follow-up questions to get the desired information.

Begin with any prompt you choose. Let’s try this: “Write a persuasive email to convince potential customers to try our service. My service is IT consulting”.

You can ask Free ChatBot AI to create code. Let’s try this: “Create a Python function that takes in a list of numbers and returns the average, median, and mode of the list. The function should be able to handle large datasets and return the results as variables”.

You can create prompts to ask Free ChatBot AI to act like you want. Let’s try this: click “+ New Prompt” and write, “I want you to act as an English translator, spelling corrector and improver. I will speak to you in any language and you will detect the language, translate it and answer in the corrected and improved version of my text, in English. I want you to replace my simplified A0-level words and sentences with more beautiful and elegant, upper level English words and sentences. Keep the meaning same, but make them more literary. I want you to only reply the correction, the improvements and nothing else, do not write explanations.”

Click save.

Now you have the prompt saved. If you insert “/” in the text bar, the prompt you save will appear. Select one of them and start the prompt.

You can import and export to a file all prompt histories and configurations. I save my prompts to share with you in this link.

You can also search on Google by clicking in the icon below selecting “Google Search”. After that you can ask gpt to create you text.

There are many other options: Clear the conversations, change the theme to light or dark mode, create folders to organize your chats and prompts, and much more.


The Free ChatBot AI, based on the GPT-4 architecture, is a testament to our strides in the AI world. It provides a unique opportunity for many to interact with and benefit from advanced AI without any financial commitment. Whether you’re a curious individual, a student, a developer, or a business owner, this tool can revolutionize how you seek information, automate tasks, or engage with users. Explore the fascinating world of conversational AI with Free ChatBot AI. What do you think about it? I would be happy to hear from you!

What are you waiting for? Go to the Free ChatBot AI app and have fun!

That’s it for today!

Data Wrangler in Microsoft Fabric: A New Tool for Accelerating Data Preparation. Experience the Power Query Feel but with Python Code Output

In the modern digital era, the importance of streamlined data preparation cannot be emphasized enough. For data scientists and analysts, a large portion of time is dedicated to data cleansing and preparation, often termed ‘wrangling.’ Microsoft’s introduction of Data Wrangler in its Fabric suite seems like an answer to this age-old challenge. It promises Power Query’s intuitiveness and Python code outputs’ flexibility. Dive in to uncover the magic of this new tool.

Data preparation is a time-consuming and error-prone task. It often involves cleaning, transforming, and merging data from multiple sources. This can be a daunting task, even for experienced data scientists.

What is Data Wrangler?

Data Wrangler is a state-of-the-art tool Microsoft offers in its Fabric suite explicitly designed for data professionals. At its core, it aims to simplify the data preparation process by automating tedious tasks. Much like Power Query, it offers a user-friendly interface, but what sets it apart is that it can generate Python code as an output. As users interact with the GUI, Python code snippets are generated behind the scenes, making integrating various data science workflows easier.

Advantages of Data Wrangler

  1. User-Friendly Interface: Offers an intuitive GUI for those not comfortable with coding.
  2. Python Code Output: Generates Python code in real-time, allowing flexibility and easy integration.
  3. Time-Saving: Reduces the time spent on data preparation dramatically.
  4. Replicability: Since Python code is generated, it ensures replicable data processing steps.
  5. Integration with Fabric Suite: Can be effortlessly integrated with other tools within the Microsoft Fabric suite.
  6. No-code to Low-code Transition: Ideal for those wanting to transition from a no-code environment to a more code-centric one.

How to use Data Wrangler?

You have to click on Data Science inside the Power BI Service.

You have to select the Notebook button.

You have to insert this code above after the upload of the CSV file in the LakeHouse.

import pandas as pd

# Read a CSV into a Pandas DataFrame from e.g. a public blob store
df = pd.read_csv("/lakehouse/default/Files/Top_1000_Companies_Dataset.csv")

You have to click in the Lauch Data Wrangler and then select the data frame “df”.

On this screen, you can do all transformations you need.

In the end this code will be generate.

# Code generated by Data Wrangler for pandas DataFrame

def clean_data(df):
    # Drop columns: 'company_name', 'url' and 6 other columns
    df = df.drop(columns=['company_name', 'url', 'city', 'state', 'country', 'employees', 'linkedin_url', 'founded'])
    # Drop columns: 'GrowjoRanking', 'Previous Ranking' and 10 other columns
    df = df.drop(columns=['GrowjoRanking', 'Previous Ranking', 'job_openings', 'keywords', 'LeadInvestors', 'Accelerator', 'valuation', 'btype', 'total_funding', 'product_url', 'growth_percentage', 'contact_info'])
    # Drop column: 'indeed_url'
    df = df.drop(columns=['indeed_url'])
    # Performed 1 aggregation grouped on column: 'Industry'
    df = df.groupby(['Industry']).agg(estimated_revenues_sum=('estimated_revenues', 'sum')).reset_index()
    # Sort by column: 'estimated_revenues_sum' (descending)
    df = df.sort_values(['estimated_revenues_sum'], ascending=[False])
    return df

df_clean = clean_data(df.copy())

After that, you can create or add to a pipeline or schedule a moment to execute this transformation automatically.

Data Wrangler Extension for Visual Studio Code

Data Wrangler is a code-centric data cleaning tool integrated into VS Code and Jupyter Notebooks. Data Wrangler aims to increase the productivity of data scientists doing data cleaning by providing a rich user interface that automatically generates Pandas code and shows insightful column statistics and visualizations.

This document will cover how to:

  • Install and setup Data Wrangler
  • Launch Data Wrangler from a notebook
  • Use Data Wrangler to explore your data
  • Perform operations on your data
  • Edit and export code for data wrangling to a notebook
  • Troubleshooting and providing feedback

Setting up your environment

  1. If you have not already done so, install Python.
    IMPORTANT: Data Wrangler only supports Python version 3.8 or higher.
  2. Install Visual Studio Code.
  3. Install the Data Wrangler extension for VS Code from the Visual Studio Marketplace. For additional details on installing extensions, see Extension Marketplace. The Data Wrangler extension is named Data Wrangler, and Microsoft publishes it.

When you launch Data Wrangler for the first time, it will ask you which Python kernel you would like to connect to. It will also check your machine and environment to see if any required Python packages are installed (e.g., Pandas).

Here is a list of the required versions for Python and Python packages, along with whether they are automatically installed by Data Wrangler:

NameMinimum required versionAutomatically installed

* We use the open-source regex package to be able to use Unicode properties (for example, /\p{Lowercase_Letter}/), which aren’t supported by Python’s built-in regex module (re). Unicode properties make it easier and cleaner to support foreign characters in regular expressions.

If they are not found in your environment, Data Wrangler will attempt to install them for you via pip. If Data Wrangler cannot install dependencies, the easiest workaround is to run the pip install and then relaunch Data Wrangler manually. These dependencies are required for Data Wrangler such that it can generate Python and Pandas code.

Connecting to a Python kernel

There are currently two ways to connect to a Python kernel, as shown in the quick pick below.

1. Connect using a local Python interpreter

If this option is selected, the kernel connection is created using the Jupyter and Python extensions. We recommend this option for a simple setup and a quick way to start with Data Wrangler.

2. Connect using Jupyter URL and token

A kernel connection is created using JupyterLab APIs if this option is selected. Note that this option has performance benefits since it bypasses some initialization and kernel discovery processes. However, it will also require separate Jupyter Notebook server user management. We recommend this option generally in two cases: 1) if there are blocking issues in the first method and 2) for power users who would like to reduce the cold-start time of Data Wrangler.

To set up a Jupyter Notebook server and use it with this option, follow the steps below:

  1. Install Jupyter. We recommend installing the accessible version of Anaconda with Jupyter installed. Alternatively, follow the official instructions to install it.
  2. In the appropriate environment (e.g., in an Anaconda prompt if Anaconda is used), launch the server with the following command (replace the jupyter token with your secure token):
    jupyter notebook --no-browser --NotebookApp.token='<your-jupyter-token>'
  3. In Data Wrangler, connect using the address of the spawned server. E.g., http://localhost:8888, and pass in the token used in the previous step. Once configured, this information is cached locally and can automatically be reused for future connections.

Launching Data Wrangler

Once Data Wrangler has been successfully installed, there are 2 ways to launch it in VS Code.

Launching Data Wrangler from a Jupyter Notebook

If you are in a Jupyter Notebook working with Pandas data frames, you’ll now see a “Launch Data Wrangler” button appear after running specific operations on your data frame, such as df.head(). Clicking the button will open a new tab in VS Code with the Data Wrangler interface in a sandboxed environment.

Important note:
We currently only accept the following formats for launching:

  • df
  • df.head()
  • df.tail()

Where df is the name of the data frame variable. The code above should appear at the end of a cell without any comments or other code after it.


Launching Data Wrangler directly from a CSV file

You can also launch Data Wrangler directly from a local CSV file. To do so, open any VS Code folder with the CSV dataset you’d like to explore. In the File Explorer panel, right-click the. CSV dataset and click “Open in Data Wrangler.”


Using Data Wrangler


The Data Wrangler interface is divided into 6 components, described below.

The Quick Insights header lets you quickly see valuable information about each column. Depending on the column’s datatype, Quick Insights will show the distribution of the data, the frequency of data points, and missing and unique values.

The Data Grid gives you a scrollable pane to view your entire dataset. Additionally, when selecting an operation to perform, a preview will be illustrated in the data grid, highlighting the modified columns.

The Operations Panel is where you can search through Data Wrangler’s built-in data operations. The operations are organized by their top-level category.

The Summary Panel shows detailed summary statistics for your dataset or a specific column if one is selected. Depending on the data type, it will show information such as min, max values, datatype of the column, skew, and more.

The Operation History Panel shows a human-readable list of all the operations previously applied in the current Data Wrangling session. It enables users to undo specific operations or edit the most recent operation. Selecting a step will highlight the data grid changes and show the generated code associated with that operation.

The Code Preview section will show the Python and Pandas code that Data Wrangler has generated when an operation is selected. It will remain blank when no operation is selected. The code can even be edited by the user, and the data grid will highlight the effect on the data.

Example: Filtering a column

Let’s go through a simple example using Data Wrangler with the Titanic dataset to filter adult passengers on the ship.

We’ll start by looking at the quick insights of the Age column, and we’ll notice the distribution of the ages and that the minimum age is 0.42. For more information, we can glance at the Summary panel to see that the datatype is a float, along with additional statistics such as the passengers’ mean and median age.


To filter for only adult passengers, we can go to the Operation Panel and search for the keyword “Filter” to find the Filter operation. (You can also expand the “Sort and filter” category to find it.)


Once we select an operation, we are brought into the Operation Preview state, where parameters can be modified to see how they affect the underlying dataset before applying the operation. In this example, we want to filter the dataset only to include adults, so we’ll want to filter the Age column to only include values greater than or equal to 18.


Once the parameters are entered in the operation panel, we can see a preview of what will happen to the data. We’ll notice that the minimum value in age is now 18 in the Quick Insights, along with a visual preview of the rows that are being removed, highlighted in red. Finally, we’ll also notice the Code Preview section automatically shows the code that Data Wrangler produced to execute this Filter operation. We can edit this code by changing the filtered age to 21, and the data grid will automatically update accordingly.

After confirming that the operation has the intended effect, we can click Apply.

Editing and exporting code

Each step of the generated code can be modified. Changes to the data will be highlighted in the grid view as you make changes.

Once you’re done with your data cleaning steps in Data Wrangler, there are 3 ways to export your cleaned dataset from Data Wrangler.

  1. Export code back to Notebook and exit: This creates a new cell in your Jupyter Notebook with all the data cleaning code you generated packaged into a clean Python function.
  2. Export data as CSV: This saves the cleaned dataset as a new CSV file onto your machine.
  3. Copy code to clipboard: This copies all the code generated by Data Wrangler for the data cleaning operations.

Note: If you launched Data Wrangler directly from a CSV, the first export option will be to export the code into a new Jupyter Notebook.

Data Wrangler operations

These are the Data Wrangler operations currently supported in the initial launch of Data Wrangler (with many more to be added soon).

Sort valuesSort column(s) ascending or descending
FilterFilter rows based on one or more conditions
Calculate text lengthCreate new column with values equal to the length of each string value in a text column
One-hot encodeSplit categorical data into a new column for each category
Multi-label binarizerSplit categorical data into a new column for each category using a delimiter
Create column from formulaCreate a column using a custom Python formula
Change column typeChange the data type of a column
Drop columnDelete one or more columns
Select columnChoose one or more columns to keep and delete the rest
Rename columnRename one or more columns
Drop missing valuesRemove rows with missing values
Drop duplicate rowsDrops all rows that have duplicate values in one or more columns
Fill missing valuesReplace cells with missing values with a new value
Find and replaceSplit a column into several columns based on a user-defined delimiter
Group by column and aggregateGroup by columns and aggregate results
Strip whitespaceCapitalize the first character of a string with the option to apply to all words.
Split textRemove whitespace from the beginning and end of the text
Convert text to capital caseAutomatically create a column when a pattern is detected from your examples.
Convert text to lowercaseConvert text to lowercase
Convert text to uppercaseConvert text to UPPERCASE
String transform by exampleAutomatically perform string transformations when a pattern is detected from the examples you provide
DateTime formatting by exampleAutomatically perform DateTime formatting when a pattern is detected from the examples you provide
New column by exampleAutomatically create a column when a pattern is detected from the examples you provide.
Scale min/max valuesScale a numerical column between a minimum and maximum value
Custom operationAutomatically create a new column based on examples and the derivation of existing column(s)


Data Wrangler currently supports only Pandas DataFrames. Support for Spark DataFrames is in progress.
Data Wrangler’s display works better on large monitors, although different interface portions can be minimized or hidden to accommodate smaller screens.


Data Wrangler in Microsoft Fabric is undeniably a game-changer in data preparation. It combines the best of both worlds by offering the simplicity of Power Query with the robustness and flexibility of Python. As data continues to grow in importance, tools like Data Wrangler that simplify and expedite the data preparation process will be indispensable for organizations aiming to stay ahead.

That’s it for today!







Feature Spotlight: A Closer Look at BotGPT’s Integration with Google Bard

In the world of chatbots, two names that are often mentioned in the same breath are BotGPT and Google Bard. Both are powerful AI-powered chatbots that can hold conversations with humans in a natural and engaging way. But what happens when you combine the two?

That’s the question that BotGPT is answering with its new integration with Google Bard. This integration gives BotGPT access to Google Bard’s vast knowledge and language processing capabilities, making it even more powerful and versatile.

In this blog post, we’ll take a closer look at the BotGPT-Google Bard integration. We’ll discuss what it is, how it works, and what it means for the future of chatbots.

What is Google Bard?

Google Bard is a large language model (LLM) chatbot developed by Google AI. It is trained on a massive dataset of text and code, which allows it to generate text, translate languages, write different kinds of creative content, and answer your questions in an informative way.

Google Bard is set to rival Bing’s offering that incorporates ChatGPT integration. Like OpenAI’s ChatGPT, Bard employs AI technology to interpret natural language, delivering human-like responses to intricate inquiries.

Google Bard is still under development, but it has already learned to perform many kinds of tasks, including:

  • Answering your questions in a comprehensive and informative way, even if they are open-ended, challenging, or strange.
  • Generating different creative text formats of text content, like poems, code, scripts, musical pieces, emails, letters, etc.
  • Translating languages accurately and fluently.
  • Writing different kinds of creative content, like blog posts, articles, stories, and poems.

This is the official website for Google’s Bard.

What is BotGPT?

BotGPT is a virtual assistant that connects different artificial intelligences to your Whatsapp:

  • Chat GPT 3.5 and GPT 4
  • Google Bard
  • Dall-e 2
  • Midjourney
  • Whisper
  • Azure Cognitive Services

BotGPT is a new service product that leverages the power of artificial intelligence to provide a personalized chat experience to customers through WhatsApp. Powered by the large language models, ChatGPT and Google Bard, BotGPT is designed to understand natural language and provide relevant responses to customer inquiries in real time.

One of the key benefits of using BotGPT is its ability to provide personalized recommendations to customers based on their preferences and past interactions. BotGPT can suggest products, services, or solutions tailored to each customer’s needs by analyzing customer data. This personalized approach helps to enhance the overall customer experience, leading to increased customer satisfaction and loyalty.

You can use BotGPT for a variety of tasks, such as:

Text generation: writing stories, poems, and scripts.
Answer questions.
Translate language.
Summarize texts.
General chatting.
Generating creative ideas.
Create realistic images and art from instructions by text.

Learn all the commands before using:

help to get instructions on how to use the BotGPT
prompts to get a list of example prompts
create image to create realistic images using Dall-e 2
midjourney to create realistic images using Midjourney
midselect to select one of the 4 Midjourney images
gpt-3 to change the ChatGPT model to GPT-3
gpt-4 to change the ChatGPT model to GPT-4
bard to change to the Google Bard model
send to send the last response you received from BotGPT to your email
send audio to send the last response as audio
give me a document for you to receive the last BotGPT response as a Word document
list user first instruction to display the first prompt. The first prompt sets the direction for BotGPT
alter user first instruction to change the first prompt
onlyvoice to configure the BotGPT to respond through audio only
onlytext to configure the BotGPT to respond through text only
voicetext to configure the BotGPT to respond through text + audio
clear to clear the memory buffer and start new questions
buffer displays the set of prompts currently in BotGPT’s memory
save to save a sequence of prompts
load to load a previously saved sequence of prompts
del to delete a saved sequence of prompts
list to list all saved prompt sequences
list <name>to display the saved sequence of a single prompt sequence
status to get your expiration date, ChatGPT model, and selected language
cancel to manage or cancel your subscription

How to sign up?

Signing up for BotGPT is a straightforward process:

  1. Navigate to the official BotGPT website.
  2. Look for the “Try BotGPT” or “Register” button, usually located at the top right corner.
  3. Follow the prompted steps, enter your details, and click here to enter.
  4. Once registered, you can explore and customize your chatbot based on your requirements.

Once you register you will have 2 days free to use. For more information go to the BotGPT website.

How does the new integration with Google Bard work?

Setting up Google Bard is straightforward. Simply type “bard” on WhatsApp to begin. If you prefer to switch back to GPT-4, just type “gpt 4”, and you’re all set.

Feel free to ask any questions. If Google Bard provides an image in response, you’ll receive it via WhatsApp.

For further details, visit the BotGPT website, or don’t hesitate to reach out to me here.


The convergence of two powerful technologies – BotGPT and Google Bard – heralds a new era in the realm of chatbots. For businesses, this presents an opportunity to elevate customer interactions, offer more personalized experiences, and harness the full power of AI-driven conversational platforms. As these technologies continue to evolve, one can only imagine the innovative ways they’ll transform our digital interactions.

That’s it for today.


✨Unleash the Power of GPT-4 with BotGPT: Your Inspiring Ally on WhatsApp🌟 – Tech News & Insights (lawrence.eti.br)

English | BOT GPT (botgpt-ai.com)

Bard (google.com)

What is Google Bard? Here’s everything you need to know | ZDNET