Twitter Json fromat

[X]

I have met a problem. I collected some tweets in excel form. I transferred to json format trying to load to netmapper but failed.

All my data from twitter is in excel form. How can I transform into the json format required by netmapper. Thanks.

[Eric Malloy]

You can export from excel to csv and import the data base csv.

On Tue, Jul 21, 2020 at 1:47 PM X <xiang...@gmail.com> wrote:

I have met a problem. I collected some tweets in excel form. I transferred to json format trying to load to netmapper but failed.

All my data from twitter is in excel form. How can I transform into the json format required by netmapper. Thanks.

--
Computational Analysis of Social and Organizational Systems (CASOS)
The Institute for Software Research, Department of Computer Science
Carnegie Mellon University, Pittsburgh, PA, USA
http://casos.cs.cmu.edu/
---
You received this message because you are subscribed to the Google Groups "ORA Google Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ORA-google-gro...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ORA-google-group/e4a1e3ca-a1b5-4879-a882-a20e0ae4b9d1o%40googlegroups.com.

[Eric Malloy]

import as csv that is.

[Kathleen Carley]

eric - how can a user use a csv file instead of a json file as the input to NetMapper so that NetMapper will produce cues

To view this discussion on the web visit https://groups.google.com/d/msgid/ORA-google-group/CACwtWUAGjgV6sf0iNJVLgajDTujzHz4HMuNWyOU1v5Gjv_W2Ug%40mail.gmail.com.

[Eric Malloy]

cues is always produced by default regardless of input format.

To view this discussion on the web visit https://groups.google.com/d/msgid/ORA-google-group/CAFtd-nYcFSNRUP2RYEeSXXEEY%2BhY-ZYk8f%2BjKOtCD6ksU_Ofqw%40mail.gmail.com.

[Kathleen Carley]

eric - ok - can you please send the ideal col headers for a csv file that would contain tweets - so that our users who collect tweets by random tools can export to a csv file with headers you expect

To view this discussion on the web visit https://groups.google.com/d/msgid/ORA-google-group/CACwtWUAiRr2zDd-s3UrbKpr-Jh3yWUokgE8yGRbcjXk1h5XxGg%40mail.gmail.com.

[Eric Malloy]

Users can trivially map any column headers they like.  If they choose the default profile the text column should be named "text" and the tweet id column should be named "id".

To view this discussion on the web visit https://groups.google.com/d/msgid/ORA-google-group/CAFtd-nbmnQDwaEp_ZFMkcWn4MkSjQgnJQpJCNv4kAtPRe-Vi9w%40mail.gmail.com.

[Eric Malloy]

The user documentation will help explain how to import csv.  See attached.

[Kathleen Carley]

thanks  - problem solved

To view this discussion on the web visit https://groups.google.com/d/msgid/ORA-google-group/CACwtWUAiSkH06XZV9WdhDx6N7_FN%3DjDNGFdZxT94pF4GVqHuwA%40mail.gmail.com.

[Kathleen Carley]

That is fine

if the column header for the tweet id is labeled just id

and the column header for the body of the tweet is labeled text

you can just give that to NetMapper and it will generate out the cues needed for ora-pro

Note we do not generale networks based on the body of the text

however, ora itself will generate networks for you - just use the csv importer and tell it what each column means

On Tue, Jul 21, 2020 at 1:47 PM X <xiang...@gmail.com> wrote:

I have met a problem. I collected some tweets in excel form. I transferred to json format trying to load to netmapper but failed.

All my data from twitter is in excel form. How can I transform into the json format required by netmapper. Thanks.

--