How To
Aug 3, 2022

Data Exploration using Gigasheet

What is Data Exploration?

Data exploration, often called exploratory data analysis, is the first and most critical phase in the data analysis pipeline. How so?

This is where the data undergoes an initial review where analysts understand the data, derive patterns, spot anomalies with it (examples of which we’ll uncover later). Most analysts utilize hybrid exploration techniques – including manual and automated exploration tools – for their analysis.

Pandas, Numpy, and Matplotlib are examples of three of the most commonly used Python libraries for this purpose. Gigasheet enables you to do all the same without writing a single line of code! 🤯

Let’s explore a data set together and see Gigasheet in action!

Try Gigasheet Free!

Exploring Data with Gigasheet

We’ll be breaking our analysis workflow in three steps:

  1. Importing data to Gigasheet
  2. Cleaning up Data
  3. Exploration

Importing Data to Gigasheet

Have your data in flat files like CSV or JSON? We parse these files into spreadsheets in seconds. But Gigasheet's capabilities go far beyond flat files. Whether your data is stored in enterprise databases, cloud data warehouses like BigQuery or Snowflake, or comes from popular CRMs and SaaS platforms, Gigasheet can seamlessly connect, import, and analyze massive datasets. Our platform supports direct integration with databases such as MySQL, PostgreSQL, and cloud storage solutions like AWS S3, allowing you to work with billions of records without the need for coding. Here are a few of the file formats Gigasheet supports:

  • CSV
  • LOG
  • JSON
  • TSV
  • XLSX
  • Parquet
  • SQLLite
  • ZIP/GZIP (and a supported file format within the archive)

Keep your data sets stashed in personal cloud storage platforms like Google Drive or OneDrive? No worries!

Upload from Cloud Storage

Have your data in cloud services like AWS S3, AWS Redshift, or ActiveCampaign? Our data connectors are ready to crunch your data into our platform! We’ve got over 100+ integrations and a lot more in the pipelines to support you data analysts.

Data connectors for Enterprise

On a test drive but don’t have sample data sets to work with? Gigasheet recently launched the Data Community from which you can easily open up a dataset in our web-based Spreadsheet and get to work.

To showcase data exploration with Gigasheet, I’ll be using a dataset from Kaggle where we’re given a US Airline Sentiment dataset which was scraped from Twitter – so these are tweets from customers in February 2015 who took several flights using US-based airlines. A few objectives here might be to find:

  • What impacts a user’s experience?
  • Is the dataset skewed?
  • What airline is associated with what mood based on our data set?

Using the file upload functionality, I’ll simply upload my CSV sheet to Gigasheet and let it do the processing. Wait for a few seconds and your sheet should be ready for viewing. Let’s move on to the next phase.

Cleaning Up Data

Before anything, I can see several columns which are not necessary for analysis. So, let’s start by removing them from our data set. Here’s what I’ve removed:

  • tweet_id
Removing unnecessary columns like Tweet ID
  • tweet_cord
  • airline_sentiment_gold
  • negativereason_gold

Next, a good practice is to check for columns with null values (especially in columns which are important for analysis). A quick and easy way to check is to group the columns and see if any of the values are either empty (or another form of a null value). Here’s an example of me grouping the airline column:

Gigasheet UI

If grouping is not what you’re after, you can also pick a column and look for null values by applying the is empty filter on the desired column. Here’s me doing the same for the airline column with filters:

Filtering out empty or NULL values

Fun Fact: You can also save your filters to avoid rewriting filters for analysis at a later stage. Just save the filter and you can easily select it later from the dropdown!

Exploration

Next, let’s map the sentiments against their counts for a quick check on how our data is distributed. To do so, I’ll first group the data based on airline_sentiment, then use the dropdown by the airline column to select Count.

Aggregate data using Count

Once selected, let’s select the data, right click, and select Chart Range to stack it in a column:

Gigasheet UI

Here’s how the sentiments look via a chart:

Chart of Sentiment Data

That’s a lot of negative sentiments. Next, let’s distribute these against a particular airline and see how the data looks. Start off by grouping the data on the airline column, and next, the sentiment column. You can now use any non-numeric field to use the Column aggregation to use in our graph.

Here, I’ve selected the Count aggregation on the name field. Now let’s select all grouped data again and stack it to see how the data looks. Here’s my selection:

Sentiment by Airline using two Groups

And here’s how the grouped data looks in a chart:

Chart of Sentiment Data using Groups

Fun Fact: You can further modify the graph by selecting the arrow on the top right (not visible in the screenshot). Add a title, remove the legends, change the colors – practically anything you could do with matplotlib and plotly – you can do here.

You might notice that United, US Airlines, and American have a lot more ‘negative’ sentiment tweets than other airlines. This forms a skewed dataset and you might want to operate on a more inclusive dataset for proper results. However, we’ll continue with our data exploration as this is simply a test run.

One thing we could do is to take a look at ‘why’ these negative sentiments are high. I’ll start by removing positive and neutral values from the dataset. Group the negativereason field and aggregate any field to the Count type. Here’s how the data looks in a bar graph:

Exploring why sentiments are negative

Now if you were a firm looking to improve a particular business function – just this simple graph on Gigasheet can help identify a weak point. Here, Customer Service Issue seems to be a recurring problem.

You can further distribute this data into individual airlines e.g. look for negative reasons against United airlines. To do so, first group the data by airline and then by negativereasons. Again, Customer Service Issue comes out to be the root cause of these negative tweets on Twitter.

Chart of reasons for negative tweets

There’s a lot more you can do to further explore this data and see what models you’d apply in the next phase of your Data Analysis process. This is where exploration ends for me and this write-up. What other exploration use-cases can you think of here?

What’s Next?

Frustrated with how much code you have to write to analyze your data? That’s exactly why Gigasheet promotes no-code data science. Load your data, explore it, and get to analysis without writing hundreds of lines of code!

If you’re looking for more fun blogs on using Gigasheet for Data Science and Data Analysis, give these a read:

Want a quick trial with no charge? Sign up for a free account today and start exploring the Data Community!

The ease of a spreadsheet with the power of a data warehouse.

No Code
No Training
No Installation
Sign Up, Free

Similar posts

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.