• Unlocking the Power of AI in the Retail Sector

    Unlocking the Power of AI in the Retail SectorSeptember 11th, 2024 in AI, Artificial Intelligence, Blog, Machine Learning

    In today’s fast-paced retail environment, businesses are constantly seeking innovative ways to stay ahead of the competition. One of the most transformative technologies in recent years has been Artificial Intelligence (AI). By leveraging AI, retailers can gain valuable insights into their operations, enhance customer experiences, and drive sales growth. In this blog, we’ll explore two key AI use cases in the retail sector: sales…

    » Read more

  • Getting To Grips With Copilot Chatbots

    May 7th, 2024 in AI, Blog

    Chatbots are becoming an essential part of many businesses and organizations, as they can provide instant and personalized responses to customers and employees, reduce costs and workload, and improve customer satisfaction and loyalty. However, creating a chatbot that can handle complex and natural conversations is not an easy task. It requires a lot of data, skills, and resources to design, develop, and deploy a chatbot that can meet the…

    » Read more

  • Our Microsoft AI and ML Predictions for 2024

    January 4th, 2024 in AI, Azure, Blog, News, Windows

    As we step into 2024, Microsoft’s commitment to advancing Artificial Intelligence (AI) and Machine Learning (ML) is evident through its diverse range of offerings. The tech giant continues to push the boundaries of innovation, providing businesses with powerful tools to transform data into intelligent insights. In this blog, we’ll explore Microsoft’s current AI and ML landscape and peek into the possibilities that will…

    » Read more

  • How do I make a multi-line string in Python (so I can ctrl+C my SQL code)

    August 29th, 2023 in Blog, Jupyter, Machine Learning, Python, Spark, SQL

    This should be a quick one, but it is something that took me a little while to work out, but now I know I use it pretty much every day in my projects to save me a lot of time. This is the ability to copy and paste my SQL code into my python code as a multi-line string without having to reduce it to be all on one line or using escape characters. Both of which can take a bit of time depending on how big your SQL is. You usually need to have SQL…

    » Read more

  • PySpark Problems: Using Map() gives the error “TypeError: unsupported operand type(s) for /: ‘builtin_function_or_method’ and ‘float’ “

    March 31st, 2023 in Azure, Blog, Python, Spark

    This error was something I saw at the same time as the error I discussed in my previous blogpost (here), where we are seeing conflicting data types when trying to divide each value of a count of values by the number of days in 3 months (approximately) to get a frequency value over 3 months. I did show the code to fix the error we will discuss in the previous blog post, but I will go into more detail here. The code (without the line that fixes…

    » Read more

  • PySpark Problems: Using Map() gives the error “TypeError: unsupported operand type(s) for /: ‘Row’ and ‘float’ “

    March 31st, 2023 in Azure, Big Data, Blog, Python, Spark

    Here’s the first in what will be an adhoc series of short blog posts where I will write a paragraph on the solution to problems I come across when I’m using PySpark. In this post I will discuss using the Map() function to apply a function to every value in an RDD and then getting the error message: “TypeError: unsupported operand type(s) for /: ‘Row’ and ‘float’ “ We see this error because we are…

    » Read more

  • My Jupyter Notebook Crashed and Now Won’t Open

    February 14th, 2023 in Blog, Jupyter, Python

    This is a problem that has plagued me a few times and is usually due to outputting too much in a single cell. The Notebook will run out of memory and crash, but it will contain the output that caused the notebook to crash. The notebook will crash every time you open it, for some browsers you may even see an ‘out of memory’ error message. The solution to this problem is to delete the vast amount of output, without opening the…

    » Read more

  • Part 4: Natural Language Processing – Bringing it all together!

    January 23rd, 2023 in AI, Azure, Big Data, Blog, Business Intelligence, DAX, Power BI, Python

    Here’s the final post in this blog series on natural language processing where we are going to bring everything together and web scrape Trust Pilot for review data, which we will then perform Natural Language Processing on and then display in a Power Bi dashboard. I’ll be talking exclusively practically in this demo, so for a refresher on the theory please refer back to my earlier blogposts (Part 1, Part 2, Part 3). To re-iterate the goal…

    » Read more

  • Purple Frog at AI and Big Data Expo

    December 15th, 2022 in AI, Big Data, Blog

    During the 1st and 2nd of December, Purple Frog descended on London Olympia for 2 days of AI, ML and Big Data based fun at the AI & Big Data Expo. The AI and Big Data Expo is a leading Artificial Intelligence & Big Data Conference & Exhibition that showcases the next generation enterprise technologies and strategies from the world of Artificial Intelligence & Big Data, providing an opportunity to explore and discover the…

    » Read more

  • Part 3: Natural Language Processing – Sentiment Analysis and Opinion Mining

    November 24th, 2022 in AI, Azure, Big Data, Blog, Business Intelligence, Python, Synapse

    If you remember in part 2 we discussed what Key Word Analysis is and how this can be implemented to gain deeper insight from textual data. But we can go one step deeper and extract feelings and opinions from the same data. We can do this through Sentiment Analysis and Opinion mining! In this blog I will talk you through what they are and how we can implement them using Microsoft’s Cognitive Services. What is Sentiment Analysis? We should…

    » Read more