EH #424 - 行ごとの集計: 複数のロジカル型の列のうちひとつでも値がTRUEがあるか判定したい

Confirmation

Do you want to subscribe to the notification email?

Once subscribed, notification emails will be sent to your registered email address when the insight 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.

View Data

Filtered By:

Export

Rows

rows

Embed Note

<iframe 
  src="https://exploratory.io/note/exploratory/EH-424-TRUE-YBi6BAd7Xk?embed=true"
  frameborder="0"
  width="100%"
  height="100%"
  >
</iframe>

EH #424 - 行ごとの集計: 複数のロジカル型の列のうちひとつでも値がTRUEがあるか判定したい

Team Exploratory

Updated

188 0 6

Project Information
Project Name
Exploratory Hour
Note Name
EH #424 - 行ごとの集計: 複数のロジカル型の列のうちひとつでも値がTRUEがあるか判定したい
Description

集計と言えば普通は列単位ですが、これを知っていれば行単位でも集計ができるようになります。 summarize_row関数とany関数を組み合わせることで、複数の列のうち1つでも条件にマッチしていたらフラグをつけることができるようになります。
Created By
Takato Shiroto
Created Date

Updated By
Takato Shiroto
Updated Date

Desktop Version
10.7.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?

EH #424 - 行ごとの集計: 複数のロジカル型の列のうちひとつでも値がTRUEがあるか判定したい
Team Exploratory
Refreshed:
188
Exploratoryhour
Team Exploratory
Japanese
How-to
Data Wrangling
Summarize_row
Open Without Header
Sign In

Exploratoryhour

Team Exploratory

Terms
Privacy
Security Policy
Contact Us

Contact Us

© 2024 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)