我有Json文件,并将其转换为字典,然后从中提取了一些数据,这些数据是类的名称。
这是我的代码
import pandas as pd
import json
df = pd.read_json("/content/Test1.json")
with open('/content/Test1.json') as handle:
dictdump = json.loads(handle.read())
for elem in dictdump :
print(elem['fullyQualifiedName'])
然后它返回这些,它们是类的名称:
android.support.v4.app.Watson
android.support.v4.app.Watson.OnCreateOptionsMenuListener
android.support.v4.app.Watson.OnPrepareOptionsMenuListener
android.support.v4.app.Watson.OnOptionsItemSelectedListener
com.actionbarsherlock.ActionBarSherlock
com.actionbarsherlock.ActionBarSherlock.OnCreatePanelMenuListener
com.actionbarsherlock.ActionBarSherlock.OnCreateOptionsMenuListener
com.actionbarsherlock.ActionBarSherlock.OnMenuItemSelectedListener
com.actionbarsherlock.ActionBarSherlock.OnOptionsItemSelectedListener
com.actionbarsherlock.ActionBarSherlock.OnPreparePanelListener
我想将此数据插入到CSV文件中。
这是一种实现此目的的方法:
import pandas as pd
import json
classDF = pd.DataFrame(columns = ['NameOfClass', 'Type_of_smells'])
with open('/content/Test1.json') as handle:
dictdump = json.loads(handle.read())
for elem in dictdump :
class_dict = {'NameOfClass': elem['fullyQualifiedName'], 'Type_of_smells': elem['WhatEverYourJsonNameIs']}
class_name = pd.DataFrame.from_dict(class_dict, orient='index')
class_name = class_name.transpose()
classDF = pd.concat([classDF, class_name])
classDF.to_csv('/path/class_name.csv', mode='a', header=True)
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句