Dataset Issue

[aashsach]

The file api_10.csv has the following columns:

"apk";"uid";"type";"callback";"api";"sensitive";"apitype";"category";"depth";"declaringClass"

Line 22 of the file is a correct entry:

"com.musicplayer.player.mp3player.white.apk";"2131689606";"Button";"<com.musicplayer.player.mp3player.white.activity.o: void onClick(android.view.View)>";"INTENT.<android.provider.MediaStore$Images$Media:.android.intent.action.PICK";"NON_SENSITIVE";"INTENT";"IMPLICIT_INTENT";"1";"com.musicplayer.player.mp3player.white.activity.Activity_edit_albumart"

But, in contrast, take a look at line 23:

"com.musicplayer.player.mp3player.white.apk";"com.musicplayer.player.mp3player.white.cutter.AudioEditor";"ActivityLifecycleMethod";"<com.musicplayer.player.mp3player.white.cutter.AudioEditor: void onResume()>";"<android.app.Activity: android.view.Window getWindow()>";"NON_SENSITIVE";"NORMAL";"NO_CATEGORY";"2";

This entry has a value of com.musicplayer.player.mp3player.white.cutter.AudioEditor for the column uid and a total of 9 values, while the number of columns above is 10.

Is there something wrong with this file?

[vitaliiavdiienko]

Hi,

there is nothing suspicious in the file. You should just be sure that your CSV parser is intelligent and resolves such cases correctly.

if you use R, do the following: api=read.table("api_10.csv",head=T,sep=";") write.csv2(api, "api_10_correct.csv")

It should do a trick. We always use R and such problems are not problems at all 😄

Now you can load it in you favourite CSV editor! Enjoy!

Best Regards, Vitalii

[aashsach]

20  com.musicplayer.player.mp3player.white.apk  2131689704  android.support.v7.widget.RecyclerView  <com.musicplayer.player.mp3player.white.activi...   <android.content.res.Resources: int getColor(i...   NON_SENSITIVE   NORMAL  NO_CATEGORY 5   com.musicplayer.player.mp3player.white.activit...
21  com.musicplayer.player.mp3player.white.apk  2131689606  Button  <com.musicplayer.player.mp3player.white.activi...   INTENT.<android.provider.MediaStore ImagesImages Med... NON_SENSITIVE   INTENT  IMPLICIT_INTENT 1   com.musicplayer.player.mp3player.white.activit...
22  com.musicplayer.player.mp3player.white.apk  com.musicplayer.player.mp3player.white.cutter....   ActivityLifecycleMethod <com.musicplayer.player.mp3player.white.cutter...   <android.app.Activity: android.view.Window get...   NON_SENSITIVE   NORMAL  NO_CATEGORY 2   NaN
23  com.musicplayer.player.mp3player.white.apk  com.musicplayer.player.mp3player.white.cutter....   ActivityLifecycleMethod <com.musicplayer.player.mp3player.white.cutter...   <android.database.MatrixCursor: java.lang.Stri...   SENSITIVE   NORMAL  DATABASE_INFORMATION    3   NaN
24  com.musicplayer.player.mp3player.white.apk  com.musicplayer.player.mp3player.white.cutter....   ActivityLifecycleMethod <com.musicplayer.player.mp3player.white.cutter...   <android.database.MatrixCursor: int getCount()> SENSITIVE   NORMAL  DATABASE_INFORMATION    3   NaN
25  com.musicplayer.player.mp3player.white.apk  com.musicplayer.player.mp3player.white.cutter....   ActivityLifecycleMethod <com.musicplayer.player.mp3player.white.cutter...   <android.content.ContentResolver: android.data...   SENSITIVE   NORMAL  CONTENT_RESOLVER    5   NaN

Doesn't seem to resolve the issue. Besides, the content in the post above is taken from the raw CSV file without the use of any external parsing utilities.

[wshasha]

Hi, Have you ever download backstage_data.zip? The url is invalid now, if you still keep it, would you mind send me one? here is my mail wangshasha_bupt@163.com Thanks.

yours wss