Back ArrowExplore all topics
technology logo
technology logo

How to Create a Word Cloud from CSV in Python

share link

by ganesh dot icon Updated: Jan 31, 2023

Solution Kit Solution Kit  

You can create a word cloud from a CSV file in Python using the wordcloud library. This program offers a straightforward and user-friendly interface for creating word clouds from text data. The procedure normally starts with loading the data from the CSV file, followed by text pre-processing (such as deleting stop words and stemming) and word cloud generation using wordcloud.WordCloud class. 


Word clouds are a popular tool for visualizing the most common words in a large corpus of text data. 

They can be used in various applications, such as: 

  • Text mining: Word clouds can be used to find important themes and trends in massive text data sets, including customer reviews and social media posts. 
  • Content marketing: We can use the wordcloud to help guide content planning and SEO efforts to determine the most popular subjects and keywords in a website's content. 
  • Data visualization: Word clouds can be employed to produce aesthetically pleasing and simple-to-understand representations of text data, making it simpler to convey findings to non-technical audiences. 
  • Sentiment analysis: Word clouds can also be used to analyze the sentiments of a given dataset; in the word cloud, positive or negative words will be more prevalent. 


Here is how you can create a word cloud from csv in Python: 

Fig 1: Preview of the output that you will get on running this code from your IDE

Code

In this solution we use the generate function of the WordCloud library.

Creating word cloud in Python from column in CSV file

PythondotLines of Code : 33dotLicense : Strong Copyleft (CC BY-SA 4.0)

Dependent Libraries : 
import csv
from wordcloud import WordCloud


#read first column of csv file to string of words seperated
#by tab

your_list = []
with open('words.csv', 'rb') as f:
    reader = csv.reader(f)
    your_list = '\t'.join([i[0] for i in reader])


# Generate a word cloud image
wordcloud = WordCloud().generate(your_list)

# Display the generated image:
# the matplotlib way:
import matplotlib.pyplot as plt
plt.imshow(wordcloud, interpolation='bilinear')
plt.axis("off")

# lower max_font_size
wordcloud = WordCloud(max_font_size=40).generate(your_list)
plt.figure()
plt.imshow(wordcloud, interpolation="bilinear")
plt.axis("off")
plt.show()

# The pil way (if you don't have matplotlib)
# image = wordcloud.to_image()
# image.show()
  1. Copy the code using the "Copy" button above, and paste it in a Python file in your IDE.
  2. Create a csv file with one column containing words.
  3. Modify the reading mode in the code from 'rb' to 'r'
  4. Modify the name, location of the csv to be read in the code.
  5. Run the file to create a WordCloud.


I hope you found this useful. I have added the link to dependent libraries, version information in the following sections.


I found this code snippet by searching for "create word cloud from csv" in kandi. You can try any such use case!

Dependent Libraries

word_cloudby amueller

Python doticonstar image 9489 doticonVersion:1.9.1.1doticon
License: Permissive (MIT)

A little word cloud generator in Python

Support
    Quality
      Security
        License
          Reuse

            word_cloudby amueller

            Python doticon star image 9489 doticonVersion:1.9.1.1doticon License: Permissive (MIT)

            A little word cloud generator in Python
            Support
              Quality
                Security
                  License
                    Reuse

                      matplotlibby matplotlib

                      Python doticonstar image 17514 doticonVersion:v3.7.1doticon
                      no licences License: No License (null)

                      matplotlib: plotting with Python

                      Support
                        Quality
                          Security
                            License
                              Reuse

                                matplotlibby matplotlib

                                Python doticon star image 17514 doticonVersion:v3.7.1doticonno licences License: No License

                                matplotlib: plotting with Python
                                Support
                                  Quality
                                    Security
                                      License
                                        Reuse

                                          If you do not have Matplotlib and WordCloud that are required to run this code, you can install them by clicking on the above link and copying the pip Install command from the Matplotlib and WordCloud pages in kandi.


                                          You can search for any dependent library on kandi like Matplotlib and WordCloud.

                                          Environment Tested


                                          I tested this solution in the following versions. Be mindful of changes when working with other versions.

                                          1. The solution is created in Python3.9.
                                          2. The solution is tested on Matplotlib 3.4.3 and WordCloud 1.8.1 version.


                                          Using this solution, we are able to create a Wordcloud from csv using the WordCloud and Matplotlib libraries in Python with simple steps. This process also facilities an easy to use, hassle free method to create a hands-on working version of code which would help us create a word cloud from csv in Python.

                                          Support


                                          1. For any support on kandi solution kits, please use the chat
                                          2. For further learning resources, visit the Open Weaver Community learning page.

                                          See similar Kits and Libraries

                                          Open Weaver – Develop Applications Faster with Open Source

                                          kandi

                                          Community and Support

                                          Company

                                          Follow

                                          • © 2023 Open Weaver Inc.