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