stata - How to see tabulate/table/display of frequency that different groups take on values of a variable -


using stata, suppose have data:

clear set more off  input /// id str5 value 1    fox 1    ox 1    cow  2    fox 2    fox 3    ox  3    fox 3    cow  4    cow 4    ox end

as in previous answer, if 1 wants determine within group if values same, 1 can use:

bysort id (value) : gen onevalue = value[1] == value[_n]

my question relates this, takes 1 step further. want know frequencies of combinations of value id takes on. not want consider frequency or order within id - care if appears @ least once. may little confusing, illustrate, want know following:

there 3 different groups occur in data: a) fox, ox, cow, b) fox, , c) cow, ox. note ids 1 , 3 both belong group a, id 2 belongs group b, , id 4 belongs group c.

combination    freq fox, ox, cow   2 fox            1 cow, ox        1

i not need in exact format, knowing information helpful me. there simple way accomplish task? best thought of involves creating bunch of new variables indicators whether element of value in id, , tabbing combinations of these variables. feel there should better way.

i able drop ids based on results of above.

this variation on @roberto ferrer's helpful answer. concatenate in place, avoiding reshape. assumption looking @ string variable. if not, apply tostring or string() first. 

. clear  . input id str5 value              id      value   1. 1    fox   2. 1    ox   3. 1    cow    4. 2    fox   5. 2    fox   6. 3    ox    7. 3    fox   8. 3    cow    9. 4    cow  10. 4    ox  11. 5    cow  12. 5    fox  13. 5    fox  14. end   . bysort id (value) : gen = value if _n == 1 (8 missing values generated)  . id : replace = cond(value != value[_n-1], all[_n-1] + " " + value, all[_n-1]) if  _n > 1   (8 real changes made)  . id : replace = all[_n]  (6 real changes made)  . tab all, sort           |      freq.     percent        cum. ------------+-----------------------------------  cow fox ox |          6       46.15       46.15     cow fox |          3       23.08       69.23      cow ox |          2       15.38       84.62         fox |          2       15.38      100.00 ------------+-----------------------------------       total |         13      100.00  . egen tag = tag(id)  . tab if tag, sort          |      freq.     percent        cum. ------------+-----------------------------------  cow fox ox |          2       40.00       40.00     cow fox |          1       20.00       60.00      cow ox |          1       20.00       80.00         fox |          1       20.00      100.00 ------------+-----------------------------------       total |          5      100.00   . groups id     +-----------------------------------+   | id            freq.   percent |   |-----------------------------------|   |  1   cow fox ox       3     23.08 |   |  2          fox       2     15.38 |   |  3   cow fox ox       3     23.08 |   |  4       cow ox       2     15.38 |   |  5      cow fox       3     23.08 |   +-----------------------------------+

groups here user-written installed ssc inst groups. count identifier, not observations, use egen, tag() tag each identifier once.

another immediate trick apply wordcount(). dropping identifiers conditionally on these results should (more) straightforward.

if string values include spaces, use other concatenating punctuation appropriate, commas, semi-colons or colons.


-

Popular posts from this blog

c# - ODP.NET Oracle.ManagedDataAccess causes ORA-12537 network session end of file -

overview i want replace oracle.dataaccess orcale. managed dataaccess, opening connection latter throws ora-12537 network session end of file exception. exception message / stack trace {oracleinternal.network.networkexception (0x000030f9): ora-12537 : netzwerksession: dateiende @ oracleinternal.network.readerstream.read(orabuf ob) @ oracleinternal.ttc.orabufreader.getdatafromnetwork() @ oracleinternal.ttc.orabufreader.read(boolean bignoredata) @ oracleinternal.ttc.marshallingengine.unmarshalub1(boolean bignoredata) @ oracleinternal.ttc.ttcprotocolnegotiation.readresponse()} i trying connect oracle 11g database , not have client installed on local machine. working test application (unmanaged) using oracle.dataaccess works fine . using system; using oracle.dataaccess.client; namespace app.odp.unmanaged { internal class program { private static void main(string[] args) { //dummy connection string...
Read more

matlab - Compression and Decompression of ECG Signal using HUFFMAN ALGORITHM -

i want compress , decompress ecg signal stored text message text file , find out file size, cr,prd ratio,and qs. here code compression , decompression of ecg signal using huffman algorithm. i'm trying find out file size, compression ratio,prd ratio,qs. but error i'm getting the ecg file in text format. %clearing variables , screen enter code here clear all; close all; clc; [file1]=uigetfile('*.txt'); %fprintf('enter ecg file name :%s',file1); p=file1; t=sprintf('%s',p); b1=dlmread([file1]); len=length(b1); lead=input('enter lead number :'); %lead=str2double(lead); col2=b1(1:end,lead); e=fix(sqrt(len)); m=1; i=1:e j=1:e g2(i,j)=fix(col2(m)*1000); %amplifying 1000 m=m+1; end end g3=g2; i=1:e j=1:e ...
Read more

utf 8 - split utf-8 string into bytes in python -

i trying split utf-8 string bytes in python 3. problem is, when use bytearray, byte, encode etc functions array size of element 14 bytes, not 1 byte expected. need split text file sequence of bytes , send them byte after byte using sockets. tried this: infile = open (file, "r") str = infile.read() byte_str = bytes(str, 'utf-8') print("size of byte_str",sys.getsizeof(byte_str[0])) print gives me 14, need 1... suggestion? quoting official documentation : sys.getsizeof(object[, default]) return size of object in bytes. object can type of object. built-in objects return correct results, not have hold true third-party extensions implementation specific. only memory consumption directly attributed object accounted for, not memory consumption of objects refers to. if given, default returned if object not provide means retrieve size. otherwise typeerror raised. getsizeof() calls object’s __sizeof__ method , adds ...
Read more