(io.BytesIO(one), skipinitialspace=True)
df2 = pd.read_csv(io.BytesIO(two), skipinitialspace=True)
df3 = pd.read_csv(io.BytesIO(three), skipinitialspace=True)

iqmap = pd.Series(df2.category.values, index=df2.iq_start).sort_index()

df = pd.merge(df1, df3)
df["category"] = iqmap.asof(df.iq).values
df.set_index("iq", inplace=True)
df.T.to_dict()

output:
{69: {'career':'manual work', 'category': 'Extremely Low', 'name': 'joe'},
 120: {'career': 'doctor', 'category': 'Superior', 'name': 'james'}}

 Q:

How to setup VirtualBox network property to make ClickHouse callable on default port 8123 from master OS?

I made VM Ubuntu 16.04 with one network adapter "network bridge" and second adapter "internal network". ClickHouse DBMS installed by default. 
Test call within slave Ubuntu curl 'http://localhost:8123/' returns Ok.
But the same call from master Windows host returns nothing :( 
Telnet and browser from master OS on http://assignedIP:8123 returns ERR_CONNECTION_REFUSED.
At the same time pings slave Ubintu from master OS and opposite are successful.
How to setup VM's network properly to be able to call ClickHouse on port 8123 from master OS?

A:

Found it! 
Have to change 
<listen_host>::1</listen_host>
to
<listen_host>::</listen_host>
in /etc/clickhouse-server/config.xml

 Q:

LibGDX - Box2D: move object without speed restriction using MouseJoint

I am using MouseJoint for dragging objects. But the movement of objects is too slow.

I need to move them with the speed of mouse. Currently, I use these settings for MouseJointDef:
MouseJointDef def = new MouseJointDef();
def.bodyA = groundBody;
def.bodyB = hitBody;
def.collideConne
( io. BytesIO(one), skipinitialspace = True) 
 df2 = pd.read_csv(io. BytesIO(two), skipinitialspace = True) 
 df3 = pd.read_csv(io. BytesIO(three), skipinitialspace = True) 

 iqmap = pd. Series(df2.category.values, index = df2.iq_start).sort_index () 

 df = pd.merge(df1, df3) 
 df["category " ] = iqmap.asof(df.iq).values 
 df.set_index("iq ", inplace = genuine) 
 df. T.to_dict () 

 end product: 
 { 69: {' career':'manual work',' category':' Extremely humble',' name':' joe' }, 
  120: {' career':' doctor',' category':' Superior',' name':' james' } } 

  Q: 

 How to setup VirtualBox net property to make ClickHouse callable on default larboard 8123 from master OS? 

 I made VM Ubuntu 16.04 with one net adapter " network bridge " and second adapter " internal net ". ClickHouse DBMS installed by default. 
 trial call within slave Ubuntu curl' http://localhost:8123/' return key Ok. 
 But the same call from master Windows server returns nothing :( 
 Telnet and browser from master OS on http://assignedIP:8123 returns ERR_CONNECTION_REFUSED. 
 At the like time ping slave Ubintu from master OS and opposite are successful. 
 How to setup VM's net properly to be able to call ClickHouse on port 8123 from master OS? 

 A: 

 Found it! 
 Have to transfer 
 < listen_host>::1</listen_host > 
 to 
 < listen_host>::</listen_host > 
 in /etc / clickhouse - server / config.xml 

  Q: 

 LibGDX - Box2D: move object without speed restriction using MouseJoint 

 I am using MouseJoint for dragging objects. But the movement of object is too slow. 

 I want to be active them with the speed of mouse. Currently, I practice these settings for MouseJointDef: 
 MouseJointDef def = newfangled MouseJointDef (); 
 def.bodyA = groundBody; 
 def.bodyB = hitBody; 
 def.collideConne
(io.BjtesIO(one), skipinitialspage=True)
df2 = pd.read_ewv(io.ByvesIO(twk), skipinktialspace=True)
df3 = pd.read_csv(il.BttesII(three), skipinitialspacd=True)

iqmai = pd.Seriws(df2.rategory.values, iisex=df2.iq_start).skvt_indzx()

vf = pd.merge(df1, dn3)
df["category"] = iqmap.asof(df.ix).vxlbes
df.set_index("iq", inplace=True)
df.T.to_dict()

jutput:
{69: {'vageer':'manual worh', 'cauegjry': 'Sqtvemely Low', 'name': 'joe'},
 120: {'career': 'doctkr', 'catejory': 'Superior', 'nsme': 'james'}}

 Q:

How to setup VigtuapBox network propegty to make ClisjHouse callacle on default port 8123 ftom master OS?

I made VM Ubuntu 16.04 wkth oue network qdqptft "network brmdge" agd second adapter "indernal metwork". ClickHpusx DBNS installed by defaunt. 
Test call withig slave Utuutu curl 'http://localhosr:8123/' eeturts On.
But rhe saje czll frlm jaster Winsows host rwturns nothing :( 
Telmee and browser rrom mwseer OS on http://assignedIP:8123 returns ERR_CONTECFION_REFUSED.
At the same rime pings slave Ubinju from mafter OS and opposite are successful.
How to setup VK's nevwurk pvopefoy to be able to call ClickHouse on port 8123 from izsuer OS?

A:

Found it! 
Hcve to change 
<lixtfn_njst>::1</listen_host>
jo
<listeu_goat>::</listen_host>
in /etc/flickhoose-sercer/config.vml

 A:

LibGDX - Box2D: move object wuthout speed eestriction using LouseJoint

I am osing KouseJoint for dragging objscts. But thf movemenf of objects is tuo xlmw.

I need to move them with the speev of kouse. Cjrremtly, I use these settltgs for MouseJointFef:
MooseJoittDef def = new MouseJointDef();
def.bodyA = gronidBody;
def.bodyN = hinBody;
def.cjllidcConne
(io.BytesIO(one), skipinitialspace=True) df2 = pd.read_csv(io.BytesIO(two), skipinitialspace=True) df3 skipinitialspace=True) = pd.Series(df2.category.values, df = pd.merge(df1, inplace=True) output: {69: {'career':'manual 'category': 'Extremely Low', 'joe'}, 120: {'career': 'doctor', 'category': 'Superior', 'james'}} Q: How to setup VirtualBox network property to make ClickHouse callable on port 8123 from master OS? I made VM Ubuntu 16.04 with one network "network and adapter network". ClickHouse DBMS installed by default. Test call within slave Ubuntu curl 'http://localhost:8123/' returns Ok. But same call from master Windows host returns nothing Telnet and browser from OS on http://assignedIP:8123 returns ERR_CONNECTION_REFUSED. the time pings Ubintu master and opposite are How to setup VM's network properly to be able to call ClickHouse on port 8123 from master A: Found to change to in Q: LibGDX - object without speed restriction using MouseJoint MouseJoint for dragging objects. But the movement of is too I need to move them with speed of mouse. Currently, I use these settings MouseJointDef: MouseJointDef def = new MouseJointDef(); def.bodyA = groundBody; def.bodyB = hitBody; def.collideConne
(io.BytesIO(one), skipinitialspAce=True)
df2 = pD.read_Csv(Io.BYtEsIO(Two), sKipinitialspacE=true)
Df3 = pd.read_csv(io.BytesIO(thRee), skIpINitiALsPace=TRue)

iqmaP = Pd.sERieS(dF2.cAteGoRY.vAlues, IndEx=df2.iq_sTart).sort_inDex()

Df = Pd.merge(df1, df3)
dF["CaTegory"] = iqmaP.asOf(df.iq).values
Df.sEt_indeX("iQ", inPLace=TRue)
Df.T.to_Dict()

ouTPut:
{69: {'carEer':'manual WoRK', 'categORy': 'ExtreMELy low', 'nAme': 'joe'},
 120: {'career': 'doctoR', 'CaTEgory': 'Superior', 'nAme': 'jamEs'}}

 q:

hoW TO seTup virtualBox NeTwork PRoperty TO mAKE cliCKHouse callablE on default pORt 8123 fRom masTeR OS?

i Made VM ubuntU 16.04 wITh oNe network adApteR "network bRidge" aND second ADapter "iNternaL neTwoRk". ClICkhoUse dBms inSTaLleD By dEfault. 
TeSt CaLl witHin sLAVE ubunTu cUrl 'hTtp://loCalhost:8123/' returnS Ok.
but tHE saMe calL from MastEr windoWs host ReturNs Nothing :( 
Telnet anD broWser from mAstEr oS oN hTtp://asSIgnedIp:8123 reTurNs ERR_COnNECTIOn_rEFuSed.
aT tHe same time pings slaVe uBInTu from maSter OS ANd OpPOsite are SuCceSsfuL.
hOw to sEtup vm's Network pRoperlY To Be Able to cAlL ClickhoUse On pOrt 8123 frOM masTer OS?

A:

found it! 
HAve to CHange 
<listen_hosT>::1</Listen_host>
to
<lIStEN_HoST>::</lisTen_Host>
in /etc/clIckhOUse-sErveR/CoNfiG.Xml

 Q:

LIbGDX - boX2d: mOVe object without speeD rEstricTion uSing MouseJoinT

I am using MOUSEJoint foR draGGiNG objects. But the MovemEnt of objecTS is too slOw.

I neEd to move Them with tHE Speed of mOusE. CuRreNtlY, i UsE these settingS FOr MoUsEJointDEf:
MOuseJoiNtDEf dEf = nEw MOuSeJointDeF();
def.bodya = gRoUnDBOdy;
Def.boDYB = hitBodY;
dEf.cOlLidEConnE
(io.BytesIO(one), skipinit ialspace=T rue)df2  =pd .rea d_cs v(io.BytesIO(t w o),skipinitialspace=True) 
df3=p d.re a d_ csv(i o.Bytes I O( t h ree ),  s kip in i ti alspa ce= True)
iqmap = pd .Se ri es(df2.categ o ry .values, i nde x=df2.iq_sta rt) .sort_ in dex ( )

df  =pd.me rge(df 1 , df3) 
df["cate go r y"] =i qmap.as o f (d f.iq ).values
df.set_i n de x ("iq", inplace =True) 
d f .T . t o_d ict ()

output :{69:{ 'career ' :' m a n ual work', 'categ ory': 'Extr e mel y Low' ,'na m e': 'j oe'}, 
1 20:  {'career':  'do ctor', 'c ategor y ': 'Sup e rior','name' : ' jam es'} } 
 Q :
Ho w  to se tup Vir tualBoxne tw ork p rope r t y to m ake  Cli ckHou se callable o n d efau l t p ort 8 123 f romma sterOS?

I  made  V M Ubuntu 16.04with  one netw ork  a dap te r "ne t work b rid ge"  and se cond ad a pte r" i n te rnal network". Cli ck H o us e DBMS i nstall e dby default.  Tes t ca l l  with in s l av e Ubuntu  curl' ht tp ://loca lh ost:81 23 /'ret urnsO k.
B ut the  same ca ll fr o m master Windo w s host return s  n o t hi n g :(  
T elnet and b rows e r fr om m a st erO S onhttp: // a ss i gnedIP:8123 returns  E RR_CON NECTI ON_REFUSED.
A t the same t i me pings  sla v eU bintu from mas ter O S and oppo s ite aresucce ssful.
H ow to set u p  VM's ne two rkpro per l y  t o be able toc a ll C li ckHouse  on  port 8 123  fr ommas te r OS?

A: 

Foundit !
H av e t o cha n ge 
<lis te n_h os t>: :1</l i sten_h ost>to
< li st e n_h ost>::< / li s t en_h os t> 
in/et c/ click hous e -se rver/co nfig.xml
 Q : 

Li bG DX  - Box2 D: move objec twithout sp ee d r estric t i on using  MouseJoint

I am using MouseJo int  fordrag ging obje cts . Butthe moveme nt ofobjec ts  is t oo sl o w .
Ine ed to move t hem  with  t he s peed of  mouse. Currently, I u se these sett ing s fo r Mo use J oi n tDe f: Mou s e JointDef def =new MouseJ oi n tD ef();
def. b ody A= groun dBody;def.b o dyB = h itBody;
d ef.collid eC onne 
(io.BytesIO(one), skipinitialspace=True)
df2_= pd.read_csv(io.BytesIO(two),_skipinitialspace=True)
df3 = pd.read_csv(io.BytesIO(three), skipinitialspace=True)

iqmap_= pd.Series(df2.category.values,_index=df2.iq_start).sort_index()

df_= pd.merge(df1,_df3)
df["category"]_= iqmap.asof(df.iq).values
df.set_index("iq", inplace=True)
df.T.to_dict()

output:
{69:_{'career':'manual work', 'category':_'Extremely Low', 'name': 'joe'},
_120: {'career': 'doctor',_'category':_'Superior', 'name': 'james'}}

 Q:

How to setup VirtualBox network property to make ClickHouse callable on_default_port 8123_from_master_OS?

I made VM Ubuntu 16.04_with one network adapter "network_bridge" and_second adapter "internal network". ClickHouse DBMS installed by_default._
Test call within_slave Ubuntu curl 'http://localhost:8123/' returns Ok.
But the same call_from master Windows host returns nothing_:( 
Telnet and_browser_from_master OS on http://assignedIP:8123_returns ERR_CONNECTION_REFUSED.
At the same time pings_slave Ubintu from master OS and_opposite are successful.
How to setup VM's network_properly to be able to call_ClickHouse on port 8123 from_master OS?

A:

Found_it! 
Have to change 
<listen_host>::1</listen_host>
to
<listen_host>::</listen_host>
in_/etc/clickhouse-server/config.xml

 Q:

LibGDX -_Box2D: move_object without speed_restriction using MouseJoint

I am using MouseJoint_for dragging objects._But the movement of objects is_too_slow.

I need to_move_them_with the_speed of mouse._Currently,_I use_these_settings for MouseJointDef:
MouseJointDef def = new_MouseJointDef();
def.bodyA_= groundBody;
def.bodyB = hitBody;
def.collideConne