How to convert a column that records values only when an event occurs into a logical type

Confirmation

Do you want to subscribe to the notification email?

Once subscribed, notification emails will be sent to your registered email address when the content is refreshed by the scheduling.

Schedule Frequency

Not Scheduled

Markdown Text

Your session is about to timeout.

The interactive mode session is about to timeout.

Do you want to extend?

In order to update and show the chart data you need to start the Interactive Mode.

The interactive mode is starting up. Please try again after it has finished starting.

Edit Chart

View Data

Filtered By:

Export

Rows

rows

Confirmation

There are unsaved changes. Do you want to save it?

Save as Separate Note

This note was published from Exploratory Desktop and it cannot be edited from the web. Would you like to save it as a different note and edit?

NamePlease enter the name.

Confirmation

It has been saved by another user. Do you want to overwrite it?

Confirmation

There are unsaved changes. Do you want to save it?

Confirmation

It has been saved by another user. Do you want to overwrite it?

Save As...

NamePlease enter the name.

Embed Note

<iframe 
  src="https://exploratory.io/note/exploratory/How-to-convert-a-column-that-records-values-only-when-an-event-occurs-into-a-logical-type-Ydv5yrR5?embed=true"
  frameborder="0"
  width="100%"
  height="100%"
  >
</iframe>

How to convert a column that records values only when an event occurs into a logical type

Team Exploratory

Updated

29 4

Project Information
Project Name
How-to
Note Name
How to convert a column that records values only when an event occurs into a logical type
Created By
Ikuya Murasato
Created Date

Updated By
Ikuya Murasato
Updated Date

Desktop Version
14.0.3
Schedule
Scheduling is not supported because:
No Data Source to Refresh
Last Refresh Log (Schedule)
Status

Start Time
Finish Time
Time Elapsed
Processed Data Size
Processed # of Rows

Open Without Header
Embedding Code
Sign In

Download EDF
What is EDF?

How to convert a column that records values only when an event occurs into a logical type
Team Exploratory
Refreshed:
29
Team Exploratory
How-to
Data Wrangling
Logical
Open Without Header
Sign In

Team Exploratory

Terms
Privacy
Security Policy
Contact Us

Contact Us

© 2025 Exploratory, Inc.

Sign Up

Thank you for registering! We will send you an email once your account is ready.

Sorry, our system had an error. Please send email to support@exploratory.io.

A user with this email address already exists. You can login from here. If you forgot your password, you can reset your password here.

Please enter valid email address and try again.

Thanks for your interest! Please tell us a little bit more about you.

EmailYour primary OSOrganization (optional)Your favorite data analysis tools (optional)

Enter a Note Name

Loading the Note Editor...